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: !AmxrofZZlZ-whIMkJyovG7A6mX8Qjg Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.: - Learn the fundamentals of Excel in just 2 hours: 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
Hide player controls
Hide resume playing