Prerequisites

None / minimal Excel exposure

Learning Objectives

▪ Participants will build confidence in using Excel for basic data handling and reporting. (Microsoft Excel: Basic)

▪ Enable participants to clean, process, and analyze data effectively (Microsoft Excel: Intermediate)

▪ Equip participants with tools to analyze data, automate workflows, and build decision-support models (Microsoft Excel: Advance)

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

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand basic concept of Microsoft Excel.

Course Outline

Day 1 – Microsoft Excel: Basic

Lesson 1 – Excel Basics & Interface

Lesson 2 – Basic Functions (Simplified)

Lesson 3 – Formatting Essentials

Lesson 4 – Cell Referencing

Lesson 5 – Organizing Data (Basic)

Lesson 6 – Charts (Basic)

Day 2 – Microsoft Excel: Intermediate

Lesson 1 - Functions Refresher

Lesson 2 - Core Functions (The Real Intermediate Core)

Lesson 3 - Working with Tables

Lesson 4 - Sorting, Filtering & Subtotal

Lesson 5 - Conditional Formatting

Lesson 6 - Charts for Reporting

Lesson 7 - Named Ranges & Cross-Sheet Calculations

Day 3 – Microsoft Excel: Advance 

Lesson 1 – Pivot Tables & Pivot Charts (CORE)

Lesson 2 – Advanced Data Analysis Tools

Lesson 3 – Data Validation & Workflow Control

Lesson 4 – What-If Analysis (Curated, not overloaded)

Lesson 5 – Working with Multiple Workbooks

Lesson 6 – Importing Data

Lesson 7 – Auditing & Error Checking

Lesson 8 – Protection & Collaboration

Lesson 9 – Macros

Methodology

▪ 30% explanation

▪ 70% hands-on (Personal expense tracker)