Our thanks to GCFGlobal for creating these awesome training materials. Click the image to go to their YouTube Playlist.
There are two parts to this instruction. First of all, here's a link to the content which is described below. Then there's also a YouTube Playlist of video instruction!
Excel 2016 Basics
1 Getting Started with Excel: Learn your way around the Excel 2016 environment.
2 Understanding OneDrive: Learn all about working with your Microsoft account and OneDrive.
3 Creating and Opening Workbooks: Learn how to create and open Excel workbooks.
4 Saving and Sharing Workbooks: Learn how to save and share Excel workbooks.
Working with Cells and Sheets
5 Cell Basics: Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
6 Modifying Columns, Rows, and Cells: Learn how to modify rows, columns, and cells in Excel.
7 Formatting Cells: Learn all about formatting text in Excel.
8 Understanding Number Formats: Learn all about formatting numbers in Excel.
9 Working with Multiple Worksheets: Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
10 Using Find & Replace: Learn how to use Excel's Find and Replace features to search for specific data.
11 Checking Spelling: Learn how to use Excel's spell check feature.
12 Page Layout and Printing: 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: Learn how to use cell references to create a simple formula in Excel.
14 Creating More Complex Formulas: Learn how to create a complex formula in Excel.
15 Relative and Absolute Cell References: Learn all about absolute and relative cell references and how they're used in Excel.
16 Functions: 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: Learn these basic tips for working with data to help you organize it and find what you need.
18 Freezing Panes and View Options: Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
19 Sorting Data: Learn how to sort data to better view and organize the contents of your spreadsheet.
20 Filtering Data: Learn how to filter the data in your worksheet to display only the information you need.
21 Groups and Subtotals: Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
22 Tables: Learn how to use styles to format tables in Excel.
23 Charts: Learn how to insert and modify Excel charts to visualize comparisons in your data.
24 Conditional Formatting: Learn how to apply, modify, and delete conditional formatting rules in Excel.
Doing More with Excel
25 Track Changes and Comments: Learn how to use Excel's track changes and comments features when proofreading workbooks.
26 Inspecting and Protecting Workbooks: Learn how to inspect and protect your Excel workbook.
27 Intro to PivotTables: Learn how to use PivotTables in Excel for stronger data analysis.
28 Doing More with PivotTables: Learn how to do more with PivotTables in Excel to better summarize data.
29 What-if Analysis: Learn how to use what-if analysis to answer different types of questions.
Extras
30 Buying Office 2016: If you're considering purchasing Office 2016, learn about some important changes you should know about.
31 New Features in Office 2016: Discover some of the new features in Office 2016.
32 What are Reference Styles?: Learn all about using reference styles in Excel.
33 More Resources: These free resources can help you better work with and manipulate data in Excel.
Quiz
Excel 2016 Quiz: Test your knowledge of Excel 2016 by taking our quiz.
Excel 2016 Basics
1 Getting Started with Excel: Learn your way around the Excel 2016 environment.
2 Understanding OneDrive: Learn all about working with your Microsoft account and OneDrive.
3 Creating and Opening Workbooks: Learn how to create and open Excel workbooks.
4 Saving and Sharing Workbooks: Learn how to save and share Excel workbooks.
Working with Cells and Sheets
5 Cell Basics: Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
6 Modifying Columns, Rows, and Cells: Learn how to modify rows, columns, and cells in Excel.
7 Formatting Cells: Learn all about formatting text in Excel.
8 Understanding Number Formats: Learn all about formatting numbers in Excel.
9 Working with Multiple Worksheets: Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
10 Using Find & Replace: Learn how to use Excel's Find and Replace features to search for specific data.
11 Checking Spelling: Learn how to use Excel's spell check feature.
12 Page Layout and Printing: 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: Learn how to use cell references to create a simple formula in Excel.
14 Creating More Complex Formulas: Learn how to create a complex formula in Excel.
15 Relative and Absolute Cell References: Learn all about absolute and relative cell references and how they're used in Excel.
16 Functions: 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: Learn these basic tips for working with data to help you organize it and find what you need.
18 Freezing Panes and View Options: Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
19 Sorting Data: Learn how to sort data to better view and organize the contents of your spreadsheet.
20 Filtering Data: Learn how to filter the data in your worksheet to display only the information you need.
21 Groups and Subtotals: Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
22 Tables: Learn how to use styles to format tables in Excel.
23 Charts: Learn how to insert and modify Excel charts to visualize comparisons in your data.
24 Conditional Formatting: Learn how to apply, modify, and delete conditional formatting rules in Excel.
Doing More with Excel
25 Track Changes and Comments: Learn how to use Excel's track changes and comments features when proofreading workbooks.
26 Inspecting and Protecting Workbooks: Learn how to inspect and protect your Excel workbook.
27 Intro to PivotTables: Learn how to use PivotTables in Excel for stronger data analysis.
28 Doing More with PivotTables: Learn how to do more with PivotTables in Excel to better summarize data.
29 What-if Analysis: Learn how to use what-if analysis to answer different types of questions.
Extras
30 Buying Office 2016: If you're considering purchasing Office 2016, learn about some important changes you should know about.
31 New Features in Office 2016: Discover some of the new features in Office 2016.
32 What are Reference Styles?: Learn all about using reference styles in Excel.
33 More Resources: These free resources can help you better work with and manipulate data in Excel.
Quiz
Excel 2016 Quiz: Test your knowledge of Excel 2016 by taking our quiz.