Duration

1 Day

Time Schedule

Time - 9:00am to 5:00pm 

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

Lunch - 1:00pm to 2:00pm

Prerequisites

None / minimal Excel exposure

Learning Objectives

Participants will build confidence in using Excel for basic data handling and reporting.

Learning Outcomes

Participants can:

▪ Enter, format, and organize data

▪ Use basic formulas

▪ Create simple charts

Methodology

▪ 30% explanation

▪ 70% hands-on (Personal expense tracker)

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

9.00AM – 10.30AM

LESSON 1 – Excel Basics & Interface

•Understanding the Excel interface

•Workbook and worksheet concepts

•Basic navigation and shortcuts

10.45AM – 11.45AM

Lesson 2 – Basic Functions (Simplified)

•Entering functions

•AutoSum

•SUM, AVERAGE, MIN, MAX

11.45AM – 1.00PM

Lesson 3 – Formatting Essentials

•Text formatting

•Row & column formatting

•Number formatting

2.00PM – 3.00PM

Lesson 4 – Cell Referencing

•Relative vs Absolute ($) 

3.00PM – 4.00PM

Lesson 5 – Organizing Data (Basic)

•Sorting

•Basic filtering 

4.00PM – 5.00PM

Lesson 6 – Charts (Basic)

•Creating column / Pie charts

•Basic chart elements