• Home >>


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 find the videos useful and would like to support me, you can buy me a coffee

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.

  • varsha says:

    great job. Thanks

  • Pranav Kumar R says:

    I have one doubt in the Excel Sir like automating the data from one sheet to another sheet.

  • bharat says:

    Dear Sir, I need help in conditional formatting. In a column A there are a number like for different row 302,213,556,070,111,560, … I would like to high lite the number for 302 value is red( either if it is 023 or 320 for all combination) ,556 is yellow(similar like all combination655,565) and 070is green( 007or700). Please help. Thank you.

  • John Babasola says:

    It is a pleasure to have the opportunity of learning this courses free and I hope it will be a successful experience. Thanks


    Dear Mr.Sumit,
    I need a small solution for my Xl Table
    I need to change the Data (Rate of Interest in the cells) in one column for a particular period in another column (01-04-2019 to 31-03-2020)only
    Kindly help me solve this problem
    S D N Murthy

  • Zuhaina says:

    Hi, can you provide some sort of evidence if I complete the 12 hours course

  • Golla Krishna Koteswararao says:

    It is Useful for me

  • B.l.patidar says:

    It is very usefull for me

  • Trisha says:

    Hi Sumit, Can use google sheet for this training?

  • Learnig Excel says:

    What I have seen so far (I’m on lesson 4) is absolutely amazing!

  • Sreeraj C says:

    Really thankful for your knowledge sharing. It’s really helped me .
    Sreeraj C

  • Sreeraj C says:

    Thanks for good knowledge sharing .

  • saad says:

    any certificate from your side after free training

  • Martha Chao says:

    Do we get a certificate or something to show that we have completed the course?

  • kimberly says:

    will I receive a certificate once I complete the course? Where is the company located?
    Is there a phone number where I can contact anyone if necessary? How long have your company been in business? What is the name of your company?

    • Since this is a free course available for all, you won’t be given a certificate. This site is run by Sumit Bansal (that’s me). I am an Excel trainer who shares tutorials and videos online. This isn’t a company, just me trying to help people learn Excel. You can reach out to me at sumitbansal@trumpexcel.com

  • kimberly says:

    are these courses really free? I will not be billed later on down the line will I?

    • Hello Kimberly… Yes, the course is free. You won’t be charged for anything. You don’t need to enter you credit card or any other detail. Just click on the video and watch.

  • Noyonika says:

    Am I gonna get a certificate for the course

  • hug says:

    why do you want to give free lecture?

  • sekou diakite says:

    I need something for kitchen porter please if available

  • sekou diakite says:

    It’s not for a kitchen Porter course

  • ADNAN KHAN says:


  • ADNAN KHAN says:


  • ADNAN KHAN says:


  • ADNAN KHAN says:


  • Edwin S says:

    Would like to know how helpful the course is

  • Debbiejean Logan says:

    Is there any free online course work that can be done by the person on hands learning to be learning by doing ?

  • Lee Bee Tin says:

    hi Sumit, This is really an awesome excel class and is it free training, really appreciate your effort and sharing. Many thanks.

  • M Asif says:

    Just wanted to say–Sumit, Big thank you for taking time for providing these free online training courses. God bless you

  • Kristin Pennington says:

    Thank you for putting this out there for free, bless your heart ❤️

    • Thanks for the kind wors Kristin… Glad you’re finding this Excel course useful!

  • kotink says:

    Thanks for the courses.
    This courses is very useful for me.

  • binay kumar says:

    one of the best excel course i have ever seen.

  • Soumyadeep Saha says:

    Just awesome Sumit, wasn’t expecting such detailed explanation of everything Excel.

  • Michael Van Gulik says:

    This is the best course on the internet!! At the moment, I’m trying to learn how to take out the external links from excel and I found this post at the top of the search results. Then, I found this course just in the menu and it’s exactly what I’ve been wanting to do, like literally at the top of my list but just did not ever know when or where I could because of the time and just trying to learn so much such as Command Prompt and what that can do you for you.

    Thanks heaps for this whole website, it’s the best!

  • Bar says:

    Thanks for the tutorial video.
    Is there a video for Power BI.

  • Sharron says:

    Thanks for the Excel tutorial. It helped me a great deal at my present job.

  • Dattatray says:

    Good afternoon.,
    I want to be Expert in Excel.
    What can i do for…?

  • Jitin Kumar says:

    I just want to know
    can I get any certification for this Exel online tutorial

  • Shirl Solomon says:

    I need to develop a tactical crime analysis matrix using a spreadsheet. The matrix will contain 10 records(rows) and 16 variables (columns). I have a list of crimes. Would you please demonstrate a sample of this

  • Al Menendez says:

    Thank you

  • Effrossini says:

    Congratulations Sumit Bansal for this exceptional work! It is really fantastic to have access at this great content. I’m a fan of Excel. There are so many things you can do by just using excel properly!
    Do you mind if I make a post regarding your site on LinkedIn or on twitter?
    Thank you!

  • Sai says:

    Thank you very much for giving me the opportunity. It’s amazing Vedio’s

  • Jamal says:

    I took this course before and I didn’t do well cause I was working full time I did’t have time to study.

  • pooja says:

    Hi Sumit, i cannot see videos for Lesson 8 – Number Formatting in Excel,Lesson 9 — Excel Formula Basics and many more. Though i have viewed those videos in the past but they aren’t available currently. is there a restriction in the number of times that once can view a particular video lesson?

    • Hi Pooja… There was some minor update going on which prevented the videos from loading. You can watch these now. There is no restriction

  • Morgan says:

    Watched the first video and it’s wonderful. Thank you. However the second video doesn’t show. I will jump to the third and hope the 2nd returns. Thanks again

    • Hello Morgan, There was some minor update going on which prevented the videos from loading. You can watch all the videos now.

      • Morgan says:

        That’s great. Thank you. This is a great site



  • Gopakumar says:

    Most valuable help I ever received from internet. Great Work

  • Victoria Delacroix says:

    I have really found you to be clear and concise in your presentation. It is very easy to follow and is a great brush up for my rusty skills. Thanks you!!!

  • KBG says:

    Thank you for doing this. Very selfless of you to share your knowledge for free.

  • Innocent says:

    Can i down load and go through later

  • Stewart McKenzie says:

    There used to be a feature in excel that let you send the sheet to a list of people to add data in a sequence – is this still available?

  • Olamide OSHINLAJA says:

    I really want to build a carrier in Excel. I will be glad I get it here.

  • Deb says:

    Can I zoom in on training to make it larger

  • Bhaskar M says:

    it’s great to help & service to people.

    We glad to have this guide for our reference to learn the Excel free.
    I have got this link when ‘am searching for some relevant topics, I’ve gone through it and the exact required knowledge is you shared.

    Appreciated for your efforts keep rocking more like this.

  • Sanita says:

    Thank you in advance… I am working in excel from last 7 years, wanted to learn more 1) passionate about excel 2) need a better career growth, let me start with this, if require will take help further.

  • Arun says:

    Hi Sumit,

    I have a small problem with vlookup i am getting few errors on few cell and i am unable to solve the issue can u pls help me

  • Isabel says:

    I want to create a business cards alphabetical file
    Is there any tips you can give me to make it easier

  • Nosipiwo Mtebese says:

    Do i need to enrol to be part of this training-iam interested!!!

    • No, you don’t need to enroll. Just click on a video and start watching. It’s completely free to access

  • Katyayani says:

    I am not able to download the EBook sir, can you pls help me

  • Mohammed says:

    Really it’s awesome,, how generous you are in giving these crucial knowledge for free to who wants to learn excel. I feel you are doing charity on the behalf of excel. Sir I salute you . It’s bravo and majestic. God may bless you through your ahead intiatives.
    Thank you, sumit bansal

  • Faysal Farooqui says:

    Hello sir, thankyou so much for free excel online training materials. This will gonna really helpful to people who want to learn excel online for free. I would like to know is there any Certificate available after compilation of this course?

  • Jeno says:

    A1 AHU – 9
    A2 AHU – 15
    A3 Boiler – 20
    A4 Boiler – 33
    A5 Boiler – 5
    A6 Chiller – 8
    A7 Chiller – 7
    A8 Chiller – 9
    A9 Chiller – 8
    A10 Chiller – 9

    How to count that How much AHU, Chiller & Boiler’s point in my sheet. I Have 1000 Data in sheet.

    • Sanita says:

      You can get it from pivot table, select d whole data, go to insert (top left side) you will get pivot table option.drag the name in column table and value in value table. ( just check in table value is in sum format or count format, accordingly you can change)

    • Shyam says:

      AHU – 9 AHU =LEFT(A1,FIND(“– “,A1,1)-2)
      AHU – 15 AHU =LEFT(A2,FIND(“– “,A2,1)-2)
      Boiler – 20 Boiler =LEFT(A3,FIND(“– “,A3,1)-2)
      Boiler – 33 Boiler =LEFT(A4,FIND(“– “,A4,1)-2)
      Boiler – 5 Boiler =LEFT(A5,FIND(“– “,A5,1)-2)
      Chiller – 8 Chiller =LEFT(A6,FIND(“– “,A6,1)-2)
      Chiller – 7 Chiller =LEFT(A7,FIND(“– “,A7,1)-2)
      Chiller – 9 Chiller =LEFT(A8,FIND(“– “,A8,1)-2)
      Chiller – 8 Chiller =LEFT(A9,FIND(“– “,A9,1)-2)
      Chiller – 9 Chiller =LEFT(A10,FIND(“– “,A10,1)-2)

  • varsha says:

    hello sumit, thanks for your videos, they are really nice and it really helped me to learn from scratch.

  • Mohammed ukkas says:

    Hey sir I wll be starting Excel training course great opportunity with me

  • pooja says:

    Hi Sumit..The content and the communication are nothing less than excellent. Thanks.

  • Win Htut says:

    I Want to Join.

  • Tatabod Wallace M says:

    Hello sir, I will start by thanking you greatly for this opportunity, the module are so powerful and I don’t want to miss a thing .
    I promise to recommend it to friends too.

  • OSMAN SANKOH says:

    After I finished the course can I have any certificate or what

  • May says:

    Thank you very much dear Sumit 🙂

  • robel says:

    Thank you Summit,
    I do self-study and it gives me confident day by day.

  • PRAVIN kshirsagar says:

    Dear Sumit Sir,

    Thanks a lot for this free excel training course. Never thought that i can learn so many things in this course. My confidence level has gone up now.

    The way you explain the tutorials are very easy to understand.

    You are Truly MVP. Hats off


  • Steve says:

    I was looking for a way to learn Excel for free. I just lost my job and I see that most of the companies require knowledge of using Excel. I will let you know my results when I am done here!

  • Tushar Mitra says:

    Excel video

    • Anita Gurung says:

      How can i enroll this course ?

      • Mohammed says:

        Nothing to do enroll. All things are in front of your finger tips, start with praying to sumit bansal and keep going, rock on

  • CAROL ROYER says:

    Thanks Sumit for your excellentwell-paced method of teaching the basics in excel. I am an older adult who ‘missed the train’ on this kind of information. I was just asking my son for some assistance when I found your video. This has given me hope that I may be able to pursue your advanced Excel course if I master the basics. O I am so excited!

  • bhavana says:

    Really appreciable sir, you are extremely brilliant, and really doing good work for helping student in excel tutorial, each and everything you are making clear to student in each video even tiny things you are covering and your voice is so clear and very simple way to make understand.
    thank you so much

  • Manu Sharma says:

    Thanku sir for this wonderful excel videos but sir i want certificate with this so can you provide certificate of this or not?

    • Mohammed says:

      For certificate you can go through udemy! Course,, if you are willing to get certificate, thank you, rock on!

  • Dennis P Gardin says:

    I’m looking for a procedure that will allow my to put a date and image on one tab,
    and show the image in a calendar on the calendar date tab on the images birthday

  • Saw Aung says:

    This is the most helpful teaching website regarding excel I have come across online. Your teaching style is really passionate, your way of explanation is very clear and you obviously deserve a load of respect and appreciation. It helps me a lot in better understanding excel, and also motivates me to dive deeper into further learning.

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

    • James Banks says:

      highlight the cells you want to enter the information in, type the information then press CTRL+Enter

  • 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

  • Alkozai says:

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

  • summer says:

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

  • Rachid Eedrouich says:

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

  • rose says:

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

  • Mi Mi says:

    Thanks you summit for your knowledge.

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

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

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

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

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

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


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

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

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

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

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

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

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

        • 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

    • 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

    • Umar Jamal says:

      Do they give a certificate on completion of course too?

  • 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

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

  • >