Duration

1 Day

Time Schedule

Time - 9:00am to 5:00pm 

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

Lunch - 1:00pm to 2:00pm

Prerequisites

Strong Excel Working Knowledge

Learning Objectives

Equip participants with tools to analyze data, automate workflows, and build decision-support models

Learning Outcomes

Participants can:

▪ Analyze large datasets

▪ Build dynamic reports

▪ Automate calculations

▪ Perform scenario analysis

Methodology

▪ 30% explanation

▪ 70% hands-on (Sales dashboard+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

9.00AM – 10.00AM

Lesson 1 – Pivot Tables & Pivot Charts (CORE)

•Creating PivotTables

•Field layout

•Grouping

•Slicers

•Pivot Charts

10.00AM – 11.00AM

Lesson 2 – Advanced Data Analysis Tools

❖Trend Analysis

•Trendlines

•Sparklines

11.00AM – 12.00PM

Lesson 3 – Data Validation & Workflow Control

•Dropdown lists

•Input restriction

12.00PM – 1.00PM

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

•Goal Seek

•Scenario Manager

•Data Tables (basic)

2.00PM – 3.00PM

Lesson 5 – Working with Multiple Workbooks

•Linking workbooks

•Consolidating data

3.00PM – 3.30PM

Lesson 6 – Importing Data

•From text files

•From web

3.45PM – 4.15PM

Lesson 7 – Auditing & Error Checking

•Trace precedents/dependents

•Watch window

4.15PM – 4.30PM

Lesson 8 – Protection & Collaboration

•Protect worksheets/workbooks

4.30PM – 5.00PM

Lesson 9 – Macros

•What is a Macro?

•Recording a simple Macro