FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)

Sumit Bansal
Written by
Sumit Bansal
Sumit Bansal

Sumit Bansal

LinkedIn YouTube

Sumit Bansal is the founder of TrumpExcel.com and a Microsoft Excel MVP. He started this site in 2013 to share his passion for Excel through easy tutorials, tips, and training videos, helping you master Excel, boost productivity, and maybe even enjoy spreadsheets!

26 Lessons, 12+ hours of Free Excel Training (Videos)
Absolutely FREE | No Sign-up Needed | 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, if you have any questions or feedback for me, kindly leave it in the comments area (at the bottom of this page).

In case you find the videos useful and would like to support me, you can buy me a coffee ☕

MODULE 1 – EXCEL BASICS (for Beginners)

Lesson 1 – Getting Started with Excel

This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area.

In this video, you’ll learn about the following topics:

  • Structure of the Excel working area,
  • How to navigate in Excel,
  • Ribbons and tabs,
  • Quick Access Toolbar (QAT)
  • Dialog Box & Task Panes,
  • Customizing ribbons and QAT,
  • What is an active cell
  • How to use ALT shortcuts

Related Excel Articles:

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

Once you are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.

You can enter three types of data in Excel – numeric, text, and formulas.

To enter data in any cell, just select the cell and start typing. Once done, press enter to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).

This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).

Apart from this, it also covers the auto-fill in Excel as well as number formatting.

Related Excel Articles:

Lesson 3 – Data Formatting

⬇️ Click here to download the example Excel file

This video covers the basics of data formatting in Excel.

You can format data in Excel to make it look better and to highlight some data points. For example, if you have a data set and you want to highlight the negative numbers, you can simply highlight it in red color to it.

Here are some of the common formatting I use to make my data look better and more readable

  • Applying borders to all cells
  • Making headers bold
  • Giving a background cell color to headers.
  • Center align the headers
  • You can find these options in the ‘Home’ tab in the ‘Font’ category.

Related Excel Articles:

Lesson 4 – Working with Cells and Ranges in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you’ll learn how to work with cells and ranges in Excel.

Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.

And this video will teach you exactly that.

It covers the following topics:

  • Cell address nomenclature
  • Selecting cell/ranges in Excel
  • Copying and moving cells/ranges in Excel
  • Using paste special
  • Selecting special cells
  • Using find and replace to select cells
  • Adding comments and
  • Using quick analysis

Related Excel Articles:

Lesson 5 – Managing Worksheets

⬇️ Click here to download the example Excel file

In this Free Online Excel Training video, you’ll learn how to manage worksheets in Excel.

It covers the following topics:

  • Navigating through worksheets in Excel
  • Changing worksheet name and color
  • Adding/deleting worksheets
  • Hiding/Un-hiding worksheets
  • Moving/copying worksheets
  • Comparing worksheets side by side
  • Splitting worksheet into panes
  • Freeze panes
  • Saving and opening workbooks

Related Excel Articles:

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

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you’ll learn how to use Excel tables.

Excel tables are amazing, especially if you plan to work with a lot of data/dashboards/models. 

In this video, I cover the following topics:

  • Creating an Excel Table
  • Excel Table features
  • Structured references
  • Table slicers

Note that table slicers became available only from Excel 2013 version onward.

Related Excel Articles:

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

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you will learn about tools that can help you when working with data in Excel.

In this lesson, I cover the following topics:

  • Autofill: This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
  • Custom Lists: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
  • Flash Fill: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern

Related Excel Articles:

Lesson 8 – Number Formatting in Excel

In this video of this Free Online Excel Training, you will learn all about number formatting in Excel.

This video covers the following topics:

  • How to access number formatting options
  • Using number formatting options using a dialog box
  • Using custom number formatting

Remember that formatting a number in Excel only changes how it’s displayed, but the underlying value remains the same.

Related Excel Articles:

MODULE 3 – EXCEL FORMULAS

Lesson 9 – Excel Formula Basics

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you will learn how to get started with Excel formulas.

This video covers the following topics:

  • Constituents of Excel formula
  • Operators in formulas
  • Entering a formula in Excel
  • Editing a formula
  • Absolute/relative cell references
  • Copying/pasting formulas in Excel, and
  • Formula auditing and debugging.

Related Excel Articles:

Lesson 10 – Logical Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you will learn about the following logical formulas:

  • AND function
  • OR function
  • NOT function
  • TRUE function
  • FALSE function
  • IF function
  • IFERROR function
  • IS function

Related Excel Articles:

Lesson 11 – Math Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel Training, you will learn about the MATH formulas

  • INT function
  • MOD function
  • RAND function
  • RANDBETWEEN function
  • ROUND function
  • SUM function
  • SUMIF function
  • SUMIFS function
  • SUMPRODUCT function

