Excel Course ( Basics to Advanced)

Modules Covered in this Excel Training
 
MODULE 1 - EXCEL BASICS (for Beginners)
Module 2 - EXCEL ESSENTIALS
MODULE 3 - EXCEL FORMULAS
MODULE 4 - DATA ANALYSIS
MODULE 5 - INTRODUCTION TO EXCEL CHARTING
MODULE 6 - PIVOT TABLE
MODULE 6 - EXCEL EXTRAS
ABOUT THE INSTRUCTOR
FAQs about this FREE Online Excel Training

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

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:

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

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.