Introduction

In today’s data-driven workplace, Microsoft Excel remains an essential tool for organizing information, preparing reports, analyzing data, and supporting better business decisions. This program is designed to help participants build practical Excel skills progressively, from basic data handling and formatting to intermediate data processing and advanced analysis. Participants will learn how to use formulas, functions, tables, charts, PivotTables, data validation, What-If Analysis, and macros to improve efficiency and reporting accuracy. These skills will enable participants to manage data more confidently, analyze information effectively, and contribute positively to their daily work and organizational goals.

Course Objective

• (Microsoft Excel: Basic) Participants will build confidence in using Excel for basic data handling and reporting. 
• (Microsoft Excel: Intermediate) Enable participants to clean, process, and analyze data effectively
• (Microsoft Excel: Advance) Equip participants with tools to analyze data, automate workflows, and build decision-support models

Learning Outcomes

Basic

• Enter, format, and organize data
• Use basic formulas
• Create simple charts

Intermediate

• Use key functions for automation
• Clean messy datasets
• Organize and summarize data
• Create meaningful report

Advance

• Analyze large datasets
• Build dynamic reports
• Automate calculations
• Perform scenario analysis

Target Audience

Course Outline

DAY 1: Microsoft Excel: Basic

Module 1: Excel Basics & Interface

Module 2: Basic Functions

Module 3: Formatting Essentials

Module 4: Cell Referencing

Module 5: Organizing Data

Module 6: Charts

DAY 2: Microsoft Excel: Intermediate

Module 1: Functions Refresher

Module 2: Core Functions

Module 3: Working With Tables

Module 4: Sorting, Filtering & Subtotal

Module 5: Conditional Formatting

Module 6: Charts For Reporting

Module 7: Named Ranges & Cross-Sheet Calculations

DAY 3: Microsoft Excel: Advanced

Module 1: Pivot Tables & Pivot Charts

Module 2: Advanced Data Analysis Tools

Module 3: Data Validation & Workflow Control

Module 4: What-If Analysis

Module 5: Working With Multiple Workbooks

Module 6: Importing Data

Module 7: Auditing & Error Checking

Module 8: Protection & Collaboration

Module 9: Macros

Methodology

This program will be delivered using both explanation and hands-on practical activities.

• 30% explanation
• 70% hands-on practice using a personal expense tracker