Excel 2016: Introduction to Excel 2016 Beginner Course
  • 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
  • Exercise Files
  • Downloadable Course Transcripts
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
Excel 2016: Excel Options
  • Personalizing your use of Excel
Excel 2016: The Ribbon and Toolbars
  • Basics of using the Ribbon
  • Quick Access Toolbar
  • Tell Me Feature
  • Mini Toolbars and Contextual Menus
  • Status Bar
Excel 2016: Entering and Editing Data
  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
Excel 2016: Backup and Recovery
  • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Excel 2016: Fill and Series
  • Working with Fill and Series
  • Flash Fill
Excel 2016: Viewing and Printing
  • Workbook Views, Zoom, and Freeze
  • Printing
  • Exercise 03
Excel 2016: Cut, Copy, and Paste
  • Methods of Cutting, Copying, and Pasting
Excel 2016: Formatting a Worksheet
  • Delete and Clear
  • Insert, Hide, Column Width and Row Height, and Merge
  • Alignment
  • Themes and Styles
  • Exercise 04
Excel 2016: Formulas and Functions
  • Course review
  • Basics of Fomulas and Functions
  • Complex Examples of Formulas
  • Exercise 05
Excel 2016: Managing Worksheets
  • Managing Worksheets
Excel 2016: Working with Multiple Workbooks
  • Working with Multiple Workbooks
Excel 2016: Saving Workbooks
  • Saving in Different File Types
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
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
Excel 2016: Sorting and Filtering Data
  • Managing Data by Sorting
  • Managing Data by Filtering
  • Customizing Tables
Excel 2016: Shapes and Pictures
  • Inserting Shapes and Pictures
  • Exercise 08
Excel 2016: Formatting Cells Based on Content
  • Conditional Formatting
Excel 2016: Protection and Security
  • Protecting Worksheets
  • Protecting Workbooks
Excel 2016: Naming Items
  • Giving Items Names
  • Exercise 09
Excel 2016: Finding and Replacing Words
  • Find and Replace
Excel 2016: Borders
  • Adding Borders
Excel 2016: Workbook Inspection
  • Inspecting a Workbook
Excel 2016: Privacy Options
  • Trust Center Privacy Options
Excel 2016: Sharing Options
  • Sharing a Workbook
Excel 2016: Wrap Up