Excel 2016

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

• 34

  Excel Quiz ✓

  Test your knowledge of Excel by taking our quiz.