a:5:{s:8:"template";s:9184:"<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"/>
<meta content="text/html; charset=utf-8" http-equiv="content-type"/>
<meta content="IE=edge" http-equiv="X-UA-Compatible"/>
<meta content="width=device-width, initial-scale=1" name="viewport"/>
<title>{{ keyword }}</title>
<link href="https://fonts.googleapis.com/css?family=Roboto+Condensed%3A300%2C300i%2C400%2C400i%2C600%2C600i%2C800%2C800i&amp;subset=latin%2Clatin-ext" id="bulk-fonts-css" media="all" rel="stylesheet" type="text/css"/>
<style rel="stylesheet" type="text/css">@supports ((position:-webkit-sticky) or (position:sticky)){}@supports ((position:-webkit-sticky) or (position:sticky)){}@supports ((position:-webkit-sticky) or (position:sticky)){}p.has-drop-cap:not(:focus)::first-letter{float:left;font-size:8.4em;line-height:.68;font-weight:100;margin:.05em .1em 0 0;text-transform:uppercase;font-style:normal}p.has-drop-cap:not(:focus)::after{content:"";display:table;clear:both;padding-top:14px} @font-face{font-family:'Roboto Condensed';font-style:italic;font-weight:300;src:local('Roboto Condensed Light Italic'),local('RobotoCondensed-LightItalic'),url(https://fonts.gstatic.com/s/robotocondensed/v18/ieVg2ZhZI2eCN5jzbjEETS9weq8-19eDpCEoY9Nc.ttf) format('truetype')}@font-face{font-family:'Roboto Condensed';font-style:italic;font-weight:400;src:local('Roboto Condensed Italic'),local('RobotoCondensed-Italic'),url(https://fonts.gstatic.com/s/robotocondensed/v18/ieVj2ZhZI2eCN5jzbjEETS9weq8-19eLAQM4.ttf) format('truetype')}@font-face{font-family:'Roboto Condensed';font-style:normal;font-weight:300;src:local('Roboto Condensed Light'),local('RobotoCondensed-Light'),url(https://fonts.gstatic.com/s/robotocondensed/v18/ieVi2ZhZI2eCN5jzbjEETS9weq8-33mZGCoYag.ttf) format('truetype')}@font-face{font-family:'Roboto Condensed';font-style:normal;font-weight:400;src:local('Roboto Condensed'),local('RobotoCondensed-Regular'),url(https://fonts.gstatic.com/s/robotocondensed/v18/ieVl2ZhZI2eCN5jzbjEETS9weq8-19y7CA.ttf) format('truetype')} /*! normalize.css v3.0.3 | MIT License | github.com/necolas/normalize.css */html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}footer,nav{display:block}a{background-color:transparent}a:active,a:hover{outline:0}*{-webkit-box-sizing:border-box;-moz-box-sizing:border-box;box-sizing:border-box}:after,:before{-webkit-box-sizing:border-box;-moz-box-sizing:border-box;box-sizing:border-box}html{font-size:10px;-webkit-tap-highlight-color:transparent}body{font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;line-height:1.42857143;color:#333;background-color:#fff}a{color:#337ab7;text-decoration:none}a:focus,a:hover{color:#23527c;text-decoration:underline}a:focus{outline:5px auto -webkit-focus-ring-color;outline-offset:-2px}p{margin:0 0 10px}.text-center{text-align:center}ul{margin-top:0;margin-bottom:10px}.container{margin-right:auto;margin-left:auto;padding-left:15px;padding-right:15px}@media (min-width:768px){.container{width:750px}}@media (min-width:992px){.container{width:970px}}@media (min-width:1200px){.container{width:1170px}}.container-fluid{margin-right:auto;margin-left:auto;padding-left:15px;padding-right:15px}.row{margin-left:-15px;margin-right:-15px}.dropdown{position:relative}.dropdown-toggle:focus{outline:0}.nav{margin-bottom:0;padding-left:0;list-style:none}.nav>li{position:relative;display:block}.nav>li>a{position:relative;display:block;padding:10px 15px}.nav>li>a:focus,.nav>li>a:hover{text-decoration:none;background-color:#eee}.navbar{position:relative;min-height:50px;margin-bottom:20px;border:1px solid transparent}@media (min-width:768px){.navbar{border-radius:4px}}@media (min-width:768px){.navbar-header{float:left}}.container>.navbar-header{margin-right:-15px;margin-left:-15px}@media (min-width:768px){.container>.navbar-header{margin-right:0;margin-left:0}}.navbar-fixed-top{position:fixed;right:0;left:0;z-index:1030}@media (min-width:768px){.navbar-fixed-top{border-radius:0}}.navbar-fixed-top{top:0;border-width:0 0 1px}.navbar-brand{float:left;padding:15px 15px;font-size:18px;line-height:20px;height:50px}.navbar-brand:focus,.navbar-brand:hover{text-decoration:none}@media (min-width:768px){.navbar>.container .navbar-brand{margin-left:-15px}}.navbar-nav{margin:7.5px -15px}.navbar-nav>li>a{padding-top:10px;padding-bottom:10px;line-height:20px}@media (min-width:768px){.navbar-nav{float:left;margin:0}.navbar-nav>li{float:left}.navbar-nav>li>a{padding-top:15px;padding-bottom:15px}}@media (min-width:768px){.navbar-right{float:right!important;margin-right:-15px}}.navbar-default{background-color:#f8f8f8;border-color:#e7e7e7}.navbar-default .navbar-brand{color:#777}.navbar-default .navbar-brand:focus,.navbar-default .navbar-brand:hover{color:#5e5e5e;background-color:transparent}.navbar-default .navbar-nav>li>a{color:#777}.navbar-default .navbar-nav>li>a:focus,.navbar-default .navbar-nav>li>a:hover{color:#333;background-color:transparent}.container-fluid:after,.container-fluid:before,.container:after,.container:before,.nav:after,.nav:before,.navbar-header:after,.navbar-header:before,.navbar:after,.navbar:before,.row:after,.row:before{content:" ";display:table}.container-fluid:after,.container:after,.nav:after,.navbar-header:after,.navbar:after,.row:after{clear:both}@-ms-viewport{width:device-width}body,html{overflow-x:hidden}body{font-family:'Roboto Condensed',"Helvetica Neue",helvetica,arial,sans-serif;padding:0;color:#404040;font-weight:400;line-height:1.8;font-size:16px;word-wrap:break-word;overflow-x:hidden}a,a:active,a:focus,a:hover{text-decoration:none;color:#0090ff}ul{padding-left:20px}a:active{border-bottom:none}.page-area{padding-top:70px}@media (min-width:768px){.navbar-nav>li>a{padding-top:25px;padding-bottom:25px;transition:all .5s ease-in-out;-moz-transition:all .5s ease-in-out;-webkit-transition:all .5s ease-in-out;-o-transition:all .5s ease-in-out}#site-navigation .container{padding-left:0;padding-right:0}}@media (max-width:767px){.navbar-nav a:focus,.navbar-nav a:hover{color:#fff!important;background-color:#000!important}.menu-container{width:70%;position:absolute;left:0;height:100vh;transform:translate3d(-100%,0,0);overflow-y:auto;overflow-x:auto;background-color:#fff;top:100%}.navbar-brand{padding-right:55px!important}.page-area{left:0;transform:translate3d(0,0,0);transition:transform .5s ease}.navbar-nav{padding:0;margin:0}.navbar-nav a{font-size:14px;padding:12px 10px!important;margin:0!important;line-height:16px!important;float:left!important;margin:0!important;width:100%;text-transform:none!important;word-wrap:break-word;white-space:normal!important}.navbar-nav li{padding:0!important;margin:0!important}}#site-navigation{min-height:70px}.navbar-nav>li>a{border-bottom:0;text-transform:uppercase}.site-title{margin:0;padding:0;font-size:22px;line-height:28px}p.site-description{font-size:13px;line-height:18px;margin:0;-webkit-transition:all .5s ease;transition:all .5s ease}.site-branding-logo{float:left}.site-branding-logo a{border:none;z-index:9999;position:relative}.navbar-brand{padding:10px 15px;height:auto;z-index:99999;position:relative;z-index:1}.navbar{margin-bottom:0}.main-menu{position:relative}.navbar-fixed-top{position:absolute}#site-navigation{background-color:#fff;-webkit-box-shadow:0 10px 20px -12px rgba(0,0,0,.42),0 3px 20px 0 rgba(0,0,0,.12),0 8px 10px -5px rgba(0,0,0,.2);box-shadow:0 10px 20px -12px rgba(0,0,0,.42),0 3px 20px 0 rgba(0,0,0,.12),0 8px 10px -5px rgba(0,0,0,.2);border:none}#site-navigation,nav a{-webkit-transition:all .3s ease;transition:all .3s ease;color:#000}.footer-credits{border-top:1px solid #ccc;padding:15px;clear:both;margin-top:20px;background-color:#fff}</style>
 </head>
<body class="wp-custom-logo" id="blog">
<div class="main-menu">
<nav class="navbar navbar-default navbar-fixed-top" id="site-navigation">
<div class="container">
<div class="navbar-header">
<div class="site-header">
<div class="site-branding-logo">
<a class="custom-logo-link" href="#" itemprop="url" rel="home"></a> </div>
<div class="site-branding-text navbar-brand">
<p class="site-title"><a href="#" rel="home">{{ keyword }}</a></p>
<p class="site-description">
{{ keyword }}</p>
</div>
</div>
</div>
<div class="menu-container"><ul class="nav navbar-nav navbar-right" id="menu-menu-1"><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-72 dropdown" id="menu-item-72"><a class="dropdown-toggle" data-toggle="dropdown" href="#" title="Projects">Projects</a>
</li>
<li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-73 dropdown" id="menu-item-73"><a class="dropdown-toggle" data-toggle="dropdown" href="#" title="About">About</a>
</li>
<li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-74" id="menu-item-74"><a href="#" title="Contacts">Contacts</a></li>
</ul></div> </div>
</nav>
</div>
<div class="page-area">	
{{ text }}
<br>
<br>
{{ links }}
</div>
<footer class="footer-credits container-fluid row" id="colophon">
<div class="container">
<p class="footer-credits-text text-center">{{ keyword }} 2020</p>
</div>
</footer>
</body>
</html>";s:4:"text";s:11145:"Thank you! Hey! You can format data in Excel to make it look better and to highlight some data points. is there a restriction in the number of times that once can view a particular video lesson? This is nice I m a engineer so plz teach me only chart, diagram,engineering related video, Thanks for the videos, your method of explanation is very superb. If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. Thanks again. However the second video doesn’t show. What’s is point of having a credit card if the thing would not work across regions ? Do I need to access via google or IE? Thank you Sir, it is very useful for me to know about Excel as I am working on Excel in my office and it will be very useful for me. This course is designed for people who are preparing for an interview. Thanks in advance, May i learn the Macros in this Excel Program as well. As there are a lot of features in Microsoft Excel, learning it could be kind of overwhelming. When I click on a grey bar, it expands with a detail of the contents of the lesson, but I can’t see any video or link to same. Please send me link, I am interested on it. Thank you so much Sumit. Thanks sumit … all videos are great and very helpful…. Then, I found this course just in the menu and it’s exactly what I’ve been wanting to do, like literally at the top of my list but just did not ever know when or where I could because of the time and just trying to learn so much such as Command Prompt and what that can do you for you. Is there a video for Power BI. Glad you’re finding the training useful Fran, Great job! Build Your Excel Skills. Since this is a free course available for all, you won’t be given a certificate. Wonderful learning tool for work experience, I don’t find any video link in this page…. I’m only on the third lesson so far but I find your instruction clear and logical in it’s presentation. I’m a Nutrition student in college and excel is extremely useful <3. And I've been using Excel, and tools like it, for more than 30 years! I was looking for a way to learn Excel for free. I tried to clean data by using the methods suggested by you in one of your lesson. This is a fantastic gift to all the human race. Thanks for the kind wors Kristin… Glad you’re finding this Excel course useful! Thank you for the course Sir, it is really useful. The best way to learn Excel is to break it down into bite-size components. You can just scroll up and start watching the videos and learn Excel. For someone who has never been able to use Excel, your training is just so simple and easy to understand. THANKS SO MUCH FOR THIS FREE COURSE I LOVE YOUR VOICE TOO❤❤❤, thanks for this complete course on excel learned a lot…. Sorry, unable to find the ‘customize the ribbon’ toolbar in 2007 excel. Mr. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way. In this video of this Free Online Excel Training, you’ll learn how to use Excel tables. I will also recommend to my office staffs, senior’s, collegiate, friends and our business partners. How do I get access to the worksheets used in the videos? Wonder you have free online course for Microsoft word training just like this excel course. Be prepared! thank you so much. They were extremely helpful. Thanks in advance. In addition to my current role as VP Information Business Services, I've been a global project manager for the deployment of very large IT systems, a senior statistician/data scientist, a university instructor and a corporate trainer. Ctrl + Shift +  “+” is used for inserting the cells. In this video of this Free Online Excel Training, you’ll learn how to manage worksheets in Excel. I am in intermediate status. Happy learning! I will give you tip at the end of the course. It is really fantastic to have access at this great content. in mixed reference moving from $A$12 to $B$12, considering different column (i.e from A to B) but same number cell i,e (12) in this case i tried on my excel but i am not able to move from A to B by removing the ($) sign before A by pressing only (F4). It is frequently used when you need to copy the sheet to another sheet. I am an older adult who ‘missed the train’ on this kind of information. The course is just 36 minutes - you can finish it over a lunch break! I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. I am your fan nowonwards. Sumit You are truly an MVP. Truly appreciate the time and effort you put in to this for free! Thank you for this! After logging in you can close it and return to this page. Sumit’s style of teaching gives you exactly what you need w/o all the extra talk. Wow I love learning opportunities as this hope to really know this Excel. very useful and I am are learning very short cut formulas for faster execution of work in excel. Sumit, as I mentioned in an earlier comment, I am fully retired 5 years now. Very nice way of give training with so much examples & practicality. I am from Pakistan. I learnt a lot and appreciate your Teaching skills. How to count that How much AHU, Chiller & Boiler’s point in my sheet. I bring a unique perspective to Excel and business analytics. but that does not solve the problem. Where can I download the videos used in the course? Thank You soo much for providing this free course. I’m looking for tutorials on what to do say when you run a SQL query and have a huge data dump in excel . I can’t find a dialogue box in Excel on Mac. thank you soooo much!!! I thank Mr. Sumeet Bhansal for giving me such a lucid training where in got to know the easiness in understanding the excel formats quickly. If not what books do you recommend to learn Excel for work? I am now 65. I was a teacher and hope to be a student of you very soon. If you still don’t see the videos, you can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6, Thanks for commenting Zayar! And it’s free! Can’t wait to get started, an 81 year old. Dear Sir, I need help in conditional formatting. The wonderful thing is you can keep going back to refresh things you may have forgotten. This is what I was looking for to learn in my life. I have also been recognized as an Excel MVP by Microsoft for my passion to learn and teach people on using Excel the right way. Live long. Hello Lisa.. Good working knowledge of Excel should definitely help you get a job. Apart from this, it also covers the auto-fill in Excel as well as number formatting. This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying. Maybe add a donate button or something so people that want to can show their appreciation with moolah! More than just an average youtuber. 2. How to format text and numbers. It is very useful. Is there any assessment that I need to give after completing the training? Can I get any kind of proof that I completed the modules at the end? AOK now. I practice these everyday. I want do that. Do you mind if I make a post regarding your site on LinkedIn or on twitter? Hello I am reviewing your free excel training course. Thanks, Dear Mr.Sumit, I need a small solution for my Xl Table I need to change the Data (Rate of Interest in the cells) in one column for a particular period in another column (01-04-2019 to 31-03-2020)only Kindly help me solve this problem Regards S D N Murthy, Hi, can you provide some sort of evidence if I complete the 12 hours course. If I complete all these videos and practice, will I be able to operate basic to intermediate excel ? This is a great match for me. Excel Quick Start Tutorial: 36 Minutes to Learn the Basics. Can you please upload a video on mail merge particularly with many-to-one option. Cannot open your lessons for Excel Basics. Thanks a lot for this free excel training course. You can also watch the course videos here – https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6. I may have a Freelance job for you in our firm of Chartered Accountants & Property Tax Consultants in London UK. Do you provide a certificate of completion? Unfortunately, I don’t see any video to watch. Note that Excel in-built security feature is not very strong and you can easily open worksheets/workbooks that have been locked. You are a fantastic man to offer your services to educate those that need to learn about excel …. Thanks for commenting Rachael! Do you also provide certificate after conplication of this course. I am very eager to learn this and don’t see the tutorials yet. Yes. Lesson 12 - Lookup and Reference Formulas in Excel, Use VLookup to Get the Last Number in a List in Excel, Lookup the Second, the Third, or the Nth Value in Excel, Find the Last Occurrence of a Lookup Value a List in Excel, Find Position of the Last Occurrence of a Character in a String in Excel, Lesson 15 - Date and Time Formulas in Excel, Calculate Number of Days between two dates, How to Remove Time from Date/Timestamp in Excel, Lesson 16 - Formulas Mix and Match (10 Examples), How to Compare Two Excel Sheets (for differences), Extract Data from Drop Down List Selection in Excel, Select Multiple Items from a Drop Down List in Excel, Creating a Dynamic Excel Filter Search Box, Display Main and Subcategory in Drop Down List in Excel, Using a Radio Button (Option Button) in Excel, Lesson 19 - Data Sorting and Filtering in Excel, Sort Data in Alphabetical Order Automatically, Lesson 20 - Using Conditional Formatting in Excel, Find Duplicates using Conditional Formatting, Search and Highlight Data Using Conditional Formatting, Lesson 21 - Introduction to Excel Charting, Lesson 22 - 10 Advanced Excel Charting Examples, Spotting Data in a Scatter Chart in Excel, Lesson 24 - Overview of Excel Pivot Table, click here to check out all my Pivot Table tutorials, Creating a Pivot Table in Excel – A Step by Step Tutorial, How to Filter Data in a Pivot Table in Excel, How to Group Dates in Pivot Tables in Excel, How to Group Numbers in Pivot Table in Excel, How to Apply Conditional Formatting in a Pivot Table in Excel, Using Slicers in Excel Pivot Table – A Beginner’s Guide, How to Add and Use an Excel Pivot Table Calculated Field, Pivot Cache in Excel – What Is It and How to Best Use It, Lesson 26 - Introduction to Macros and VB Editor, Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit), Using Workbook Object in Excel VBA (Open, Close, Save, Set), Understanding Excel VBA Data Types (Variables and Constants), Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples), If Then Else Statement in Excel VBA (explained with examples), For Next Loop in Excel VBA – A Beginner’s Guide with Examples, How to Assign a Macro to a Button in Excel. ";s:7:"keyword";s:23:"how to learn excel fast";s:5:"links";s:990:"<a href="http://newdestinychurchpc.com/blog/article.php?tag=trouble-with-the-curve-true-story-6bb478">Trouble With The Curve True Story</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=you-look-good-gif-6bb478">You Look Good Gif</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=mat-franco-instagram-6bb478">Mat Franco Instagram</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=how-to-manage-landslide-6bb478">How To Manage Landslide</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=taylor-swift-net-worth-2020-forbes-6bb478">Taylor Swift Net Worth 2020 Forbes</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=jerry-trainor-married-6bb478">Jerry Trainor Married</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=127-hours-watch-online-6bb478">127 Hours Watch Online</a>,
<a href="http://newdestinychurchpc.com/blog/article.php?tag=brinks-home-security-logo-6bb478">Brinks Home Security Logo</a>,
";s:7:"expired";i:-1;}