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

Modules Covered in this Free Excel Training

MODULE 1 - EXCEL BASICS (for Beginners)

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:

Once you know 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:

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 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 Home tab in the Font category.

Related Excel Articles:

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:

Click here to download the example Excel file

In this video of this Free Online Excel Training, 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.


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:

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:

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:


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:

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:

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:

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:

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:

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:

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
  • WORKDAY function
  • WORKDAY.INTL function

Related Excel Articles:

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:


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:

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:

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:

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:


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:

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.


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:


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:

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:


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

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.

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.

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)

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.

  • Dear Mr Bansal

    I want to take this opportunity in thanking you for offering your services free to all. I am very grateful to you. Not very many people will offer their services for free in this day and age. May you be abundantly blessed Sir.

    Thank you once again

  • Al Menendez says:

    Fantastic! I’ve been a programmer for 30+ years and this is a wonderful site for a refresher or a quick reminder of how to do things in Excel.

  • Very much interested in the courses

    • How do I start the course on my smart phone

  • Irina Mitco says:

    Can I get a certificat when I will finish this cours?

  • CuriousThinker says:

    Thank you Sumit for your efforts for making these courses completely FREE of cost. Absolutely great videos and your style of teaching is amazing and easy to follow. Thank you for sharing your knowledge with everyone.

  • Vaishali V Patel says:

    Would like to learn

  • Mahesh Nathwani says:

    would like to start

  • Sir you are teaching in a very simple and cool way . I liked it very much. Iam sure no would have any doubts after hearing. Thank You soo much for providing this free course.

  • soumya panigrahi says:

    it is really helpful to us

  • Rajiv Ranjan says:

    It is really amazing to see this.Throug this platform we surely increase our knowledge about excel

  • Rajiv Ranjan says:

    It is really helpfull


    I get the training best however I need certificate after completing the training for cpd.
    how can I get it?

  • Amen Melody Sangha says:

    Wow I love learning opportunities as this hope to really know this Excel.


  • Joseph Walker says:

    Dear Sumit Bansal,

    I am trying to learn Microsoft Excel.
    I have been using it for years but know very little about it full power.
    I am watching your videos on YouTube.
    In the video “10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course”
    in the session on “Milestone” charts when I enter the data as
    shown in the video I get a “#FIELD!” error.
    Do you have a solution for this?

  • anshika maru says:

    it was good and understandable excel course.

  • Abhishek B says:

    Really helping a lot.. thank u

  • arooj syed says:

    Thank you so much sir you helped us alot

  • I just purchased Microsoft Home@Student and one of the things I wanted to do was learn Excel. I’m only on the third lesson so far but I find your instruction clear and logical in it’s presentation. Thank you for all the time and work you’ve put into making it.

  • Do you get a certificate upon completion?

    • Pravin Shekoli says:

      Do you get a certificate upon completion?

  • Ganesh Wanve says:

    how i join class?

  • Really helpful sir

    Thanku so much ❣️❣️❣️

  • Muhammad Farooq says:

    I have been struggling to learn excel but with these videos definitely will get a better result, at the movements, Just would like to say to you ” well done and Good job “. Thanks

  • Priyanshu kumari says:

    I want do that. Anybody can cll me… How’s will be start.

  • Marci Dodd says:

    How do I get the certificate after completing the videos?

  • michael adekeye adeoye says:

    michael adeoye wonderful. May God bless your excel training.

    • Bishop Joseph Aluko FCA says:

      Are you qualified? Have you got experience? I may have a Freelance job for you in our firm of Chartered Accountants & Property Tax Consultants in London UK

  • Shifa surti says:

    It was a helpful session.Thank you

  • So I get a certificate for Thai training?

    • Do I get a certificate for this training?*

  • Mohammed Rafi says:

    Hi, I know Excel basics, may not be fluent. I need to learn online 1 to 1 and complete the course in 2 weeks max. Pls advise how can we do it, daily how much time required & what’s the charge

  • Zachary Chamberlain says:

    Do you receive a certification for completing the course?

  • Ashwini Math says:

    Thank you so much, this is very helpful.

  • barbara e says:

    I am not receiving the tips ebook you are offering

  • alexandra says:

    I have used Excel for years and had no idea about all the functionality! You are a wonderful teacher and have made it so easy for me to grow my knowledge of Excel — Thank you for these wonderful videos and instruction! You’re Excel-lent!

    • Mohammed Rafi says:

      Did u learnt online one to one or just by watching the videos ? How long it takes to complete the course

  • Pooja chalodiya says:

    Can i get certificate for this?

  • Can I get certificate after I finished the course?

  • Can i get certificate for this?

  • Sabari Suresh says:

    Thank you for the training

  • The best, simplest and eastist way of learning excel ….lot of thanks .

  • This is the best online course i have ever found. Thank You and best regards from Bosnia.

  • Siddhesh Kadam says:

    Do we get certificate at the end of this course?

  • Khyati Gandhi says:

    Excel courses provide certificate & job

  • Faisal Wahab says:

    Hi Sumit.
    Wonderful contribution you are making. Kudos.
    Can we use these on our company LMS? We are not going to do that for Commercial purposes

  • Vibhuti jyotishi says:

    Is it this course will provide me certificate?

  • Amit kumar says:

    Thank you is what I can say only. I have not still started but I am aware about excel and topics, this is a true help to everyone, great work sir.

  • This is truly the best Excel training I have come across and am actually learning and utilizing what’s taught. The lay out and process is very well put together. Sumit’s style of teaching gives you exactly what you need w/o all the extra talk. No wasted time just good content clearly and usable. EXCELLENT WORK Sumit and THANK YOU!

  • ShehnazPatel says:


  • Interesting video. Thank u !!!

    • ShehnazPatel says:


  • Barbara Fourie says:

    Wow, I just loved this training. The wonderful thing is you can keep going back to refresh things you may have forgotten. Thank you!

  • krit sharma says:

    Sir aapka smjhane ka way bot best hai kya Excel video hindi version mai avilabel hai….if yes please send me link on my email id…..sharma,krit09@gmail.com

  • Harichandan mishra says:

    I want to know everything in excel.

  • Tanvees Aslam Shaikh says:

    thank Trump Excel for so many help

  • Palak Joshi says:

    Osm Guidance in this video, Thank you so much to learning lots of new features.

    • Dear Palak,
      Siri connected me to your excel Tutorial program and many thanks. I hope to learn the program soon though it is a bit too fast for me but you are very clear.

  • L.V.V.Surya Ramya says:

    interedsted in excel

  • Dimple Gera says:

    Interested in excel

  • Aditi Dhepe says:

    I have not been able to access video, How do I do that? Do you also provide certificate after conplication of this course

  • Abdoulie Nyassi says:

    Grate work Mr. Sumit, I planed to take up an online program in Data Analytics next semester but indeed hope these videos would help me a lot. Bravo my brother.

  • Akanazu Perpetua says:

    Is this really free

  • Alex Black says:

    Does this course come with a certificate?

  • Shruti Manoj Panhale says:

    Do this course provide completion certificate.

  • R. S. Choudhury says:

    May I download video

  • Vedha Priya says:

    Can we get certificate?

  • Where are the exercises for each module to practice the lessons?

  • mohamed mustafa darwish says:

    can i get the certificate?

  • Bhagwat Pandhare says:

    I am interested for learning ms excel

  • Bhagwat Pandhare says:

    I am interested learning in excel


    Excellent video Sir I really very thank full to you for bringing useful videos that to free of cost. One can become a expert in excel by watching your video.
    Sir how you made thia video means which equipments you have used without showing the face only you have given voice.
    Because I am also a lecturer I want to teach online without showing the face

  • Niranjana says:

    Watched the introductory video and it was amazingly comprehensive .. Would love to continue with d other modules..will i get a certificate after completion?!

  • Bama Rajan says:

    This is an excellent online course for any level Excel users. Great Instructor! Above all these, its free for anyone! Thank you so much!

  • Can I get certificate after finishing the whole excel course?

  • Carl Wade Ellis says:

    Boy I never knew anywhere near all this was so available! You are a great instructor and make it all learnable, even if I do have to back up and replay often (at least in VBA course, your workbooks on Excel formulas are wonderful). I’m finally learning where before I’ve always just cussed VBA and Excel. Thank you Very Much for all your hard work!

  • Shirley Perez says:

    How can I sign up for this free offer?

  • Shubham vyas says:

    I’m interested in free training

  • Mohammed Aslam Mansoori says:

    I will strive to learn and excel and after some expertise, I would definitely spread it to those who are in need of it, obviously free. I think this could be one way to pay you back. My sincere regards to you Sumit Bansal.

  • edwin dunning says:

    sounds good will give it a go

  • Sumit, as I mentioned in an earlier comment, I am fully retired 5 years now. In my day was considered an advance Excel user – VBA programmer. But I must confess I have learned things in your tutorials I knew about but never mastered. You tutorials say things in simple terms. I just finished lesson 8: Number Formatting in Excel. I used this function often in my work but now have a better understanding of how to use the different formats of number, dates and times. Thank you for EXCELLENT tutorials. Can’t wait to learn more. Thanks again.

  • Will there be any certification given at the end of the course?

  • V.v.dasare says:

    Can it be used better than tally for inventory management

  • Lalith Uswatta Gedara says:

    this is a great Excel training program. I thanks Mr.Sumit Bansal give to opportunity develop our Excel side.


    thank you , very helpful

  • Olufolahan says:

    It will be my joy to start this training and finish to become a pro in no distant time. Thanks for this offer and opportunity.

  • pranav raghavendra says:

    This video is helping a lot!

  • S KIRAN KUMAR says:

    very useful and I am are learning very short cut formulas for faster
    execution of work in excel

  • Thank you Sumit for making learning Excel for me a piece of cake. All this while, I was under confident when it has come to Excel. You entire Module is a collection of all the lessons and I do not have to go anywhere else to find video. I practice these everyday. Thank you once again.
    And yes I would like to treat you with coffee sometime as a gesture for your help!

  • can i get the certificate?

  • How to login and start training..

  • Alina Kemeziene says:

    Amazing! This is so useful, so clear. I wish I found you long time ago 🙂 Thank you so much.

  • Hi and thank you for all the content. I had a question regarding the countifs function. I had the quiz question how many times does the number 3 appear between the integers 300-400. I know the answer is 120 after looking into it further I was wondering if there’s a way to get to this answer using countifs, if so how? I thought it would look something like this =countifs(b1:b100, “3**”, b1:b100, “*3*”, b1:b100, “**3”) but clearly have it wrong.

  • I’m interested to do this course

  • Subir Roy says:

    I must appreciate you ,you have prepared all the videos and that available for all.
    Regarding printing I want to know how can I print bill format using data of various cells

  • Subir Roy says:

    I must appreciate you ,you have prepared all the videos and that available for all.
    Regarding printing I want to know how can I print bill format using data of various cells

  • Can’t wait to get started, an 81 year old.

  • Just like excel You are an Excellent instructor. Thanks for helping!

  • Yemalin Emmanuel Hounzonlin says:

    I just love this free online excel.

  • Yemalin Emmanuel Hounzonlin says:

    I just love this free online excel.

  • Gwen Carter says:

    My,my,my…I know we still have kind souls, we have just lost our way a bit in the world today. Knowledge is no good unless you share it. I will be taking your course.
    I sincerely thank you for your kindness.

  • Is there a free certificate after completion

    • April Marie Bee says:

      No there isn’t , but you can share the knowledge you’ll gain with your peers and employers as proof of your completion 🙂

  • Mary Sebastian says:

    I don’t know about this I am just doing first time so after i start I’ll comment

  • Aarya Soni says:

    Thankyou so much Sir for providing us such a valuable course free of cost. Your Teaching style and way of explanation is Fabolous. It helps me alot.

  • Hello Sir,
    I am not able to play the videos. They seems to be freezed.

    • April Marie Bee says:

      It may be your connection, try to hook to WiFi and try again. Hope that helps

  • Saraswathi says:

    Total how many hours does the course is?Can I get certificate?

  • Bankim Datta says:

    I am now 65. I like to convey my thanks to you for your philanthropic activity as a teacher in real sense. I was a teacher and hope to be a student of you very soon. Live long.

  • Hi! Are these courses still available? I’ve clicked on several of the training courses and cannot access.

    • April Marie Bee says:

      Yes they are, try to connect to WiFi and try again to access

  • Do you get a certificate for this course?

  • Rashmi Narvekar says:

    Hi I would like to attend this class

    • April Marie Bee says:

      Hi, access anytime 24/7 for free 😉

  • c sivaji rao says:

    simply excellent

  • Arnel Laraya says:

    Does this course provide certificate?

    • Abdoulie Nyassi says:

      Waaw Mr. Sumit! This is a fantastic gift to all the human race. Bravo my brother.
      I planned to take up an online course in Data Analytics next semester,2020 and hope this would help me a lot.

  • Jeanne Richardson-Phillips says:

    I’m a complete beginner hoping to start a data analysis Open University Course in October. Your service is invaluable to me and I will be studying for 2 hours a week until October. Many thanks for sending me emails. Kind regards, Jeanne

  • Samiran Kumar Sen says:

    Will you provide Certificate after completion. How much time it will take to complete. I am in intermediate status.

  • Does this course provide certificate?

  • Kumari khushboo says:

    We will get certificate?

  • Do we get a certificate for the course?


  • Thank you so much !!! I’m a Nutrition student in college and excel is extremely useful <3

  • Thank you so much Sumit for such a comprehensive course, I really appreciated it!


    Great Job and I am learning every day as I watch one video per day.

  • VIVEK KAPOOR says:

    Very nice way of give training with so much examples & practicality.
    I am v. much impressed.

  • Hi
    I would like to start study excel
    When the course start ?
    Thank you

  • Hannelie Schoeman says:

    When can I expect to start the free excel cour

  • Nikki Bakshi says:

    Will a certificate be provided by the end of the course?



  • PRAGATI SONI says:

    thanks for this complete course on excel learned a lot…

  • Out of my tight schedule and extra working hours, I took out some time to complete this course and it helped me tremendously to manage and analyse my data, along with it I could save 2-3 hours per day. I am grateful to you for making it available free and help people like me who struggle working efficiently without good knowledge of excel. I have recommended this course to my colleagues now. Many many thanks again.

  • Nitika sood says:

    Hi sumit, thanks for giving such wonderful learnings at no cost. Will u please guide me for certification stages in excel and also best link to go for it. I would really appreciate ur response. Thanks in advance

  • Mandeline Abraham says:

    is there a book covering this course? If not what books do you recommend to learn Excel for work?

  • Jayapriya says:

    It’s very useful course. Thank you sir.

  • Is there any assessment that I need to give after completing the training?

  • The courses offered and the way these are structured are
    meant to lay a firm and solid foundation to build upon.
    Everybody builds their own home on a foundation. When it is a good, properly laid, will make one’s home sitting on a solid foundation.

    Mr. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way.
    With an average enthusiasm to learn, one can learn from these videos and lay a firm and solid foundation to one’s career, using this excellent program called Excel.

    Like air we breathe, Sunshine we enjoy, moonlight we adore, his free teachings are GOD’s gift to any body that want learn a new skill.

    The organisation, time, effort and passion has to be really appreciated.

    I see lot of people asking for a pat in the back ( like looking for a certificate of completion ), this is a SELF-HELP course, and I am not sure I will have as much information given to me even if I attended a PAID COURSE.

    And again, since I am learning this on my own to improve MY understanding of spreadsheet program, I can understand and appreciate why some persons want to squeeze a CERTIFICATE out of this as a ticket for a future job.

    Mr. Bansal,
    Pranam to you, as a teacher who put in all this time into these video courses and offering it for free. I bow to you for your kind heart.

    Goddess Saraswathi has blessed you, may her blessings be showered upon you into the future, so we all get at least a part of those blessings.

    Namaste !

  • Shivani Singh says:

    Is this course provide certificate also?

  • Dr. Seema Girdhar says:

    Will we be getting certificate after completion


    Sir after completing this …can I have a certificate of this or not..

    • Sir I completed the course so would you please give me a certificate

      • Awesome course I learn lots of thing
        Thank you sir

  • Josephine Okeoghene Akpodiete says:

    It really lovely course thank you very much

  • Hi Sumit! Thank you for this! Question …is there a file to download to follow along with the videos ?

    • Nevermind! You don’t need it in these videos…I got it . I’m looking for tutorials on what to do say when you run a SQL query and have a huge data dump in excel . Will start with your videos here , thank u!

  • Mansi Mehta says:

    Very helpful course

  • Mansi Mehta says:

    Very helpful course

    • Sangeeta kulkarni says:

      Khupch chan information dili ahe purn upyukt asa course ahe excelcha.

  • hello i’m new here and i would like to learn excel then after i can learn more about computer.

  • Anil Kumar Rajneesh says:


  • Duaa Samir says:

    Thank you soooooo much for the effort
    Really appreciated


  • This is really good way to taught I really liked

  • hi, is this a certificated course?

  • Julius Banka says:

    Please I am interested in taking thefree Excel class

  • Natalie Carey says:

    This is so user friendly. For someone who has never been able to use Excel, your training is just so simple and easy to understand.

  • Neeraj Beeknoo says:

    Hi. I wanted to chat.

  • can you go to insert I am on a mackair

  • Rajas Mohan Bhasme says:

    How to enroll ?

  • Promise Nkwocha says:

    This is beautiful. I enjoyed the training and with this excel training, i can say that i now understand excel at some extent. Many thanks to the instructor.

  • sir all are very nice i love it

  • Vishal Gohil says:

    Thank you very much, this really helped me a lot

  • SAJAL DEY says:


  • Josephine Okeoghene Akpodiete says:

    Am new how do i get started and do you anything to show that someone did this training.

  • suvendu manna says:

    sir after completion of this course i will get a trained certificate or not ?

  • Yes. I am interested in the free excel course

  • Kanwalkataria says:

    Sir please tell us some assignments so we can practice after every lecture

  • Thanks you so much ,sir.
    I am from Pakistan. I learned a lot from your videos.
    Kindly share me the procedure to get excel notes if you prepared according to the video you published.
    Thanks in advance

  • Ramit Rehan says:

    May i learn the Macros in this Excel Program as well

  • It is very helpful app

  • Shwetha K says:

    Worth watching these videos, it’s really very helpful.

  • Shaini Baiju says:

    Good effort. Contains are clear and crisp. Course is Advanced, I will highly recommend this to Computer teachers who wants to clarify their doubts in excel.

  • Kanwalkataria says:

    Sir can u tell us some assignments so we can practice after every lecture?

  • Does one get a certificate after completion?

  • Neeraj kumar says:

    It’s a very healp full to excell. I have to learnt data entry and number formatting with excell. In module 2 I learn to auto fill , custom list. And excell is spread sheet program include in the Microsoft office suite of applications it is also soft ware program .

  • Andrew Wells says:

    I have watched your course “How to do a Picture Lookup in Excel – A Step-by-step Guide” and I still can’t get it to work. Is there any way to help me? I am desperate.

  • Deepak Chand Tamoli says:

    The language is so easy to understand the lesson.

  • Thank u sir it is very useful training I had been advance Excel classes but I had not more about Excel I had learn only basic concepts and also I had try job outside I didn’t found the same MIS executive job. May be if start watching this video daily I will learn more new about the excel thank you so much for providing this free of cost course.

  • Narendra singh says:

    First check it.

  • Narendra singh says:

    First check it

  • Pravesh Nailwal says:

    Are we getting any certification after the course completion.

  • Bruce Foote says:

    Why is Trump name on this course? How is President Trump associated with this course? If he is not, why did you put his name on it?

    • It’s a common English verb. This course and the site has nothing to do with anything except Excel

  • Ravi Kumar says:

    I think this was an excellent video on excel I really appreciate the efforts who had made so easier to learn excel.
    Contains are clear and chrisp.i am impressed the way they present the advance excel.
    I will also recommend to my office staffs, senior’s, collegiate, friends and our business partners.
    Now after learning so many things through video I feel so confident and happy now I have to rush to take help of anybody, I will keep practicing and learn more and more to enhance my excel as a superb skill.
    Thanks you so much to all those who had given great platform to learn the Excel and various things…..

  • Vishwanath Kamath says:

    Thanks for training and good experience and thanks a lot .

  • Vishwanath Kamath says:

    Good experience and thank you for your help.

  • Manisha Shaw says:

    I want to learn advance course

  • Atul Ramesh Sawant says:

    Thank you Sir, it is very useful for me to know about Excel as I am working on Excel in my office and it will be very useful for me.

  • Sanjana gupta says:

    Hello sumit sir,
    I am writing this to Thank you for providing such great lessons. They are very few people left around us who provide education and great learnings for free. I am disappointed for finding this site a bit late. But I’m glad i am finally here and can get the best out of this learnings. Thankyou so much for your knowledge and efforts Sir.

  • Digvijay Pednekar says:

    Good knowledge …Data Entry,Data editing,Number Formating

  • Digvijay Pednekar says:

    Good knowledge & Information

  • HI Sumeet Sir,
    Can you please explain the basic difference between between Vlookup & Hlookup as both looks same and Syntex are also same just =vlookup has been changed to =Hlookup .

    • Hi I am an intermediate in excel…

  • Dear Sumeet Sir,
    Can you explain a bit more about Vlookup for the last example in the given where you were T is higher lower, Really I got confused ,It has been asked for T why it is giving data for jane ?

  • very well explained ,very useful

  • It is very well explained & has been very useful to me
    Thank you

  • I like all the videos and I have easily understood everything. Thank you

  • mandy wright says:

    Hi is there a certificate once completed?

  • Santosh Kadam says:

    It is very useful. Excellent videos & courses and easy to understand.

  • Very nice coaching and class

  • Rui Matias says:

    Thank you for the great work, Sumit – I’ve found it very useful and comprehensive.

  • I will give you tip at the end of the course.

  • Do they provide certificate?

  • This is amazing tutorial and excellent instructor, I loved, thank you so much it’s absolutely life saving.

    • Md. Mohidul Shaikh says:

      Do they provide certificate?

  • Balaji Rao says:

    This excel work is essential

  • Morris Kromah says:

    This is what I was looking for to learn in my life.

  • Lubna Kader says:

    It is really helpful. Thanks.

  • so clear and very helpful

  • Nimisha Masurkar says:

    It should be useful

  • robin lee says:

    I enjoy and learn a lot from your Excel course. Wonder you have free online course for Microsoft word training just like this excel course.

  • Navdeep Singh Virdi says:

    Hi Sumit – i need to know how to become MVP in excel as I know it at advance level.

  • chandra mouli says:

    very useful for me.

    thank you sumit

  • chindeh calistus tehyah says:

    chindeh fally

  • for example : 3126.76 is the number I want this in the form ####.## how can I do this plz tell sir.

  • May God bless you my brother. Thanks for sharing your knowledge. My name is yunus be in touch 7624885184 (Kerala)

  • NOORUDDIN says:

    i learn alot think here

  • NOORUDDIN says:

    i learn alot think here

  • Saloni Arora says:

    is it necessary to have certification of excel when you have an aim of pursuing a job in future?

  • Nisha Amin says:

    Online excel learning

  • F Mohammed sathaq says:

    I am very interested to learn excel , well done good lesson it’s very useful for so many people’s thank you…

  • Iqbal Khan says:

    Thank you very much . This training has helped me a lot and I am so grateful. I have been looking for an Excel training , tried to buy from Udemy several times but could not complete the transaction due to some restrictions in their payment system which does not allow a credit card issued in a different country. What’s is point of having a credit card if the thing would not work across regions ? Well, this was before I came across your page and started learning . Having gone through several videos and other trainings, I can honestly say that your training is one of the best structured and delivered. Thanks a lot.

  • poojan Sheth says:

    Module 3 lesson 9


    as in the video to find out answer only to Average (Sum +Sum +Average) u select the Average with associated cells and click F9 but i my excel when i tried i am not able to get that answer. do we need to press shift+f9 or it is something else

  • poojan Sheth says:

    Module 3, lesson 9.

    I understood how to keep one number consistent while dividing or any other signs by adding ($) sign before the letter and after the letter but

    in mixed reference moving from $A$12 to $B$12, considering different column (i.e from A to B) but same number cell i,e (12) in this case i tried on my excel but i am not able to move from A to B by removing the ($) sign before A by pressing only (F4).

    Could you help.

  • Rajesh Patidar says:

    Which course in excel

  • Surendra Bajracharya says:

    Please send me link, I am interested on it

  • Rachel.Pirinduo says:

    very much interested to start the course, coz I like excel spreadsheet.

  • Pradeep Kamble says:

    Do we have to sit in one go or we have can do per day per video

  • Thanks for your excellent tips on Excel.

  • Rudra sarkar says:

    Want to learn all the basics of xl

  • Satnam Singh says:

    I finish my course can I get certificate.

  • Sudheer Vospari says:

    I have learnt formulas in this online course… Usefull course

  • I was literally looking for an excel training opportunity for teacher professional development. I had my wallet out ready to pay. Your training is above and beyond structured and easy to follow. I would have paid hundreds of dollars for this training. Thank you for sharing your knowledge and talents!


    Good one

  • Akitoye Olubunmi says:

    I am very eager to learn this and don’t see the tutorials yet.

  • R Srinivas says:

    Can I get a Certificate after course completion

  • Mathurthi Sankara rao says:

    It’s very interesting And very useful

  • Vilas Nargund says:

    I am using excel. I need to improve…….

  • Thank you for the course Sir, it is really useful.

  • Jeetendra Chavan says:

    I found it very useful, really appreciating Mr.Sumit for your valuable contribution.
    Its very effective way of teaching in simple way to explain the logic’s and uses of each functions.
    Keep it up……

  • Aradhana Sah says:

    This courses is truly useful.

  • this may help a lot of people just by watching

  • Chitra Gune says:

    I found this Course very useful for me and suggest to others also. Thank you.

  • Achin Kumar says:

    Course Modules are very usfull

  • Hemi patel says:

    This course is Best and very helpful course

  • Hemi patel says:

    Best courses very helpful course

  • do we have any test after the course

  • Kajal chaudhary says:

    Learn something new through online session

  • What about a sertificate after finishing for cv for work purpose

  • Iqbal Singh says:

    HI Sumit,

    I find your tutorials quite useful for many excel formula. I have a unique situation. I would like to seek your help. Is there any way that I can reach out to you and share the soft data(Dummy) and seek solution. This is related to vlookup.

  • Hello. These courses sound great. However, nothing happens when click on any module. Is this because there may be high traffic? Do I need to access via google or IE? thanks

  • Manoj haldankar says:

    Great excel learning

  • Louloua Barakat Diab says:

    Hi Sumit,

    I am using your free 26 lessons program to learn Excel. Thank you for the very informative videos. Is there anywhere I can do practice exercise?


  • Thanks a lot sir for making it available now for free.

  • Namrata Singh says:

    Which excel courses are paid in your site.

  • Mohankumar H G says:

    I have always wanted to learn excel so I am very interested in taking this course

  • Elizabeth Clayton says:

    I have always wanted to learn excel so I am very interested in taking this course.

    • did u started? is this really useful?

  • How do I get access to the worksheets used in the videos?

  • Partha Sarathi says:

    I thank Mr. Sumeet Bhansal for giving me such a lucid training where in got to know the easiness in understanding the excel formats quickly.

  • Sandra Janett Hernandez says:

    Do I get a certificate for this training?

  • Mukesh Anand says:

    Very Useful courses

  • Is there any certificate after completion?

  • Avinash Nehra says:

    Nicely Explained in Detail

  • Deidre Thompson says:

    How do I get the Free video?

  • Muktar Shaikh says:

    Very useful course for the excel learner’s.
    Good Job…
    Thanks a lot…

  • Alpesh Radadiya says:

    I know about excel a little bit I want to learn excel in deep.

  • Betsy Williams says:

    Sumit, you have provided the clearest teaching I’ve found thus far online. I appreciate the downloads you provide with each lesson so that I can switch screens and practice while you are teaching. Also, you have organized these beautifully in small sections so that anyone can take a quick lesson in between other projects. EXCELLENT!

  • I was to change shape of chart element column chart. Please guide.

  • Sumit -the way you explained formulas its amazing. I am your fan nowonwards.
    thank you dear.

  • Kishan Khule says:

    Thank you so much.. !


    Cn we get certificate after complete the course?


    Cn we get certificate after complete the course?

  • Sulochana Shrestha says:

    Thank You for sharing your knowledge to us.This courses is very useful.

  • Hi Sumit, approximately how long will it take a beginner to complete this course? Thank you

  • Pranav Kumar R says:

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

  • 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

  • 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

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

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

  • 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

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

  • Am I gonna get a certificate for the course

  • 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

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

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

      • Hi sumit..hope u r doing fine..would u able.to.send these same.sheets for practice

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

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

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

  • 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

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

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

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

  • 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

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

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

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

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

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

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

  • 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

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

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

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

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

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

  • 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

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

  • 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

  • Thank you very much dear Sumit 🙂

  • 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


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

    • Anita Gurung says:

      How can i enroll this course ?

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

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

    • 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

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

  • 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

  • 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

  • Excellent for beginners

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

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

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

  • Annette Stone says:

    Excellent, learnt what I needed to. Easy to understand

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

  • 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

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

  • 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

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

  • 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

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

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

  • Rachid Eedrouich says:

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

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

  • 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

  • Thanks you Sumit for your knowledge.

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

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

  • 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

    • I need to learn more about excel

  • 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

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

  • 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

  • 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

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

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

  • 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

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

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

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

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

  • 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

  • so nice easy to understand

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

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

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

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

  • Thank you for the great help.

  • Melody Brown says:

    Wonderful! Thank you!

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

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

  • 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

  • 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

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

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

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

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

  • Bro where is the link to videos????

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

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

  • 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

  • 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

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

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

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

  • thank you so much, you are very generous.

  • Tara penton says:

    Where can I download the videos used in the course?

    • You can’t download them…

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

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

  • >