Microsoft Excel – Beginner to Advanced
Master the world's most essential business tool
DT-001
DT-001
Microsoft Excel – Beginner to Advanced
Master the world's most essential business tool
5 days | Instructor-led (classroom or virtual ) | 15 CPD Points | Certificate of Completion|
ABOUT THIS COURSE
A comprehensive three-level Excel programme covering everything from basic navigation and formulas to advanced data analysis with PivotTables, VLOOKUP/XLOOKUP, macros, and dashboard creation. Each level can be taken independently or as a complete programme.
WHO IS IT FOR
All professionals who use Excel for data entry, analysis, reporting, or decision-making at any level
WHAT YOU WILL LEARN
Create and format professional spreadsheets; use formulas and functions to analyse data; build PivotTables and charts for reporting; automate repetitive tasks with macros; design interactive dashboards
TOPICS COVERED
Beginner: Navigation, formatting, basic formulas (SUM, AVERAGE, IF), sorting and filtering. Intermediate: VLOOKUP/XLOOKUP, conditional formatting, PivotTables, charts. Advanced: Macros/VBA basics, Power Query, complex formulas (INDEX/MATCH, nested IFs), dashboard design
MATERIALS INCLUDED
Course workbook per level, practice datasets, formula reference guide, exercise files