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.

Here's the workbook I used throughout this tutorial: https://1drv.ms/x/s!AmxrofZZlZ-whIMkJyovG7A6mX8Qjg

Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

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