LEARN Adv. EXCEL
26 Lessons, 12+ hours of Excel Training
Scroll Down and Start Learning
If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.
This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning).
You don’t need to sign-up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel.
To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. I have also divided these into 7 modules.
NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen)
In case you’re an intermediate or advanced user, feel free to pick the lessons you want to watch.
Also, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).
Modules Covered in this Advance Excel Training
- Filteration of Data
- Pivot Table
- MIS Report
- Analis Reports
- Logical Function
- Validation of Data
- Conditional Formatting
- Micro with VB
- Math and Trig
- Micro
- H Lookup
- V Lookup
- Database
- Frontand
- Backand
MODULE 1 – EXCEL BASICS (for Beginners)
In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.
Module 2 – EXCEL ESSENTIALS
MODULE 3 – EXCEL FORMULAS
MODULE 4 – DATA ANALYSIS
Here are some additional tutorials about Data Analysis:
- One Variable Data Table
- Two Variable Data Table
- Goal Seek in Excel
- Scenario Manager in Excel
- Using Solver in Excel
MODULE 5 – INTRODUCTION TO EXCEL CHARTING
In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.
MODULE 6 – PIVOT TABLE
MODULE 6 – EXCEL EXTRAS
Here are some additional useful basic Excel tutorials:
- Clean Data in Excel
- Excel Interview Questions (with answers)
- Working with Gridlines in Excel
- Inserting a Watermark in the Worksheet
- Setting the Print Area in Excel
- Best Excel Books
ABOUT THE INSTRUCTOR
I am Sumit Bansal, your instructor for this Excel Training. I have been training people in basic/advanced Excel and dashboards for more than 10 years now.
I have also been honored with the Microsoft Excel MVP status for my expertise in Excel.
Learning Excel becomes a cake walk when you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.
In this Excel course, I’ve focussed on giving you a structured and comprehensive learning experience. It makes sure you have a rock-solid foundation and then covers advanced Excel concepts that will make you an Excel Wizard.
When you’re done with the course, I guarantee you’ll be able to do a lot more in Excel in a fraction of the time.