Excel 2016 Tutorial


Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial.

Excel 2016 Basics
1 Getting Started with Excel
2 Understanding OneDrive
3 Creating and Opening Workbooks
4 Saving and Sharing Workbooks
Working with Cells and Sheets
5 Cell Basics
6 Modifying Columns, Rows, and Cells
7 Formatting Cells
8 Understanding Number Formats
9 Working with Multiple Worksheets
10 Using Find & Replace
11 Checking Spelling
12 Page Layout and Printing
Formulas and Functions
13 Intro to Formulas
14 Creating More Complex Formulas
15 Relative and Absolute Cell References
16 Functions
Working with Data
17 Basic Tips for Working with Data
18 Freezing Panes and View Options
19 Sorting Data
20 Filtering Data
21 Groups and Subtotals
22 Tables
23 Charts
24 Conditional Formatting
Doing More with Excel
25 Track Changes and Comments
26 Inspecting and Protecting Workbooks
27 Intro to PivotTables
28 Doing More with PivotTables
29 What-if Analysis

Have you tried this resource? Help someone out by sharing your thoughts!

Write a review

More Ways to Learn Microsoft Excel

High School - College | Free
PRDV004: Spreadsheets
Saylor Academy
PRDV004: Spreadsheets
College | Free
Excel Tutorials
Excel Tutorials
College | Free
Mastering Data Analysis in Excel
Duke University
Mastering Data Analysis in Excel
College | Free