Excel 2016: Introduction
  • Acquiring Excel 2016 and Information on Installation and Upgrade
  • WATCH ME: Essential Information for a Successful Training Experience
  • Excel 2016 Course Exercise Files
  • Excel 2016 Course Demo Files
  • Course exercise files
  • 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