How to use Microsoft Excel - Beginner to Intermediate Class (with sample files)

Are you new to Excel and not sure where to begin or how to know all the basics in one place? You have come to the right place.
In this concise yet in-depth video, learn:

1) What is Excel and how to use it?
2) How to enter and format data in Excel?
3) Understanding Excel's ribbon UI
4) How to set up filters & sort data?
5) How to add totals or averages with formulas?
6) How to create a chart from your data
7) How to highlight values below a certain number, automatically?
8) Example file & homework problems for you

Video topics & timestamps ⏱👉
==========================
0:00 - Introduction to Excel (Tanvi's tracking troubles)
1:15 - Starting Excel
1:38 - Understanding the Excel Screen (ribbon, formula bar, grid and status bar)
4:09 - Setting up the sales tracker
7:35 - Exploring Excel Ribbons
8:21 - Formatting the data so it looks nice
11:37 - Using filters to understand data (which customers paid by cash)?
13:05 - Formatting currency values
13:57 - Sorting data so highest amount shows on top
15:46 - Writing formulas to add up values
21:01 - Clearing away things in your spreadsheet
21:29 - Calculating average of values with formulas
22:39 - Visually representing data with Excel charts
24:08 - Formatting and adjusting Excel charts
27:27 - Special charting tip: Showing just selected data in the graph
28:26 - Highlighting values that are below 1200 (conditional formatting)
29:57 - Homework problems & closing remarks

Sample file 📗👇
=============
You can download the sample file for this course from here:

FREE Excel Tips Book 📖💥
=======================

Download your copy of 50 Excel Tips book from here -

Learn more 💻⏩
===============
Now that you finished the basic Excel course, here are the next learning stops for you.

Happy learning 🌼🌞😀

#ExcelCourse

[MrAloha]

Chandoo rocks! I know because I teach Excel Basics and I learned a lot from him! Thanks, Chandoo!
💪😁🌴🤙

[mariasansanna]

Sir I have a huge problem to sit and listen to videos. But your pacing, your voice, the way you teach and everything has kept me focused. Thank you for the video. ❤

[girijavarma]

This is the best source to learn Excel. pls, continue this series. I have recently started watching your videos sir.

[mercyrn]

I have never seen a better, more clear tutorial for Excel. Thank you for sharing your knowledge.

[jBartolo]

You are a gifted instructor, everything from your demeanor, your voice, your presentation, etc, is just so easy to follow and understand. Please continue the excel course, I learned more in 32 minutes than I have in the previous 10 videos I tried from other content creators. You rock…. Thank you Sir. MORE PLEASE….

[ericaoforka]

This video is 2yrs ago and it’s the BEST that has taught me so far! Thank you Chandoo🤗

[shriidharkulkarni]

I have not come across better teacher than you for teaching Excel skills. I am grateful to you Sir,

[danieloghenebrorhie]

Thank you Chandoo,
You are the best Excel teacher I have listened to.
I am almost addicted to your Excel videos now.
Thank you

[itzmesunita]

Best excel class ever.. I just finished my crash course and really excited to finish all the videos from beginner to advance... Thank you so much for this

[SVSingam]

@Chandoo. Please continue this series. I hope you begin to cover more advanced aspects of EXCEL. This can include a more beginner to advanced tutorial using Power Pivot and also using EXCEL to compute Simple and Multiple Linear Regression.

[nautiyaladarsh]

"Just watched the very first video on your channel, and I absolutely loved it! I'm excited to see more!"

[anishhamal]

This is the best Excel Beginners Video I have ever watched.

[lfgulxq]

Thank you! I am 51 years old and I just got a job that requires me to use excel. This video totally got me started!

[cricketcrazy]

One of the best channel in YouTube for Msexcel Tq sir

[bmcmails]

Please share the answers to your questions...This is the best tutorial I have ever gone thru..so please continue with the series !!

[pjaviation]

By far, the Best place to Learn Excel...Thank you for sharing this knowledge. Blessings 🙏

[sindimahlangu]

I am battling to solve the quartile, I even tried using the quartile formula. Overall, I am really impressed with this course. Very helpful in my work environment.

[wayneedmondson]

Thanks Chandoo! Never hurts to review the basics. Always something new to learn :)) Thumbs up!!

[offbeatnever]

Thank you, Sir. This is going to make me dangerously more capable with my current evidence collecting, paternal tracking, and many other things to be managed.

[canirmalchoudhary]

Very helpful...I always recommend your channel to every excel learner.