Excel Basics
Using "Paste Special" 
Using Text to Columns 
Tips on Filtering with "AutoFilter" 
Using Goal Seek

Data Validation in Excel 
About Conditional Formatting 
Basics of Protecting a Worksheet 
Basics of Using Subtotals 
Basics of Print Setup Options 
Formatting Tricks 
Grouping Tabs to Save Time
Conditional Format with Four Conditions
Adding Tool Tips to Cells

 

Pivot Tables
Create a Basic Pivot Table
Sorting in a Pivot Table
Create a Drill Down Effect with a Pivot Table
Adding a Calculated Field in a Pivot Table
Grouping in a Pivot Table
Creating Pivot Charts
Using Pivot Table Advanced Options
Convert Pivot Tables Into Hard Data
Synchronize 2 Pivot Tables with a Combo Box
Tie a Chart to a Pivot Table
All About Multiple Consolidation Ranges
Pivot Table Based Conditional Chart
Add Dynamic Icons to Pivot Table Reports
Pivot Tables and Spreadsheet Bloat 

 

Excel Charting Techniques
Combo Charts and Formatting Data Points
Create Dynamic Chart Labels
Create a Histogram Chart
Using the Bar to Pie Chart
Add Average Line to a Chart
Invert Negatives in a Chart
Create a Scrolling Chart (With Dynamic Ranges)
Create a Basic Speedometer Chart
Create a Thermometer Effect in you Column Charts
Creating a Delta Chart
Creating a Benchmark Chart
Use Excel Charts in PowerPoint Without Bloat
Creating Bullet Graphs in Excel

 

Excel Functions Explained

Matrix Lookup Formula (Index and Match)
Cell Information Functions
Text and String Functions
Formula to Convert Trailing Minus Signs
Using IF(AND()) & IF(OR()
Using the SumProduct() Function
Basics of Nested Formulas
Conditional Sums and Array Formulas
Using the SUBTOTALS Function
Dynamic Ranges Finally Explained

 

Excel Tips and Tricks

Increase Available Undo Actions
Using the COUNTIF() to Find Duplicates
Set Duplicates Warning with Data Validation
Formula to convert your dates to quarters
Sort by Color without an Add-in
Turn a Row Oriented Dataset into a Column Oriented Dataset
Sort by Capitalization

 

Using Excel Macros
All About Recording Macros 
Cleaning up your Macro generated VBA
Using Spreadsheet Form Controls
Using Macros to create a user interface
Send Emails with SENDEMAIL method
Create your First User Form (Create a Splash Screen)
Calling up Excel Dialog Boxes
Force Users to Enable Macros

 

VBA Basics
Quick overview of VBA

Understanding Reference Libraries

Declaring Variables

Using If Statements

Using Select Case Statements

The Basics of the Do Loops

Using For Next Loops

Looping with For Each Statements