COURSE DETAILS

TARGET GROUP: Professionals who have completed Basic and Intermediate Excel Training.

DURATION: 2-Day Course (14 hours)

METHOD: Physical (Hands On)

RESOURCES: Computer, Microsoft Excel, Microsoft Power Point, Projector, Whiteboard

COURSE OVERVIEW

The Excel Intermediate programme is designed for working professionals who already understand basic spreadsheet operations and are ready to advance their analytical capabilities. This course bridges the gap between foundational skills and higher‑level data analysis by introducing participants to more powerful functions, structured data management techniques, and practical tools used in real workplace scenarios.

COURSE OBJECTIVE

Through hands‑on exercises and guided demonstrations, learners will work with real‑world datasets to improve accuracy, efficiency, and confidence in producing reports, summaries, and insights. By the end of the programme, participants will be able to handle more complex tasks, troubleshoot common issues, and apply Excel features that support decision‑making in modern organisations.

TRAINING OUTCOMES

Participants will demonstrate:

1. Apply intermediate formulas such as logical, lookup, text, and date functions

2. Organize and manage data using tables, sorting, filtering, and structured references

3. Create meaningful charts and visual summaries for reporting

4. Use tools such as PivotTables, conditional formatting, and data validation

5. Troubleshoot formula errors and audit spreadsheets effectively

6. Improve productivity using shortcuts, templates, and automation features

7. Apply Excel techniques to real‑world business tasks with accuracy and confidence.

COURSE OUTLINE

Module 1: Introduction to Data Analysis & Excel Basics 

Module 2: Data Entry and Formatting Techniques

Module 3: Sorting & Filtering Data

Module 4: Data Validation and Cleaning

Module 5: Pivot Tables and Pivot Charts

Module 6: Data Visualization Techniques

Module 7: AI in Excel

Module 8: Interactive Analysis Technique

Module 9: Dashboard Management Reporting

Module 10: Case Study & Practical Exercises