The MS Excel - Intermediate training programme builds on basic skills to explore more advanced features. Participants will learn to perform complex data analysis, use advanced formulas, and create dynamic reports.

Training Objectives and Content:

Advanced Formulas and Functions:
Learn: How to use intermediate functions and formulas for complex calculations.
Content: Using VLOOKUP, HLOOKUP, IF statements, and nested functions.

Data Analysis Tools:
Learn: How to apply tools like PivotTables, PivotCharts, and conditional formatting.
Content: Creating and analyzing PivotTables, using PivotCharts, and applying conditional formatting to highlight data trends.

Advanced Charting:
Learn: How to create and customize complex charts and graphs.
Content: Advanced chart types (combination charts, scatter plots), customizing chart elements, and using sparklines.

Data Validation and Protection:
Learn: How to implement data validation rules and protect worksheets.
Content: Setting up data validation rules, protecting cells and worksheets, and managing workbook protection.