26 Lessons, 12+ hours of Free Excel Training (Videos)
Absolutely FREE | No Sign-up Needed | Scroll Down and Start Learning
If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.
This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning).
You don’t need to sign up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel.
To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. I have also divided these into 7 modules.
NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen)
In case you’re an intermediate or advanced user, feel free to pick the lessons you want to watch.
Also, if you have any questions or feedback for me, kindly leave it in the comments area (at the bottom of this page).
In case you find the videos useful and would like to support me, you can buy me a coffee ☕
MODULE 1 – EXCEL BASICS (for Beginners)
Lesson 1 – Getting Started with Excel
This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area.
In this video, you’ll learn about the following topics:
- Structure of the Excel working area,
- How to navigate in Excel,
- Ribbons and tabs,
- Quick Access Toolbar (QAT)
- Dialog Box & Task Panes,
- Customizing ribbons and QAT,
- What is an active cell
- How to use ALT shortcuts
Related Excel Articles:
Lesson 2 – Data Entry, Data Editing, and Number Formatting
Once you are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.
You can enter three types of data in Excel – numeric, text, and formulas.
To enter data in any cell, just select the cell and start typing. Once done, press enter to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).
This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).
Apart from this, it also covers the auto-fill in Excel as well as number formatting.
Related Excel Articles:
- Fill Numbers in Cells without dragging
- 10 Excel Data Entry Tips for Beginners
- Excel Data Entry Forms (Advanced)
- Custom Number formatting in Excel (Advanced)
Lesson 3 – Data Formatting
⬇️ Click here to download the example Excel file
This video covers the basics of data formatting in Excel.
You can format data in Excel to make it look better and to highlight some data points. For example, if you have a data set and you want to highlight the negative numbers, you can simply highlight it in red color to it.
Here are some of the common formatting I use to make my data look better and more readable
- Applying borders to all cells
- Making headers bold
- Giving a background cell color to headers.
- Center align the headers
- You can find these options in the ‘Home’ tab in the ‘Font’ category.
Related Excel Articles:
Lesson 4 – Working with Cells and Ranges in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you’ll learn how to work with cells and ranges in Excel.
Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.
And this video will teach you exactly that.
It covers the following topics:
- Cell address nomenclature
- Selecting cell/ranges in Excel
- Copying and moving cells/ranges in Excel
- Using paste special
- Selecting special cells
- Using find and replace to select cells
- Adding comments and
- Using quick analysis
Related Excel Articles:
- Find and Replace in Excel
- How to move Rows / Columns in Excel
- Insert New Columns in Excel
- Excel AUTOFIT: Make Rows/Columns Fit the Text Automatically
Lesson 5 – Managing Worksheets
⬇️ Click here to download the example Excel file
In this Free Online Excel Training video, you’ll learn how to manage worksheets in Excel.
It covers the following topics:
- Navigating through worksheets in Excel
- Changing worksheet name and color
- Adding/deleting worksheets
- Hiding/Un-hiding worksheets
- Moving/copying worksheets
- Comparing worksheets side by side
- Splitting worksheet into panes
- Freeze panes
- Saving and opening workbooks
Related Excel Articles:
In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.
Module 2 – EXCEL ESSENTIALS
Lesson 6 – Introduction to Excel Tables
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you’ll learn how to use Excel tables.
Excel tables are amazing, especially if you plan to work with a lot of data/dashboards/models.
In this video, I cover the following topics:
- Creating an Excel Table
- Excel Table features
- Structured references
- Table slicers
Note that table slicers became available only from Excel 2013 version onward.
Related Excel Articles:
Lesson 7 – Auto-fill, Custom Lists, and Flash Fill
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you will learn about tools that can help you when working with data in Excel.
In this lesson, I cover the following topics:
- Autofill: This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
- Custom Lists: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
- Flash Fill: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern
Related Excel Articles:
- Fill Handle in Excel
- Flash Fill in Excel
- Create your own sorting criteria (with custom lists)
- Separate First and Last Name in Excel (Using Flash Fill)
Lesson 8 – Number Formatting in Excel
In this video of this Free Online Excel Training, you will learn all about number formatting in Excel.
This video covers the following topics:
- How to access number formatting options
- Using number formatting options using a dialog box
- Using custom number formatting
Remember that formatting a number in Excel only changes how it’s displayed, but the underlying value remains the same.
Related Excel Articles:
- Custom Number Formatting
- Format Numbers as Text in Drop Down Lists
- Convert Text to Numbers
- Make Negative Numbers Red
MODULE 3 – EXCEL FORMULAS
Lesson 9 – Excel Formula Basics
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you will learn how to get started with Excel formulas.
This video covers the following topics:
- Constituents of Excel formula
- Operators in formulas
- Entering a formula in Excel
- Editing a formula
- Absolute/relative cell references
- Copying/pasting formulas in Excel, and
- Formula auditing and debugging.
Related Excel Articles:
- Excel Formula Debugging
- 100+ Excel Functions (explained with examples)
- Absolute, Relative, and Mixed Cell References in Excel
- Excel Formulas Not Working: Possible Reasons and How to FIX IT!
- Function vs Formula in Excel
Lesson 10 – Logical Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you will learn about the following logical formulas:
- AND function
- OR function
- NOT function
- TRUE function
- FALSE function
- IF function
- IFERROR function
- IS function
Related Excel Articles:
Lesson 11 – Math Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel Training, you will learn about the MATH formulas
- INT function
- MOD function
- RAND function
- RANDBETWEEN function
- ROUND function
- SUM function
- SUMIF function
- SUMIFS function
- SUMPRODUCT function
Related Excel Articles:
Lesson 12 – Lookup and Reference Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:
- VLOOKUP function
- HLOOKUP function
- INDEX function
- MATCH function
- OFFSET function
- INDIRECT function
- ROW function
- ROWS function
- COLUMN function
- COLUMNS function
Related Excel Articles:
- VLOOKUP Vs INDEX MATCH
- VLOOKUP with multiple criteria
- Case sensitive VLOOKUP
- Use VLookup to Get the Last Number in a List in Excel
- Lookup the Second, the Third, or the Nth Value in Excel
- Find the Last Occurrence of a Lookup Value a List in Excel
Lesson 13 – Stats Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Excel Training, you will learn about the following STAT formulas:
- AVERAGE function
- AVERAGEIF function
- AVERAGEIFS function
- COUNT function
- COUNTA function
- COUNTBLANK function
- COUNTIF function
- COUNTIFS function
- LARGE function
- SMALL function
- RANK function
- MAX function
- MIN function
Related Excel Articles:
Lesson 14 – Text Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Excel Training, you will learn about the following TEXT formulas:
- LEFT function
- RIGHT function
- MID function
- LEN function
- LOWER function
- PROPER function
- UPPER function
- FIND function
- REPLACE function
- SUBSTITUTE function
- TEXT function
Related Excel Articles:
- Word Count in Excel
- Split Cells in Excel
- Extract a Substring in Excel
- Concatenate Excel Ranges
- Find Position of the Last Occurrence of a Character in a String in Excel
Lesson 15 – Date and Time Formulas in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Excel Training, you will learn about the following DATE and TIME formulas:
- DAY function
- HOUR function
- MINUTE function
- DATE function
- DATEVALUE function
- TODAY function
- NOW function
- WEEKDAY function
- NETWROKDAYS function
- NETWORKDAYS.INTL function
- WORKDAY function
- WORKDAY.INTL function
Related Excel Articles:
- Calculate Number of Days between two dates
- Calculate Time in Excel (Time Difference, Hours Worked, Add/ Subtract)
- Excel DATEDIF Function
- Excel Holiday Calendar Template
- Calculate Age in Excel
- Insert Date and Time Stamp in Excel
- Convert Time to Decimal Number in Excel
- How to Remove Time from Date/Timestamp in Excel
Lesson 16 – Formulas Mix and Match (10 Examples)
⬇️ Click here to download the example Excel file
In this video of this Free Excel Training, I will show you some advanced formula examples that involves using one or more than functions.
I cover the following topics this video:
- Compare Lists, Get Unique List
- Get the Closest Match
- Get Last Value in the List
- Find Last Occurrence of an Item in a List
- 2 Way and 3 Way Lookup using Index/Match
- Count the Number of Words
- Extract Username from Email Id
- Find the First Monday of the Month
- Extract Data using Drop Down List
Related Excel Articles:
- Compare two columns in Excel
- Extract Username from Email
- INDEX MATCH (Examples)
- How to Compare Two Excel Sheets (for differences)
- 20 Advanced Excel Functions and Formulas (for Excel Pros)
MODULE 4 – DATA ANALYSIS
Lesson 17 – Named Ranges in Excel
In this video of this Free training, you will learn about using Named Ranges in Excel.
It covers the following topics:
- Creating Named Ranges
- Managing Named Ranges
- Important Keyboard Shortcuts
- Creating Dynamic Named Ranges using OFFSET and INDEX formulas
Related Excel Articles:
Lesson 18 – Data Validation in Excel
In this video of this Free training, you will learn about using data validation and drop-down lists.
It covers the following topics:
- Data Validation Criteria
- Input Message
- Customizing Error Messages
- Circle Invalid Entries
- Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List)
Related Excel Articles:
- Drop Down list in Excel
- Dependent Drop Down List in Excel
- Extract Data from Drop Down List Selection in Excel.
- Select Multiple Items from a Drop Down List in Excel.
- Creating a Dynamic Excel Filter Search Box.
- Display Main and Subcategory in Drop Down List in Excel.
- How to Insert Checkbox in Excel.
- Using a Radio Button (Option Button) in Excel
Lesson 19 – Data Sorting and Filtering in Excel
⬇️ Click here to download the example Excel file
In this video of this Free training, you will learn about data sorting and filtering in Excel. It covers the following topics:
- Data Sorting
- Multi-Levels of Sorting
- Data Filtering
- Advanced Filtering
- Filtering and Sorting in Excel Data Tables
Related Excel Articles:
- Data Sorting in Excel
- Multiple Level Data Sorting in Excel
- Sort Worksheets in Excel (VBA)
- Sort Data in Alphabetical Order Automatically
- Sort by Color in Excel
- Sort Data using VBA
- Delete rows based on cell value in Excel
Lesson 20 – Using Conditional Formatting in Excel
In this video of this Free training, you will learn about the amazing conditional formatting.
It covers the following topics:
- Introduction to Conditional Formatting
- Using Formula in Conditional Formatting
- Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)
Related Excel Articles:
- Conditional Formatting in Excel
- Find Duplicates using Conditional Formatting
- Search and Highlight Data Using Conditional Formatting
- Highlight Every Other Row in Excel
- Highlight Blank Cells in Excel
- Creating Heat Maps in Excel
Here are some additional tutorials about Data Analysis:
MODULE 5 – INTRODUCTION TO EXCEL CHARTING
Lesson 21 – Introduction to Excel Charting
In this video of this Free training, you will learn about Excel charting and how to make useful charts quickly.
Excel has a lot of inbuilt charts that you can use instantly to visualize your data. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.
It covers the following topics:
- Excel Chart Types
- Chart Editing
- Formatting Chart Elements
- Combination Charts
- Handling Gaps in Charts
Related Excel Articles:
- Combination Charts in Excel
- Add Trendlines in Excel Charts
- Add Secondary Axis to Charts in Excel
- Creating a Pie Chart in Excel
- Excel Area Chart
Lesson 22 – 10 Advanced Excel Charting Examples
⬇️ Click here to download the example Excel file
In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.
The following advanced charts are covered in this video:
- Multi-Category Charts
- Gauge Chart
- Thermometer Chart
- Milestone Chart
- Water Fall Chart
- Gantt Chart
- Chart with Trend Arrows in Data Labels
- Actual Vs. Target Values
- Spotting Data in a Scatter Chart in Excel
- Dynamic Target Line in Excel Bar Charts
Related Excel Articles:
- Sparklines in Excel
- Step Chart in Excel
- Sales Funnel Chart in Excel
- Waffle Chart in Excel
- Pareto Chart in Excel
- Histogram in Excel
Lesson 23 – Dynamic Charts in Excel
⬇️ Click here to download the example Excel file
In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.
Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button.
This video covers two detailed examples of creating dynamic charts from scratch.
Example 1 – Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.
Example 2 – Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a drop-down list that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis
Related Excel Articles:
- Creating Dynamic Chart Range in Excel
- Dynamic Chart with Selection Box
- Dynamic Target Line in Bar Charts
- Creating Dynamic Chart Titles
In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.
MODULE 6 – PIVOT TABLE
Lesson 24 – Overview of Excel Pivot Table
⬇️ Click here to download the example Excel file
In this video of this Free training, I will show you how to create and use Pivot Tables in Excel.
The video covers the following topics:
- Introduction to Pivot Tables
- Creating a Pivot Table in Excel
- Formatting the Pivot Table
- Grouping data in an Excel Pivot table
- Calculated Field/Items in Pivot Table
- Pivot Table Slicers
- Pivot Charts
Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. Even if you’re using Excel for the first time, you can quickly get a hang of it.
In this video, I try to cover a lot about the Pivot Table. In case you want to learn more, click here to check out all my Pivot Table tutorials.
This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section.
Related Excel Articles:
- Creating a Pivot Table in Excel – A Step by Step Tutorial
- Preparing Source Data For Pivot Table
- How to Filter Data in a Pivot Table in Excel
- How to Group Dates in Pivot Tables in Excel
- How to Group Numbers in Pivot Table in Excel
- How to Apply Conditional Formatting in a Pivot Table in Excel
- Using Slicers in Excel Pivot Table – A Beginner’s Guide
- How to Add and Use an Excel Pivot Table Calculated Field
- How to Refresh Pivot Table in Excel
- Delete a Pivot Table in Excel
- Pivot Cache in Excel – What Is It and How to Best Use It
MODULE 6 – EXCEL EXTRAS
Lesson 25 – Protection in Excel
In this video of this Free Excel training, I will show you how you can lock cells or protect worksheets and workbooks in Excel.
You can protect cells, worksheets, and workbooks in Excel with a password (or without one). Once a worksheet is protected, you’ll need to enter the password to access it (in case a password has been applied).
Note that Excel in-built security feature is not very strong and you can easily open worksheets/workbooks that have been locked. However, if you want to quickly protect it before sending it to your manager/client (so they don’t end up changing anything by mistake), it works well.
Related Excel Articles:
- Lock cells in Excel
- Lock formulas in Excel
- Unprotect Excel Sheets Without Password
- Remove Password from VBA Project in Excel
Lesson 26 – Introduction to Macros and VB Editor
In this video, I will give you a quick introduction to Excel macros and the VB Editor in Excel.
By recording a macro in Excel, you can easily automate a lot of tasks. And the best part is that you don’t need to know any coding or VBA to do this.
When you record a macro, Excel simply follows whatever you do in the workbook and create a code for it. Now you can run this code and Excel will automatically follow all the steps you showed it.
If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn.
This video lesson covers the following VBA topics:
- How to record a macro in Excel
- Absolute and Relative Cell References
- Introduction to the Visual Basic Editor.
Related Excel Articles:
- Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit)
- Working with Worksheets using Excel VBA
- Using Workbook Object in Excel VBA (Open, Close, Save, Set)
- Understanding Excel VBA Data Types (Variables and Constants)
- Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples)
- If Then Else Statement in Excel VBA (explained with examples)
- For Next Loop in Excel VBA – A Beginner’s Guide with Examples
- How to Assign a Macro to a Button in Excel
Here are some additional useful basic Excel tutorials:
ABOUT THE INSTRUCTOR
I am Sumit Bansal, your instructor for this Excel Training. I have been training people in basic/advanced Excel and dashboards for more than 10 years now.
I have also been honored with the Microsoft Excel MVP status for my expertise in Excel.
Learning Excel becomes a cakewalk when you do it the right way. First, you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.
In this Excel course, I’ve focussed on giving you a structured and comprehensive learning experience. It makes sure you have a rock-solid foundation and then covers advanced Excel concepts that will make you an Excel Wizard.
When you’re done with the course, I guarantee you’ll be able to do a lot more in Excel in a fraction of the time.
FAQs about this FREE Online Excel Training
Is this course really free?
Yes, it is! You can just scroll up and start watching the videos and learn Excel.
You don’t need to sign up for anything or pay for anything. This training is completely free and covers most of the Excel topics you need to get started and become a pro.
You get to watch each and every lesson absolutely free (and as many times as you want).
All you need is a decent internet connection.
Can I download the videos?
No, you can only watch the videos online. These videos can not be downloaded.
However, this FREE Excel training is available to watch as many times as you want.
Which version of Excel is used to create this course?
I have used the Excel 2013 to record these videos.
Almost everything covered in this free course will work for all the Excel versions (2007, 2010, 2013, 2016, 2019, and even Excel 365).
There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013)
Who is the instructor of this Excel training?
My name is Sumit Bansal and I am your instructor throughout this FREE online Excel training.
I have practically been in a relationship with Excel since 2007. My aim in this course is to give you the best possible Excel learning (absolutely free).
I have been highly passionate about learning and teaching Excel and have trained thousands of Excel enthusiasts to use Excel the most efficient way.
I have also been recognized as an Excel MVP by Microsoft for my passion to learn and teach people on using Excel the right way.
Most valuable help I ever received from internet. Great Work
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
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?
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
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
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
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
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.
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.
Fact,,
I Want to Join.
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.
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.
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
Pravin.
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!
Excel video
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
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
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!
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.
Excellent. Explanation is brilliant.
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.
Example:
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.
Excellent Course. Really useful. Thanks!
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?
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.
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.
Hello I am reviewing your free excel training course. Does your course offer practice after watching the videos?
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?
how can send a query in excel
Thanks a lot. I receive more about Excel.
wonderful teaching and lessons.Thanks Lot. I learnt Lot
I receive more knowledge related Excel thinks you if you have other levees of excel send me linked
Can I get any kind of proof that I completed the modules at the end?
Thank uuuuuu