Excel 2016

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organising and calculating data by following these excellent tutorials.

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

Please note that nomadlearning is in no way affiliated with the developer of these tutorials. All content included on this page is ©  GCFLearnFree.org.