Related Excel Articles:

Lesson 12 – Lookup and Reference Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:

  • VLOOKUP function
  • HLOOKUP function
  • INDEX function
  • MATCH function
  • OFFSET function
  • INDIRECT function
  • ROW function
  • ROWS function
  • COLUMN function
  • COLUMNS function

Related Excel Articles:

Lesson 13 – Stats Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel Training, you will learn about the following STAT formulas:

  • AVERAGE function
  • AVERAGEIF function
  • AVERAGEIFS function
  • COUNT function
  • COUNTA function
  • COUNTBLANK function
  • COUNTIF function
  • COUNTIFS function
  • LARGE function
  • SMALL function
  • RANK function
  • MAX function
  • MIN function

Related Excel Articles:

Lesson 14 – Text Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel Training, you will learn about the following TEXT formulas:

  • LEFT function
  • RIGHT function
  • MID function
  • LEN function
  • LOWER function
  • PROPER function
  • UPPER function
  • FIND function
  • REPLACE function
  • SUBSTITUTE function
  • TEXT function

Related Excel Articles:

Lesson 15 – Date and Time Formulas in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel Training, you will learn about the following DATE and TIME formulas:

  • DAY function
  • HOUR function
  • MINUTE function
  • DATE function
  • DATEVALUE function
  • TODAY function
  • NOW function
  • WEEKDAY function
  • NETWROKDAYS function
  • NETWORKDAYS.INTL function
  • WORKDAY function
  • WORKDAY.INTL function

Related Excel Articles:

Lesson 16 – Formulas Mix and Match (10 Examples)

⬇️ Click here to download the example Excel file

In this video of this Free Excel Training, I will show you some advanced formula examples that involves using one or more than functions.

I cover the following topics this video:

  • Compare Lists, Get Unique List
  • Get the Closest Match
  • Get Last Value in the List
  • Find Last Occurrence of an Item in a List
  • 2 Way and 3 Way Lookup using Index/Match
  • Count the Number of Words
  • Extract Username from Email Id
  • Find the First Monday of the Month
  • Extract Data using Drop Down List

Related Excel Articles:

MODULE 4 – DATA ANALYSIS

Lesson 17 – Named Ranges in Excel

In this video of this Free training, you will learn about using Named Ranges in Excel.

It covers the following topics:

  • Creating Named Ranges
  • Managing Named Ranges
  • Important Keyboard Shortcuts
  • Creating Dynamic Named Ranges using OFFSET and INDEX formulas

Related Excel Articles:

Lesson 18 – Data Validation in Excel

In this video of this Free training, you will learn about using data validation and drop-down lists.

It covers the following topics:

  • Data Validation Criteria
  • Input Message
  • Customizing Error Messages
  • Circle Invalid Entries
  • Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List)

Related Excel Articles:

Lesson 19 – Data Sorting and Filtering in Excel

⬇️ Click here to download the example Excel file

In this video of this Free training, you will learn about data sorting and filtering in Excel. It covers the following topics:

  • Data Sorting
  • Multi-Levels of Sorting
  • Data Filtering
  • Advanced Filtering
  • Filtering and Sorting in Excel Data Tables

Related Excel Articles:

Lesson 20 – Using Conditional Formatting in Excel

In this video of this Free training, you will learn about the amazing conditional formatting.

It covers the following topics:

  • Introduction to Conditional Formatting
  • Using Formula in Conditional Formatting
  • Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)

Related Excel Articles:

Here are some additional tutorials about Data Analysis:

MODULE 5 – INTRODUCTION TO EXCEL CHARTING

Lesson 21 – Introduction to Excel Charting

In this video of this Free training, you will learn about Excel charting and how to make useful charts quickly. 

Excel has a lot of inbuilt charts that you can use instantly to visualize your data. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.

It covers the following topics:

  • Excel Chart Types
  • Chart Editing
  • Formatting Chart Elements
  • Combination Charts
  • Handling Gaps in Charts

Related Excel Articles:

Lesson 22 – 10 Advanced Excel Charting Examples

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.

The following advanced charts are covered in this video:

Related Excel Articles:

Lesson 23 – Dynamic Charts in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.

Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button.

This video covers two detailed examples of creating dynamic charts from scratch.

Example 1 â€“ Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.

Example 2 â€“ Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a drop-down list that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis

Related Excel Articles:

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

Lesson 24 – Overview of Excel Pivot Table

⬇️ Click here to download the example Excel file

In this video of this Free training, I will show you how to create and use Pivot Tables in Excel. 

The video covers the following topics:

  • Introduction to Pivot Tables
  • Creating a Pivot Table in Excel
  • Formatting the Pivot Table
  • Grouping data in an Excel Pivot table
  • Calculated Field/Items in Pivot Table
  • Pivot Table Slicers
  • Pivot Charts

Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. Even if you’re using Excel for the first time, you can quickly get a hang of it.

