Intellipaat Microsoft excel training: https://intellipaat.com/excel-training/ In this microsoft excel tutorial you will master how to use excel, complete ms excel formulas, excel tips and tricks, excel accounting, how to use excel vlookup, pivot table in excel, excel formulas and functions in detail. #ExcelTutorial #MicrosoftExcelTutorial #ExcelFollowing topics are covered in this video: 0:00 - Excel Tutorial 1:08 - Microsoft Excel Overview 4:52- Getting started with Microsoft Excel 5:33- Hands on with Microsoft excel 8:02 - Saving an Excel file 10:31- Excel Customization 13:21- Important areas of working 15:51- What is formula bar 19:18- ribbons 24:06- Formatting excel and shortcuts 33:04- Basic Formulas 50:00- Find and Replace 1:05:49- Text Functions-Formatting Data 1:39:25- count functions 1:40:45- Relative Reference 1:57:17- Absolute Reference 2:14:12- Mixed Reference 2:32:52- Data Validation 2:42:00- Different types of data validation 3:03:02- Conditional formatting 3:43:56- sorting data 4:06:15- filtering data 4:34:11- column chart 5:09:54- line chart 5:23:01- pie chart 5:36:51- protection 6:14:29- pivot tables 6:59:44- Vlookup 7:50:55- index function 7:51:51- Match function 8:30:39- lookup function 9:11:55- what is VBA 9:13:23- what is macro 9:14:37- Exploring Visual Basic Editor (VBE) 9:17:14- Using Macro Recorder 9:39:12- Recap 9:51:18- Variable, data types and constants 10:04:14- scope of a variable 10:15:09- Data Types 10:21:11- Constants Do subscribe to Intellipaat channel & get regular updates on videos: http://bit.ly/Intellipaat Watch top technologies video tutorials here: https://bit.ly/2IAtGl2 Read technologies tutorial here: https://bit.ly/1T3TUeKInterested to read about technological blogs? Please read here: https://bit.ly/31OX4vi Are you looking for something more? Enroll in our microsoft excel training & certification course and become a certified professional (https://intellipaat.com/excel-training/). It is a 24 hrs instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies. If you’ve enjoyed this microsoft excel training video, Like us and Subscribe to our channel for more similar informative videos. Got any questions about ms excel tutorial? Ask us in the comment section below. ---------------------------- Intellipaat Edge 1. 24*7 Life time Access & Support 2. Flexible Class Schedule 3. Job Assistance 4. Mentors with +14 yrs 5. Industry Oriented Course ware 6. Life time free Course Upgrade ------------------------------ Why microsoft excel is important? Microsoft Excel is the most-used spreadsheet program in the world. Excel can perform formula-based calculations and many other mathematical functions. The program also serves as a programming platform for Visual Basic for Applications. Because of its utility, Excel has become a staple in many enterprises. Why should you opt for a microsoft excel career? Microsoft Excel has proven to be advantageous for day to day business activities. The knowledge of Microsoft Excel has become essential for small business establishments to carry out their day to day business and reap the best results from their business. There is a huge demand for ms excel certified professional. The salaries for ms excel professional are also very good. ------------------------------ For more information: Please write us to sales@intellipaat.com or call us at: +91-7847955955 Website: https://intellipaat.com/excel-training/ Facebook: https://www.facebook.com/intellipaatonline/ LinkedIn: https://www.linkedin.com/in/intellipaat/ Twitter: https://twitter.com/Intellipaat