Google Sheets Productivity: Data Analysis & Dashboard Reporting
Class types
Training Delivery Format
Face to Face / Virtual
HRD Corp Claimable Course
Class types
About this course
This 2-day workshop is a practical guide to mastering data without the headache. On the first day, you will learn the “pro” way to clean up messy data, fix errors, and use powerful formulas to find the information you need instantly. On the second day, we shift from numbers to visuals. You will learn how to build interactive, “clickable” dashboards complete with charts and filters—so you can present your findings in a way that looks impressive and is easy to understand. Whether you are tracking sales, operations, or admin tasks, this course will help you work faster and look like a data expert.
This course is HRD Corp (HRDC / HRDF) claimable.
Training date
- 1 & 2 October 2025
- 5 & 6 November 2025
- 3 & 4 December 2025
Who should attend?
- Executives
- Senior Executives
- Data Analysts (Junior / Entry-Level)
- Operations Officers / Operations Executives
- Administrative Officers / Administrative Executives
- Managers and Assistant Managers
Learning outcomes
By the end of this program, participants will be able to:
Prepare and clean raw data efficiently
- Apply analytical formulas to extract insights
- Use Pivot Tables for structured analysis
- Design interactive dashboards in Google Sheets
- Deliver management-ready reports that support data-driven decisions
Program duration
- 2 Days (14 Hours Total)
- Day 1 – Foundations of Data Analysis & Preparation
- Day 2 – Interactive Dashboards & Insight-Driven Reporting
Course content
Day 1: Foundations of Data Analysis & Preparation
- Module 1: Google Sheets for Data Analysis – Orientation
- Module 2: Data Types & Data Integrity
- Module 3: Data Cleaning & Preparation
- Module 4: Essential Analysis Functions
- Module 5: Lookup & Data Matching
- Module 6: Date & Time Analysis
Day 2: Interactive Dashboards & Insight-Driven Reporting
- Module 7: Pivot Tables for Analysis
- Module 8: Data Visualization Principles
- Module 9: Interactive Reporting Techniques
- Module 10: Dashboard Design & Layout
- Module 11: Automation & Collaboration
- Module 12: Business Use Case Integration