In these step-by-step tutorials, learn how to use Microsoft Excel. Find out how to get started with MS Excel in under 10 minutes. Learn about Pivot Tables, formulas and functions, vlookup, shortcuts. Also, find out about the latest new features and the top tips and tricks.
Curated by: Kevin Stratvert (120 videos)
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