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).

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)

Lesson 1 – Getting Started with Excel

Lesson 2 – Data Entry, Data Editing, and Number Formatting

Lesson 3 – Data Formatting

Lesson 4 – Working with Cells and Ranges in Excel

Lesson 5 – Managing Worksheets

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

Lesson 6 – Introduction to Excel Tables

Lesson 7 – Auto-fill, Custom Lists, and Flash Fill

Lesson 8 – Number Formatting in Excel

MODULE 3 – EXCEL FORMULAS

Lesson 9 – Excel Formula Basics

Lesson 10 – Logical Formulas in Excel

Lesson 11 – Math Formulas in Excel

Lesson 12 – Lookup and Reference Formulas in Excel

Lesson 13 – Stats Formulas in Excel

Lesson 14 – Text Formulas in Excel

Lesson 15 – Date and Time Formulas in Excel

Lesson 16 – Formulas Mix and Match (10 Examples)

MODULE 4 – DATA ANALYSIS

Lesson 17 – Named Ranges in Excel

Lesson 18 – Data Validation in Excel

Lesson 19 – Data Sorting and Filtering in Excel

Lesson 20 – Using Conditional Formatting in Excel

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

Lesson 21 – Introduction to Excel Charting

Lesson 22 – 10 Advanced Excel Charting Examples

Lesson 23 – Dynamic Charts in Excel

MODULE 6 – PIVOT TABLE

Lesson 24 – Overview of Excel Pivot Table

MODULE 6 – EXCEL EXTRAS

Lesson 25 – Protection in Excel

Lesson 26 – Introduction to Macros and VB Editor

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.