In this video, I try to cover a lot about the Pivot Table. In case you want to learn more, click here to check out all my Pivot Table tutorials.

This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section.

Related Excel Articles:

MODULE 6 – EXCEL EXTRAS

Lesson 25 – Protection in Excel

In this video of this Free Excel training, I will show you how you can lock cells or protect worksheets and workbooks in Excel.

You can protect cells, worksheets, and workbooks in Excel with a password (or without one). Once a worksheet is protected, you’ll need to enter the password to access it (in case a password has been applied).

Note that Excel in-built security feature is not very strong and you can easily open worksheets/workbooks that have been locked. However, if you want to quickly protect it before sending it to your manager/client (so they don’t end up changing anything by mistake), it works well.

Related Excel Articles:

Lesson 26 – Introduction to Macros and VB Editor

In this video, I will give you a quick introduction to Excel macros and the VB Editor in Excel.

By recording a macro in Excel, you can easily automate a lot of tasks. And the best part is that you don’t need to know any coding or VBA to do this.

When you record a macro, Excel simply follows whatever you do in the workbook and create a code for it. Now you can run this code and Excel will automatically follow all the steps you showed it.

If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn.

This video lesson covers the following VBA topics:

  • How to record a macro in Excel
  • Absolute and Relative Cell References
  • Introduction to the Visual Basic Editor.

Related Excel Articles:

Here are some additional useful basic Excel tutorials:

ABOUT THE INSTRUCTOR

Sumit Bansal Excel MVP Trump Excel

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

FAQs about this FREE Online Excel Training

Is this course really free?

Yes, it is! You can just scroll up and start watching the videos and learn Excel.

You don’t need to sign up for anything or pay for anything. This training is completely free and covers most of the Excel topics you need to get started and become a pro.

You get to watch each and every lesson absolutely free (and as many times as you want).

All you need is a decent internet connection.

Can I download the videos?

No, you can only watch the videos online. These videos can not be downloaded.

However, this FREE Excel training is available to watch as many times as you want.

Which version of Excel is used to create this course?

I have used the Excel 2013 to record these videos.

Almost everything covered in this free course will work for all the Excel versions (2007, 2010, 2013, 2016, 2019, and even Excel 365).

There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013)

Who is the instructor of this Excel training?

My name is Sumit Bansal and I am your instructor throughout this FREE online Excel training.

I have practically been in a relationship with Excel since 2007. My aim in this course is to give you the best possible Excel learning (absolutely free).

I have been highly passionate about learning and teaching Excel and have trained thousands of Excel enthusiasts to use Excel the most efficient way.

I have also been recognized as an Excel MVP by Microsoft for my passion to learn and teach people on using Excel the right way.

Hey! I'm Sumit Bansal, founder of trumpexcel.com and a Microsoft Excel MVP. I started this site in 2013 because I genuinely love Microsoft Excel (yes, really!) and wanted to share that passion through easy Excel tutorials, tips, and Excel training videos. My goal is straightforward: help you master Excel skills so you can work smarter, boost productivity, and maybe even enjoy spreadsheets along the way!

