Course Introduction
  • A Quick Introduction and Welcome
  • Download this Exercise File
Microsoft Excel Hacks 101
  • Hack 01 - Linking Text Boxes to Worksheet Cells
  • Hack 02 - Effectively Deleting Empty Rows in a Data Set
  • Hack 03 - Quickly Fill Blank Cells with a Value
  • Hack 04 - The Secret Excel Camera Tool
  • Hack 05 - Quickly Navigating Between Excel Worksheets
  • Hack 06 - Quickly Navigating Between Excel Workbooks
  • Hack 07 - Jump Quickly to Formulas
  • Hack 08 - Adding an Average Line to Chart
  • Hack 09 - Opening the Excel Clipboard
  • Hack 10 - Creating Custom AutoFill Lists
New Excel Hacks March 2016
  • Hack 11 - Status Bar Calculations
  • Hack 12 - Data Entry Shortcuts
  • Hack 13 - Grouping Worksheets
New Excel Hacks April 2016
  • Hack #14 - Email as PDF
  • Hack #15 - Excel Calculator
  • Hack #16 - Add to AutoCorrect
New Excel Hacks May 2016
  • Hack #17 - Hidden Excel Function - DATEDIF()
  • Hack #18 - Excel Function SUMPRODUCT()
  • Hack #19 - Excel Array Formulas
  • Hack #20 - Excel SUMPRODUCT() with Criteria
New Excel Hacks June 2016
  • Hack #21 - Creating an Excel Table of Contents with VBA (UPDATED)
  • Hack #22 - Creating a Dynamic Range with Excel's OFFSET() Function
  • Hack #23 - Working with Excel Spin Controls
New Excel Hacks July 2016
  • Hack #24 - Import Data from a Website
  • Hack #25 - Paste Special - Transpose Data
  • Hack #26 - Evaluate Formulas with F9
New Excel Hacks August 2016
  • Hack #27 - Custom Views in Excel
  • Hack #28 - Excel's xlSTART Folder
  • Hack #29 - Automate with the Excel Macro Recorder
New Excel Hacks October 2016
  • Hack #30 - Convert Text To Number
  • Hack #31 - Flash Fill (New Excel 2013 Feature)
  • Hack #32 - Quick Analysis (New Excel 2013 Feature)
Congratulations
  • Congratulations