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

In case you're looking for advanced Excel training, please check out my paid online training courses. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.

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 paid online training courses. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.


Lesson 6 - Introduction to Excel Tables

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

Lesson 8 - Number Formatting in Excel


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)


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


Lesson 21 - Introduction to Excel Charting

Lesson 22 - 10 Advanced Excel Charting Examples

Lesson 23 - Dynamic Charts in Excel

In case you're looking for advanced Excel training, please check out my paid online training courses. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.


Lesson 24 - Overview of Excel Pivot Table


Lesson 25 - Protection in Excel

Lesson 26 - Introduction to Macros and VB Editor


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.

  • Deepika sharma says:

    Excellent. Explanation is brilliant.

  • SAM DANIEL says:

    Thanks very much for tutorials, I like to know if there is a way to make just a cell behave as a normal calculator.
    i.e this cell should be capable of summing figures that appears in another cell, while keeping last cumulative figure visible.
    This other cell will be the key-in cell or active cell.
    Cell 1: =2*5, Answer appears in Cell 2,
    Cell 1: =3*6.8, Answer is added to the previous value resulting from (2*5) and still appears in cell 2.
    Kindly share a video if this is possible.
    Thank you.

  • Peter Wilcock says:

    Excellent Course. Really useful. Thanks!

  • David Choi says:

    Hi Sumit,

    I have searched online and came across your youtube video tutorial on how to count color using function and macro module programing in excel.
    I am traying to count the highlighted cell that contains a specific numbers inside of the cell highlighted in color using your code. Can you help me to verify the changes that I have to make to count and add the cell value instead of adding “TotalCount = TotalCount +1” use “TotalCount = TotalCount + “Cell value”” ?
    What should I change to add the values inside of the cell instead of 1?
    Your or anyone’s help is deeply appreciated.

  • vaishali says:

    Hey! in lesson4, almost at the start of the video, you select a group of cells and address them together with the help of a colon, and as you type the no. 1, it appears in every cell. when I do the same, it isn’t happening. why?

  • Vivek says:

    I would like to learn the importance of this course which helps me in resume as an addon and can be fast in computer operations with Latest knowledge

  • Lawrence says:

    Excellent for beginners

  • Lawrence says:

    Excellent platform and tutorials for beginners.

  • Amitava Banerjee says:

    Yes, Sumit it is exciting to Join with your Free Excell training videos. I learnt a lot and appreciate your Teaching skills. It is so easy to understand each step as you move forward. Thanks and Blessings. Great work.

  • Karl Dunlap says:

    Hello I am reviewing your free excel training course. Does your course offer practice after watching the videos?

  • Annette Egwaikhide says:

    I am trying to give this to my employees. However, I would like to give them a practical test to be sure they went through all training modules. Could you help with this?

  • Binoy says:

    I tried to clean data by using the methods suggested by you in one of your lesson. But could not successfully clean certain data sets. How can I send it to you for your help?

  • Rajendra goyal says:

    how can send a query in excel

  • Myo Lin Tun says:

    Thanks a lot. I receive more about Excel.

  • geetha says:

    wonderful teaching and lessons.Thanks Lot. I learnt Lot

  • Dahir Ahmed says:

    I receive more knowledge related Excel thinks you if you have other levees of excel send me linked

  • Babette Jimenez says:

    Can I get any kind of proof that I completed the modules at the end?

  • khaled fitury says:

    Thank uuuuuu

  • Annette Stone says:

    Excellent, learnt what I needed to. Easy to understand

  • Kumar says:


  • Shawn says:

    I am unable to open the lessons???

  • Shambhu Nath Mondal says:

    I feel very happy not only to be enriched with learning Excel tips by you but also to be enjoyed by your way of imparting training.I express my thanks & gratitude to your contributions to us.
    But one fact is that I am unable to download ebook “Excel The Smart Way”. How can I be able to download the book? Please suggest me.

  • Larry says:

    Cannot open your lessons for Excel Basics. Any direction appreciated. Thanks

  • Anurag Tiwari says:

    Excellent Sumit!
    I truly wish to appreciate your way of teaching and effort you put in while creating these videos.
    I learnt a lot

  • vikas says:

    is there any thing by which I can search old photos, through newly clicked photo. I have a folder in which I have approx 1000 photos and want to search old photos of same person i clicked today.

  • Fernando says:

    Hi, Im subscribed to a mail list for 31 videos ([Excel Video 8 of 31] today) buy i want to subscribe a friend but I dont see where he has to click to subscribe to the list. Can you tell me what he neds to do? thanks in advance

  • Ann says:

    Thank you Sumit for giving us your time and teaching us Excel. I am subscribed to your YouTube channel. The Excel in two minutes series contains nine parts. I am unable to access parts five through nine because they are listed as private. If this is in Error will you correct it so I can view those videos please?

  • pk says:

    I have so many row and column and all Cell have Filled with Like ‘Pradeep’. and I want to remove all Single quotes from all cell

    Thanks in advance .

    Its urgent

    • Sumit Bansal says:

      You can do this with Find and Replace

  • Alkozai says:

    Fantastic videos Mr. Sumit, very appreciate I feel like i am in a good value class of excel

    • Sumit Bansal says:

      Thanks for commenting Alkozai! Glad you found the videos useful 🙂

  • summer says:

    thank you soooo much!!! Very appreciate for all you have done.!!!

    • Sumit Bansal says:

      Thanks for commenting! Glad you found the videos useful

  • Rachid Eedrouich says:

    Thank you so much, very helpful videos. you are awesome.

    • Sumit Bansal says:

      Thanks for commenting Rachid! Glad you found the videos useful

  • rose says:

    I Click on the lessons and they do not open???

  • Mi Mi says:

    Thanks you summit for your knowledge.

    • Sumit Bansal says:

      Thanks for commenting! Glad you found the videos useful

  • Courtney Spurrier says:

    Good Morning, I am having a problem with finding the video’s to watch. Can you help me with this Any suggestions? Thanks

  • zayar says:

    Thanks you Sumit for your knowledge.

    • Sumit Bansal says:

      Thanks for commenting Zayar! Glad you found the videos useful

  • Guest says:

    Good morning. I am having the problem where no video pops up when gray bar is clicked. I tried ctrl+F5. It didn’t help. Any suggestions? Thanks.

  • Guest says:

    Thank you Sumit for all your knowledge, so expertly delivered.

  • Rachael Nsasira says:

    I am glad this excel training is free. Thank you very much for this helpful information!

    • Sumit Bansal says:

      Thanks for commenting Rachael! Glad you found the videos useful

  • Shadeeda says:

    Hi I have hundreds of rows and I want to multiple select rows over 10 columns with bold fonts only, I saw you video on filtering cells that contain bold font, do you have similar for rows with bold font instead of cells?

  • Vinit kumar says:

    if want learn advance excel how much charge i pay

    • Pradip says:

      I need to learn more about excel

  • Nisha says:

    Hi… your videos are very detailed and very helpful…thank you for all your efforts in sharing your knowledge..

  • Rackhi Khaitan says:

    Would like to learn about complete advance excel.I feel it is difficult n little complicated

  • Su says:

    HI Sumit these are really useful videos. Do you have similar trainings for google sheets?

  • Guest says:

    Do you provide a certificate of completion?

  • Redmond O'Shea says:

    Do you get a certificate on completion of the course

  • Sumit Maheshwari says:

    Just seen 4 of them today intial ones and its superb, no need to go anywhere. Simply and Easiest way to learn excel from Sumit Bansal

  • Bhavesh says:

    Hello Sir

    I want to know
    If i want to create a data for my students in which i have name ,address,phone and email
    And categories them using Drop down feature according to their subject

    And automatically update them in DIFFERENT EXCEL DATA AS PER SUBJECT

    MASTER SHEET Having All Students

    And different sheets having name and address according to subject like

    Maths students
    Science students
    English students

  • Stephanie says:

    i used your video for the indirect drop downs and it was very helpful. The only problem that I am having is that some of them work and others do not. Is there an easy fix for this?

  • Munajir khan says:

    This is nice I m a engineer so plz teach me only chart, diagram,engineering related video

  • Oluwatobi Akinlade says:

    Thanks for the videos, your method of explanation is very superb. God bless you

  • Lawrence says:

    As a beginner with Excel, I really enjoy your tutorials and it helps a lot…… thank you Mr Simit, Hope to learn more from you as I go along with more free tutorials.

    thank you

  • Brian Johnson says:

    Truly appreciate the time and effort you put in to this for free! Maybe add a donate button or something so people that want to can show their appreciation with moolah! I haven’t even watched one video yet just had to comment.

  • CA says:

    Today is Thursday, August 8, 2019 and I used these videos to relearn how to use excel. They were extremely helpful. Even more happy this training was free.

    Thank you Summit! (From CT)

  • David Kish says:

    You are a miracle. Created vids, summaries for free. More than just an average youtuber. Thank you so much. Greetings from Long Beach CA

  • Loknathan says:

    Can you please upload a video on mail merge particularly with many-to-one option.

  • SW says:

    I chanced upon this website and felt the absolute need to thank you for sharing your knowledge.

  • Evans Ongang'a says:

    After successful completion, will you give certificate to show when required?

  • Karen Walker says:

    Thank you so much for this course it is really helping me you are such a good person to do this for us all.

  • Leif Norinder says:

    Thank you Sumit for an excellent training course!

    Now I have a question, not about your course, but if you coluld solve this problem I would be grateful.
    Do you know how to get rid of the usernaume in comments? I know I could go via Alternative/Genereral/Microsoft Office/Username etc. but that does not solve the problem.
    If I put a space instead of my name, or my initials, it still writes “:” in bold character and I want a empty comment when I start writing in it.

    I think it must be solved by VBA code? And I don’t know how to write it, so if you know, and if you can help me, I would appreciate that.

    I think it is very annoying that I have to delete my name (or initials) in everey new comment I make. Must be a way to get around it?

    Kind regards,
    Leif Norinder

  • Yogesh Mehta says:

    Dear Sumit Bansal,
    I am really appreciate you concern to teach people without any interest. that is a really surprised me in this current mindset of the people. again thank you for your kindness.

  • Tanya Walton says:

    This is so helpful- thank you so much!

  • Connie Adkins says:

    Will I be graded/ receive a certificate of completion?

    • Sumit Bansal says:

      Hello Connie.. Since this is a free training, there is no certificate for completion or grading

  • Deepak Kataria says:

    I Got Stuck That You Just Told Us IN a Video…
    Kindly Tell Me How Can I Connect With You For Solution

  • AyF says:

    Thank you Mr Summit. You are the bomb.

    • Sumit Bansal says:

      Glad you found the training useful!

  • Jennifer Davis says:

    By learning this course would I have completed advanced level or just basic or intermediate?

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

    • Sumit Bansal says:

      Sure.. Feel free to share

  • 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!

    • Sumit Bansal says:

      Thank you for the kind words Mujeeb.. Glad you find the site useful 🙂

  • Darren says:

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

    • Sumit Bansal says:

      Glad you’re finding the training useful Darren 🙂

  • Fran says:

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

    • Sumit Bansal says:

      Glad you’re finding the training useful Fran

  • 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:


  • 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:

    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.

    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.

        • EcellENT! says:

          Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….

      • Lisa says:

        no. not getting any videos

        • EcellENT! says:

          Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….

  • Paramveer Sidhu says:

    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


    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??

    • EcellENT! says:

      Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….

  • 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:


  • 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:


  • 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?

  • gerald says:


  • 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!

  • >