601 thoughts on “FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)”

  2. Great job! One question, I am calculation the available FTE per month with Excel Leave Tracker Template, I have to use the # of work days, how I am going to calculate this value and use it in the summary table. Thank you

    Reply

  5. Hi Sumit,

    Thank you so much for this structured and comprehensive Excel Tutorials which I found very informative, and the best part of it is that it is totally free. I really appreciate your time and effort giving an opportunity for those who need this materials, including myself. I believed this free Excel Tutorials will help me a lot to land my home-based job.

    Thanks once again and God bless your knowledge and expertise.

    Reply

  7. Hello Sumit, I like how you have divided the course into different modules and videos. I have done accounting and finance in the past so I feel this is really needed for my growth and career. If I complete all these videos and practice, will I be able to operate basic to intermediate excel ?

    Reply

    • Hello Shriya.. Glad you found the course useful. Yes, you would be able to handle basic to intermediate tasks in Excel after watching the videos and going through the practice files.

      Reply

      • Thank you Sumit. Also wanted to ask you, I use Macbook so there are few things which are different in Excel in Macbook. If possible can you upload
        a video where you mention those few differences. For eg. I can’t find a dialogue box in Excel on Mac. Can you help me with that.

        Reply

  11. I want and NEED a good part-time office job but don’t have the computer skills that many jobs require and have liked working with numbers in the past.

    Reply

  12. You are a fantastic man to offer your services to educate those that need to learn about excel …. for free. How refreshing it is to hear you speak (not too fast, nor too slow) in a manner that is clear and understanding. Thank you most kindly.

    Reply

  14. Hello Mr. Sumit,

    I am unable to find “Developer tab” and “Customizing Ribbon and QAT” options in Excel 2007 . Kindly help me how can I access these options ?

    Reply

  15. Is this a certification course ? If not, then what should we do to get a certificate for our learnings ?

    Reply

  17. I created some data in Sheet 1, Cell A1 (in Excel 2016), and I linked these contents of Sheet 1 to Sheet 2, Cell A1. I created a link to enable the contents of Sheet 1 (Cell A1) to appear automatically in Sheet 2 so that whenever I change the contents of Sheet 1, the same automatically changes in Sheet 2. To quickly go back to Sheet 1 (where the original data is contained), I used DOUBLE-CLICK method and, as expected, Excel immediately moved back to Sheet 1, Cell A1.

    However, when I use my laptop at home (also Excel 2016) and try to DOUBLE-CLICK when I am in Sheet 2 in order to quickly go back to Sheet 1, Cell A1, instead of linking me to Sheet 1, the cursor is just blinking in Sheet 2.

    Question:
    How do I change the settings of my laptop at home to enable me jump from Sheet 2 to Sheet 1 upon double-clicking the link in Sheet 2, Cell A1, to enable me to go to the actual location of my data in Sheet 1? Thank you.

    Reply

  18. Hi Sir!
    Thank you for this three tutorial.
    Unfortunately, I don’t see any video to watch.
    What should I do?

    Reply

  19. Sumit
    You are truly an MVP. Your videos and instructions are fantastic, they are easy to understand, not cumbersome or a burden to watch and your instruction is simple and precise. I have used Excel for a very long time but each time I need an answer you are my go to search and instructor and it goes without saying I always find what I am looking for. Are you as good in other aspects of the MS Suite or Master of one? Let me know. Thanks for your support.
    Paramveer Sidhu

    Reply

  26. Your website provides excellent insight in Excel which is very useful for every type of end user.

    I am struggling with an issue, I am unable to resolve myself and I hope you can give me right direction:
    In my first worksheet “dataentry” I have a column A and B, where column A is a dropdown list with numbers and column B is a dependent dropdown list related to column A.
    On my second worksheet “datalists” I created the value lists related to column A and B.
    The problem lies in the fact that on the “datalist” worksheet Column A defines the value list which should be displayed when selecting the value for Column A on the “dataentry” but that I want to see the full description from Column B from the “datalist” sheet in my dropdown list. Similarly, on the “datalist” worksheet Column C defines the value list which should be displayed when selecting the value for Column B on the “dataentry” but that I want to see the full description from Column D from the “datalist” sheet in my dropdown list.

    I hope I made my problem clear and really hope you are able to help me out here.

    Thanks in advance!

    Reply

  29. Need your support on power query. I have gone through the video of merging multiple workbooks into one workbook. That was an interesting feature. However need to know one thing. In case we have two worksheets on three workbooks with similar names, is it possible to merge into one having the end result as a combined workbook with two worksheets

    Reply

  34. Thank You Sumit, you have a heart for people and an understanding of their needs, I honour you for the gift that you are sharing with us, I pray blessings over any venture that you set your heart on.

    Reply

  37. its a really helpful for people who will not spend money to learn that course.. thank you so much sir…. if it is possible please make these videos to downloadable ….

    Reply

  38. Thanks sumit … all videos are great and very helpful….
    And again thank you so much, making this course free so that more people engaged to learn excel.

    Reply

  40. Thank you so much, making this course free will get more people engaged to learn excel the right way

    Reply

  46. Thank you Sir, I am delighted with your work. Your hard work and dedication have brought positive changes in learning excel. Though i could not yet prepared excel sheet for fetching the fund mutual fund units from nse mf fund for my portfolio. I am trying to prepare requisit worksheet in excel 2007.
    Thanks again.

    Reply

    • When you click on the gray bars on the page above, you will get the video that you can watch

      Reply

      • I can’t find any links to the videos. When I click on a grey bar, it expands with a detail of the contents of the lesson, but I can’t see any video or link to same.

        Reply

        • Just discovered the cause of this problem: my Adguard blocker was stopping the display of the video. AOK now. Thanks.

          Reply

  49. Aha! My adblocker was preventing the videos from appearing. When I turned it off, the videos appeared. Thank you.

    Reply

  50. Where are the links??? I click on a heading, get the description, but there are no ACTUAL links to watch the video!

    Reply

Leave a Comment

Get the FREE 51 Excel Tips Ebook

Enter your details and the free PDF is on its way to your inbox.

Hmm, that didn't go through. Please check your email and try again.

No spam. You'll also get my weekly Excel newsletter. Unsubscribe anytime.

Check your inbox!

The ebook is on its way to your email. It usually lands within a couple of minutes.