Learn Microsoft Excel 2016: Introduction
  • Acquiring Excel 2016 and Information on Installation and Upgrade
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Downloadable Course Transcripts
  • Section 1 - Quiz
Excel 2016: What's New
  • New and Improved Features in Excel 2016
Excel 2016: Using Touch
  • Overview of Principles of Using Touchscreen
Excel 2016: Getting Started
  • Creating and Saving a Workbook
  • Opening a Workbook
Excel 2016: Using Help
  • Online Help and Contextual Help
  • Section 5 - Quiz
Excel 2016: Excel Options
  • Personalizing your use of Excel
  • Section 6 - Quiz
Excel 2016: The Ribbon and Toolbars
  • Basics of using the Ribbon
  • Quick Access Toolbar
  • Tell Me Feature
  • Mini Toolbars and Contextual Menus
  • Status Bar
  • Section 7 - Quiz
Excel 2016: Entering and Editing Data
  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
  • Section 8 - Quiz
Excel 2016: Backup and Recovery
  • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
  • Section 9 - Quiz
Excel 2016: Fill and Series
  • Working with Fill and Series
  • Flash Fill
  • Section 10 - Quiz
Excel 2016: Viewing and Printing
  • Workbook Views, Zoom, and Freeze
  • Printing
  • Exercise 03
  • Section 11 - Quiz
Excel 2016: Cut, Copy, and Paste
  • Methods of Cutting, Copying, and Pasting
  • Section 12 - Quiz
Excel 2016: Formatting a Worksheet
  • Delete and Clear
  • Insert, Hide, Column Width and Row Height, and Merge
  • Alignment
  • Themes and Styles
  • Exercise 04
  • Section 13 - Quiz
Excel 2016: Formulas and Functions
  • Basics of Fomulas and Functions
  • Complex Examples of Formulas
  • Exercise 05
  • Section 14 - Quiz
Excel 2016: Managing Worksheets
  • Rename, Insert, Move, and Reference a Worksheet
  • Section 15 - Quiz
Excel 2016: Working with Multiple Workbooks
  • Working with Multiple Workbooks
  • Section 16 - Quiz
Excel 2016: Saving Workbooks
  • Saving in Different File Types
  • Section 17 - Quiz
Excel 2016: Proofing
  • The Spell Checker
Excel 2016: Inserting Comments
  • Inserting Comments
  • Exercise 06
Excel 2016: Basic Functions in Excel
  • The VLOOKUP Function
  • Text Functions
  • Date and Time Functions
  • Logical Functions
  • Section 20 - Quiz
Excel 2016: Graphs and Charts
  • Creating Graphs and Charts
  • Customizing a Cluster Column Chart
  • Customizing a Pie Chart
  • New Chart Types in Excel 2016
  • Exercise 07
  • Section 21 - Quiz
Excel 2016: Sorting and Filtering Data
  • Managing Data by Sorting
  • Managing Date by Filtering
  • Customizing Tables
  • Section 22 Quiz
Excel 2016: Shapes and Pictures
  • Inserting Shapes and Pictures
  • Exercise 08
  • Section 23 Quiz
Excel 2016: Formatting Cells Based on Content
  • Conditional Formatting
  • Section 24 Quiz