Excel 2016
In this free Excel 2016 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
search
menu
Excel 2016 Basics
-
1
Getting Started with Excel arrow_forward_ios ✓
Learn your way around the Excel 2016 environment.
-
2
Understanding OneDrive arrow_forward_ios ✓
Learn all about working with your Microsoft account and OneDrive.
-
3
Creating and Opening Workbooks arrow_forward_ios ✓
Learn how to create and open Excel workbooks.
-
4
Saving and Sharing Workbooks arrow_forward_ios ✓
Learn how to save and share Excel workbooks.
Working with Cells and Sheets
-
5
-
6
Modifying Columns, Rows, and Cells arrow_forward_ios ✓
Learn how to modify rows, columns, and cells in Excel.
-
7
Formatting Cells arrow_forward_ios ✓
Learn all about formatting text in Excel.
-
8
Understanding Number Formats arrow_forward_ios ✓
Learn all about formatting numbers in Excel.
-
9
Working with Multiple Worksheets arrow_forward_ios ✓
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
-
10
Using Find & Replace arrow_forward_ios ✓
Learn how to use Excel's Find and Replace features to search for specific data.
-
11
Checking Spelling arrow_forward_ios ✓
Learn how to use Excel's spell check feature.
-
12
Page Layout and Printing arrow_forward_ios ✓
Learn how to use Excel commands that let you control the way your content will appear on a printed page.
Formulas and Functions
-
13
Intro to Formulas arrow_forward_ios ✓
Learn how to use cell references to create a simple formula in Excel.
-
14
Creating More Complex Formulas arrow_forward_ios ✓
Learn how to create a complex formula in Excel.
-
15
Relative and Absolute Cell References arrow_forward_ios ✓
Learn all about absolute and relative cell references and how they're used in Excel.
-
16
Functions arrow_forward_ios ✓
Learn the different parts of a function and how to create arguments to calculate values and cell references.
Working with Data
-
17
Basic Tips for Working with Data arrow_forward_ios ✓
Learn these basic tips for working with data to help you organize it and find what you need.
-
18
Freezing Panes and View Options arrow_forward_ios ✓
Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
-
19
Sorting Data arrow_forward_ios ✓
Learn how to sort data to better view and organize the contents of your spreadsheet.
-
20
Filtering Data arrow_forward_ios ✓
Learn how to filter the data in your worksheet to display only the information you need.
-
21
Groups and Subtotals arrow_forward_ios ✓
Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
-
22
Tables arrow_forward_ios ✓
Learn how to use styles to format tables in Excel.
-
23
Charts arrow_forward_ios ✓
Learn how to insert and modify Excel charts to visualize comparisons in your data.
-
24
Conditional Formatting arrow_forward_ios ✓
Learn how to apply, modify, and delete conditional formatting rules in Excel.
Doing More with Excel
-
25
Track Changes and Comments arrow_forward_ios ✓
Learn how to use Excel's track changes and comments features when proofreading workbooks.
-
26
Inspecting and Protecting Workbooks arrow_forward_ios ✓
Learn how to inspect and protect your Excel workbook.
-
27
Intro to PivotTables arrow_forward_ios ✓
Learn how to use PivotTables in Excel for stronger data analysis.
-
28
Doing More with PivotTables arrow_forward_ios ✓
Learn how to do more with PivotTables in Excel to better summarize data.
-
29
What-if Analysis arrow_forward_ios ✓
Learn how to use what-if analysis to answer different types of questions.
Extras
-
30
Buying Office 2016 arrow_forward_ios ✓
If you're considering purchasing Office 2016, learn about some important changes you should know about.
-
31
New Features in Office 2016 arrow_forward_ios ✓
Discover some of the new features in Office 2016.
-
32
What are Reference Styles? arrow_forward_ios ✓
Learn all about using reference styles in Excel.
-
33
More Resources arrow_forward_ios ✓
These free resources can help you better work with and manipulate data in Excel.