Duration

1 Day

Time Schedule

Time - 9:00am to 5:00pm 

Break - 10:15am to 10.30am and 3:15pm to 3:30pm 

Lunch - 1:00pm to 2:00pm

Prerequisites

Basic Excel Skills

Learning Objectives

Enable participants to clean, process, and analyze data effectively

Learning Outcomes

Participants can:

▪ Use key functions for automation

▪ Clean messy datasets

▪ Organize and summarize data

▪ Create meaningful reports

Methodology

▪ 30% explanation

▪ 70% hands-on (HR/Sales dataset cleanup)

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

9.00AM – 10.15AM

Lesson 1 - Functions Refresher

•Entering functions

•AutoSum (quick recap)

10.30AM – 11.30AM

Lesson 2 - Core Functions (The Real Intermediate Core)

❖Logical

•IF, IF + AND/OR

❖Text

•LEFT, RIGHT, MID

•TRIM

❖Date & Time

•TODAY, NOW

❖Lookup

•VLOOKUP

•XLOOKUP (intro)

11.30AM – 1.00PM

Lesson 3 - Working with Tables

•Create & format tables

•Structured references

•Using functions in tables

2.00PM – 3.15PM

Lesson 4 - Sorting, Filtering & Subtotal

•Multi-level sort

•Advanced filter basics

•Subtotals 

3.30PM – 4.00PM

Lesson 5 - Conditional Formatting

•Highlight rules

•Logic-based formatting 

4.00PM – 4.30PM

Lesson 6 - Charts for Reporting

•Combo charts

•Chart customization 

4.30PM – 5.00PM

Lesson 7 - Named Ranges & Cross-Sheet Calculations

•Naming ranges

•Basic cross-sheet formulas