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