Excel 2016

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite.

Training Solution

Excel Basics

Tutorial

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.

Powered by WordPress.com.

Up ↑

%d bloggers like this: