LEARN EXCEL - FREE ONLINE EXCEL TRAINING

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, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).

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

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 7 - EXCEL EXTRAS

Lesson 25 - Protection in Excel

Lesson 26 - Introduction to Macros and VB Editor

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.

Sumit Bansal - Free Online Excel Training - Learn Excel Basics

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.

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, and the upcoming 2019).

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.

  • Muhammad Saleem says:

    Hello Sumit, Can I share your youtube videos on my Facebook Page. I will write credit to your name and mention your website any other services you offer. Thanks.

  • Mujeeb says:

    As a student who needs additional time to truly grasp the concepts of Excel, this site is an absolute LIFE SAVER! Thank you so much Sumit!

  • Darren says:

    Cant believe so much detailed training and guidance for free. Thank you so much Sumit.

  • Fran says:

    Thank you so much -your tutorials have been a great help!

  • Tolga says:

    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

  • hira says:

    so nice easy to understand

  • Richa Gupta says:

    Best!!

  • Aldo says:

    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.

  • adnan says:

    This is awesome!!!!!!!!!!!!!!

  • Shriya says:

    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 ?

    • Sumit Bansal says:

      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.

      • Shriya says:

        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.

  • Moussa says:

    Thank you for the great help.

  • Melody Brown says:

    Wonderful! Thank you!

  • Lisa says:

    Sounds good to me!!

  • Lisa says:

    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.

    • Sumit Bansal says:

      Hello Lisa.. Good working knowledge of Excel should definitely help you get a job

  • Fiona Contell says:

    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.

    • Sumit Bansal says:

      Thank you so much for the kind words Fiona.. Happy you found the course useful 🙂

  • Ashraf says:

    Hi,
    none of the videos are working… I tried several times in vain

  • Harini says:

    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 ?

  • Dhiraj Agarwal says:

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

    • Sumit Bansal says:

      Hello Dhiraj.. This is a free course so no certificate is issued for completing it

  • Terri says:

    Will I receive a certificate of completion for this training?

    • Sumit Bansal says:

      Hello Terri.. This is a free course so no certificate is issued for completing it

  • Michael says:

    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.

  • Freddy Yvan says:

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

    • Sumit Bansal says:

      When you click on the gray bars on the page above, you will get the video that you can watch. Are you not getting any videos when you click on the gray bar?

      • Freddy Yvan says:

        No, I don’t see any videos.
        Just a list of what we will learn in the section.

        • Sumit Bansal says:

          Can you please try now? Also, refresh the page (hold the control key and then hit the F5 key). This should fix the issue

          • Freddy Yvan says:

            That’s perfect!
            Thank You Sumit.

      • Lisa says:

        no. not getting any videos

  • Paramveer Sidhu says:

    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

    • Sumit Bansal says:

      Thank you so much for the kind word Paramveer 🙂 I only focus on MS Excel. While I use most of MS apps, I am not as deep into it as I am in Excel.

      • Paramveer Sidhu says:

        Are you on linkedin?

  • Deo says:

    Wonderful learning tool for work experience

  • FAZALU RAHMAN says:

    Hi Sumit Bansal,

    I don’t find any video link in this page…

  • Ali Ahmad Farooq says:

    Video links?

  • Yumi says:

    Hi, the links to your videos disappear. Could you please fix it?

  • Brad Young says:

    Where are the links to start the course – videos??

  • Haseeb says:

    Bro where is the link to videos????

  • Jake says:

    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!

  • rajesh says:

    really helpful pls post some course on advance excel such as vlookup & hlookup, data validation

  • A. Matos says:

    I enjoy your courses, you make learning Excel easy !!

  • Prabhakaran A says:

    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

  • Prabhakaran A says:

    Thank you Sumit. Your sessions are awesome and its a great learning for all of us

  • Chanthavixay says:

    Good

  • Muhammad Hassan Kasmani says:

    do i get any certificate after completing this course?

  • Noshirwan says:

    I have 1 to 20different amount & m
    No10fdeleted how to shift up 11 to 20 up

  • Adolf says:

    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.

  • Jinesh says:

    Great Job Sumit

  • Mounir says:

    Thanks a lot Sumit

  • sridhar says:

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

  • Milan Annaldas says:

    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.

  • sandeep kothari says:

    Great!

  • Diego Monroy says:

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

  • Ricarte laoagan says:

    Great learnng excell.

  • Martin says:

    thank you so much, you are very generous.

  • Ong Chin Hooi says:

    Thank You

  • Tara penton says:

    Where can I download the videos used in the course?
    Thanks

  • gerald says:

    great

  • m.l.sinha says:

    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.

  • Rama Krishna says:

    Thank You

  • HM venkat says:

    I’m interested in free training

    • Sumit Bansal says:

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

      • Ian Hinton says:

        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.

        • Ian Hinton says:

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

  • Ed Newbold says:

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

  • Ed Newbold says:

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

  • >