Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Excel Tutorial for Beginners

Kevin Stratvert
3.78M subscribers
557K views 5 years ago
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-whIMkJ... Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.:    • ❎ How to use Excel   I walk through the following in this video (includes timestamps if you want to jump through the video):  …...more
...more

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
Excel Tutorial for Beginners
10KLikes
557,194Views
2019Sep 20
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-whIMkJ... Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.:    • ❎ How to use Excel   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

Shorts remixing this video

Follow along using the transcript.

Kevin Stratvert

3.78M subscribers