itech

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

 
  1. Filteration of Data
  2. Pivot Table
  3. MIS Report
  4. Analis Reports
  5. Logical Function
  6. Validation of Data
  7. Conditional Formatting
  8. Micro with VB
  9. Math and Trig
  10. Micro
  11. H Lookup
  12. V Lookup
  13. Database
  14. Frontand
  15. 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.