Advanced Excel

Advanced Excel is a practical data and productivity course designed to help learners manage, analyze and present information efficiently using Microsoft Excel.

The programme covers advanced formulas, lookup functions, data cleaning, sorting, filtering, conditional formatting, Pivot Tables, charts and professional reporting.

Learners work on practical business-style datasets and create useful reports and dashboards.

• Advanced Excel Formulas
• IF Functions
• Lookup Functions
• XLOOKUP / VLOOKUP
• Sorting & Filtering
• Conditional Formatting
• Data Validation
• Pivot Tables
• Pivot Charts
• Data Cleaning
• Charts & Reports
• Dashboard Basics
• Practical Excel Projects

Basic computer and Excel knowledge is recommended.