Module 1: Getting the Most From Your Data
Topic A: Outlining and Grouping Data

Module 2: What If Analysis?
Topic A: Using Data Analysis Tools

Topic B: Exploring Scenarios

Topic C: Using Solver

Module 3: Advanced Excel Task
Topic A: Working with Array Formulas

Topic B: Using the VLOOKUP Function

Topic C: Using the Advanced Function

Topic D: Linking, Consolidating, and Combining Data

Module 4: Advanced Chart
Topic A: Create Advanced Chart

Module 5: Analyzing Data with PivotTable, Slicer and PivotCharts
Topic A: Create a PivotTable

Topic B: Filter Data by Using Slicer

Topic C: Analyzing Data with PivotChart

Module 6: Enhancing Workbooks
Topic A: Customizing Workbooks

Module 7: Macros And Form Controls
Topic A: Macros

Topic B: Form Controls

Module 8: Publishing & Protection
Topic A: Finishing Workbook

Topic B: Protecting Worksheet and Workbook

SA-EXA-2: Microsoft Excel Advanced