Excel Level 2 (Advanced) - Comprehensive Training Guide
Module 1 - Advanced Formulas & Functions
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Advanced
Formulas & Functions.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 2 - Data Tools
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Data Tools.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 3 - PivotTables & PivotCharts
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: PivotTables &
PivotCharts.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 4 - Advanced Charting
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Advanced Charting.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 5 - What-If Analysis & Scenario Tools
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: If Analysis &
Scenario Tools.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 6 - Macros and VBA
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Macros and VBA.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 7 - Security and Workbook Management
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Security and
Workbook Management.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
Module 8 - Power Query Basics
Lesson Overview:
This module contains practice exercises and guidance on Excel skills related to: Power Query
Basics.
How to Use:
1. Open the Excel file provided.
2. Follow the structured exercises.
3. Apply each feature step-by-step.
Sample Activities:
- Analyze data using formulas or tools.
- Build dynamic charts or PivotTables.
- Automate tasks with macros.
- Clean and transform data using Power Query.
