Unit 1: Advanced functions and formulas
Topic A: Logical functions
Topic B: Conditional functions
Topic C: Financial functions
Topic D: Text functions
Topic E: Date functions
Topic F: Array formulas

Unit 2: Lookups and data tables
Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 3: Advanced data management
Topic A: Validating cell entries
Topic B: Advanced filtering

Unit 4: Advanced charting
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical objects

Unit 5: PivotTables and PivotCharts
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: PivotCharts

Unit 6: Exporting and importing data
Topic A: Exporting and importing text files
Topic B: Getting external data
Unit 7: Analytical tools
Topic A: Goal Seek
Topic B: Scenarios
Unit 8: Macros and Visual Basic
Topic A: Running and recording a macro
Topic B: Working with VBA code

The Axzo Edition of this course focuses solely on the skills real users need to be productive immediately in Microsoft Excel. We’ve listened carefully to customer feedback on the content, and redesigned the course to flow better in the classroom. Setup is clean and simple, examples relevant, and extraneous content gone.