This 2-day practical programme equips professionals with essential Excel skills from beginner to intermediate level. Learn to manage, analyse, and present data confidently with real-world hands-on exercises.
Module 1 — Excel Essentials
Interface navigation, workbook management, cell referencing, formatting, and basic formulas — SUM, AVERAGE, COUNT, MIN, MAX.
Module 2 — Data Management & Organisation
Excel Tables, sorting, filtering, removing duplicates, and data validation including drop-downs and input alerts.
Module 3 — Intermediate Formulas & Functions
Text functions, logical functions (IF, AND, OR), and lookup functions (VLOOKUP, INDEX & MATCH).
Module 4 — Visualisation & Charting
Creating charts, using Sparklines, and applying conditional formatting to communicate data clearly.
Module 5 — PivotTables & PivotCharts
Creating, grouping, filtering, and summarising data with PivotTables and interactive charts.
Module 6 — Formula Auditing & Error Checking
Tracing precedents and dependents, evaluating formulas, and troubleshooting common errors.
Module 7 — Reporting & Practical Exercises
Designing professional reports with conditional formatting and chart integration using real-world datasets.
Duration 2 Days
Training Mode Physical Classroom
Target Audience Professionals, data analysts, business analysts, team leaders, managers, researchers, administrative & operational staff
