Microsoft Excel Advanced (2025)

Lesson 1: Automating Worksheet Functionality

• Topic A: Update Workbook Properties
• Topic B: Create and Edit a Macro
• Topic C: Apply Conditional Formatting Topic
• D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets

• Topic A: Trace Cells
• Topic B: Troubleshoot Invalid Data and Formula Errors
• Topic C: Watch and Evaluate Formulas Topic
• D: Create a Data List Outline

Lesson 3: Analysing and Presenting Data

• Topic A: Create Sparklines
• Topic B: Create Scenarios
• Topic C: Perform a What-If Analysis
• Topic D: Perform a Statistical Analysis with ToolPak
• Topic E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks

• Topic A: Consolidate Data
• Topic B: Link Cells in Different Workbooks Topic
• C: Merge Workbooks

Lesson 5: Exporting Excel Data

• Topic A: Export Excel Data
• Topic B: Import a Delimited Text File
• Topic C: Integrate Excel Data with the Web
• Topic D: Create a Web Query

Lesson 6: Importing and Exporting XML Data

• Topic A: Import and Export XML Data