Excel Tutorial for Beginners

Learn how to use Excel with this step-by-step tutorial. As full disclosure, I work at Microsoft as a full-time employee.

I walk through the following in this video (includes timestamps if you want to jump through the video):

- Intro, What is Microsoft Excel and how do spreadsheets help you analyze data? 0:00
- How to get Microsoft Excel 1:14
- Navigating the home screen 4:30
- Orientation to the main screen of Excel (including how to reference cells) 6:53
- Formatting (including accounting, comma style, wrap text, and merge and center) 8:20
- Adjust cell size, column size, and row size. 10:30
- Basic formulas (including addition, subtraction, multiplication, division, count, max, sum, and auto sum) 12:10
- Fill series (including absolute references and relative references) 15:57
- Split data 19:18
- Filter and Sort 20:28
- Tables 22:24
- Quick Analysis 23:50
- Ideas 24:40
- Charts 25:30
- Freeze Pane 27:03
- Pivot Tables 28:15

[leevinson]

I'm a chef that lives in New York and I decided to jump head first into the consulting field last year. Your videos have really helped me transfer into a new level of thinking and how to run a business using Excel and my iPhone, not my voice.
So glad I found a desk job and YOU before the world crashed. People talk about making education free...you're actually doing it. Thank you sir

[haroldfrazier]

I am an elderly person and I haven't used Excel for a long time and I really appreciate how clearly you make your videos and how you explain them so us non-tech people can understand what you are saying. This was a great video and I will be watching all of your Excel videos as fast as I can try out each of them. Thanks again for a great explanation of Excel. Take care and God Bless.

[mdianec]

I was proficient in Excel. Haven’t used it in a dozen years since I started taking care of my grandkids. Your clear and detailed tutorial dusted off the cobwebs fast! Thank you so much! Will subscribe and looking forward to watching them all.

[geocosmicvalentine]

This was an EXCELLENT review for me. I haven't used Excel in years and needed a strong reminder and this was perfect! Thank you.

[Arsalan_]

Thank you Kevin for going through the trouble of making such informative video. I learnt a lot from watching your videos. I especially appreciate the fact that you gave us your excel sheet that you showed us in the video so we can practise on it while watching your video. it really helps a lot. appreciate the time and energy you put in making such great content for us. never stop making such videos please. thanks again:) you changed my life bro.

[CriminologistRWorst]

Finally found someone teaching the basics of MS Office and all of its applications to ease into the more advanced especially TEAMS! Thank you! Keep up the content!

[isaiahdelgado]

This guy is so charismatic! I mean he has my full attention and took all the anxiety and worry out of learning a true master. I have always had help or dodged Excel by paying people and now I know with this teacher I will be on another level !!!

[silviaheubach]

This is a very comprehensive overview of the important items in Excel for beginners! Very good job!

[GbawlZ]

I'm an accountant with a master's in tax who spent his first two years working in tax, so I didn't use Excel too much. Within the past year, I switched over to audit and I felt so behind on my Excel skills. Your videos are really helping me catch up, thank you very much!

[riyagupta]

Your videos are addictive I can't stop watching its just so knowledgeable

[Shine.with.Visions]

Let me just say thank you!! I truly appreciated this video and it will be my go to resource for my personal and business platforms

[runningwild]

An awesome video. I knew the basics of excel, but this video really helped me brush up on my skills prior to my job interview. I can now handle the basics with a renewed confidence. Highly recommend this - quick, easy, painless and no-nonsense. 10/10.

[hninaye]

I have been watching tons of excel tutorial, but yours is the best and so easy to follow and get to the point! Keep it up!! Thank you!

[SoulMotivationRecords]

Man you rock dude! Best tutorials by far on Excel! I am watching all your videos and learning so much. I can't believe it took me so long to learn this stuff. Thanks so much brother!

[artn]

Thanks, Kevin. I haven't used Excel a lot for many years so this was the perfect video to refresh my memory. Looking forward to watching more of these Excel videos.

[ezraperez]

Thank you so much man. short and straight to the point, even better with the time stamps. Bless you!!!

[judyvasconcelles]

You are just AMAZING!! I can't believe you are so generous with your time to make these videos. I am learning so much thanks to you. Thank you so much.

[eleonoragrigorova]

Great tutorial and explained in a simple and fast way to be easy understood and learned. THE BEST I’ve found so far! Good job and thank u!!!

[sherinehill]

Thank u Kevin.. lots of clarity, appreciate your time & effort
may the Lord continue to bless and keep u .

[edwinfrancisco]

Its been 3 years since I used excel in high school. I'm about to start data analytics in college. Thank you for your help!! Lifesaver!