Chapter 1: Logical and Lookup Functions
Module A: Decision-making functions
Module B: Lookup and reference functions
Chapter 2: Advanced Formulas
Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays
Chapter 3: Special functions
Module A: Date and time functions
Module B: Text functions
Module C: Other functions
Chapter 4: Importing and Exporting
Module A: The Power Pivot Data Model
Module B: Exporting data
Chapter 5: Analysis
Module A: What-if analysis
Module B: The Analysis Toolpak
Chapter 6: Macros and Forms
Module A: Recording macros
Module B: Running macros
Module C: Forms