Module 1 - Introduction to the Course
  • Introduction Video - Watch This Before You Start
Module 2 - Microsoft Excel Tips, Tricks & Shortcuts
  • Module 2 - Microsoft Excel Tips, Tricks & Shortcuts Introduction Video
  • Excel 2016 - Autosum
  • Excel 2016 - Copying Worksheets
  • Excel 2016 - Sending a Single Worksheet to Someone
  • Excel 2016 - Quick Graph Creation
  • Excel 2016 - Splitting data from one cell into multiple cells (Text to Columns)
  • Excel 2016 - TRIM Function
  • Excel 2016 - Proper Function
  • Excel 2016 - Concatenate Function
  • Excel 2016 - Fit to a Page
  • Excel 2016 - Headers & Footers
  • Excel 2016 - Transpose
  • Excel Tips & Shortcuts Quiz
Module 3 - Microsoft Word Tips, Tricks & Shortcuts
  • Module 3 - Microsoft Word Tips, Tricks & Shortcuts Introduction Video
  • Word 2016 - Format Painter
  • Word 2016 - Line Spacing
  • Word 2016 - Bullets
  • Word 2016 - Tables
  • Word 2016 - Copying & Pasting Tips
  • Word 2016 - Page Breaks
  • Word 2016 - Headers & Footers
  • Word 2016 - Inserting an Excel Worksheet into a Word Document
  • Word Tips & Shortcuts Quiz
Module 4 - Microsoft Excel - Automation
  • Module 4 - Microsoft Excel Automation Introduction Video
  • Excel 2016 - Range Names
  • Excel 2016 - 3 Dimensional Formulas
  • Excel 2016 - Pivot Tables
  • Excel 2016 - SubTotals
  • Excel 2016 - Droplists
  • Excel 2016 - Conditional Formatting
  • Excel 2016 - Remove Duplicates
  • Excel 2016 - Hyperlinks
  • Excel 2016 - Protection
  • Excel 2016 - Macros
  • Excel Automation Quiz
Section 5 - Word 2016 - Automation
  • Module 5 - Microsoft Word Automation Introduction Video
  • Word 2016 - Autocorrect
  • Word 2016 - Quickparts
  • Word 2016 - Watermarks
  • Word 2016 - Inserting One File Into Another
  • Word 2016 - Styles
  • Word 2016 - Table of Contents
  • Word 2016 - Templates
  • Word 2016 - Mail Merge with Excel Data Source
  • Word 2016 - Inserting File Name & Path
  • Word Automation Quiz
Summary Video
  • Summary Video - You've finished, Congratulations, Watch this video.