Creating Calculated Fields

Creating Calculated Items

Sorting Pivot Table Data

Creating Filter Fields

Showing Filter Page Fields

Drilling Down Into the Data

Creating Pivot Tables from Multiple Ranges

Grouping Fields

Using VLookups with Pivots

Percentages of Parent Row Totals

Summarise Values By

Inserting Timelines

Assign Macros to Worksheet Controls

Exploring the Visual Basic Editor

Making Simple Edits to Macros

Disable Screen Flashing

Inserting Breakpoints

Creating Worksheet Functions

Using Worksheet Functions

Distributing Worksheet Functions

Creating Hyperlinks to Files and Websites

Creating Links to Workshop Locations and Emails

Using Excel Data in Word

Using Excel Charts in Word

Using Excel Data as a Mail Merge

Importing & Exporting Data

Creating Dynamic Named Ranges

Assigning Formula Names

Data Validation with the INDIRECT Function

Creating Running Totals

ISERR Function

ISERROR Function

ISBLANK Function

ISNUMBER Function

ISNA Function

ISFORMULA Function

DSUM & DCOUNT Functions

DMIN & DMAX Functions

DAVERAGE Function

Understanding Array Formulas

Creating Array Formulas

Understanding Dynamic Arrays

Cleaning and Shaping Data

Combining Data with Merge

Combining Data with Amend

Loading and Refreshing