Excel & Google Sheets for the Workplace
Master Excel and Google Sheets in 22 days — from basics to advanced formulas and dashboards. Essential spreadsheet skills for every Filipino professional and job seeker.
Duration
22 days
Daily Time
15-30 minutes
Level
Beginner
What You'll Achieve
- Build interactive dashboards with slicers, dynamic charts, and KPI panels
- Master VLOOKUP, INDEX/MATCH, XLOOKUP, pivot tables, and conditional formatting
- Automate repetitive tasks with Google Apps Script and modern array functions
- Use AI tools alongside spreadsheets for faster data analysis and reporting
Day-by-Day Curriculum
Day 1
Why Spreadsheet Skills = Career Insurance
Day 2
Navigating Like a Pro — The Interface Tour
Day 3
Cell References & Professional Formatting
Day 4
Your First Formulas — SUM, AVERAGE, COUNT, MIN, MAX
Day 5
Making Decisions with IF
Day 6
Counting & Summing with Conditions — COUNTIF, COUNTIFS, SUMIF, SUMIFS
Day 7
Mastering Text Functions
Day 8
Working with Dates & Time
Day 9
VLOOKUP — The King of Spreadsheet Formulas
Day 10
INDEX/MATCH — The Pro Upgrade
Day 11
XLOOKUP & Modern Array Functions
Day 12
Google Sheets Power Functions
Day 13
Sorting, Filtering & Cleaning Messy Data
Day 14
Pivot Tables — Your New Best Friend
Day 15
Conditional Formatting — Visual Data Analysis
Day 16
Charts & Sparklines — Visual Storytelling with Data
Day 17
Data Validation, Dropdowns & Named Ranges
Day 18
Building Your First Dashboard
Day 19
Interactive Dashboards — Slicers, Dynamic Charts & KPI Panels
Day 20
Sharing, Protecting & Real-World Collaboration
Day 21
Google Apps Script — Automate Your Repetitive Tasks
Day 22
AI + Spreadsheets, Your Cheat Sheet & What's Next
The Skill Every Filipino Professional Needs
Whether you work in BPO, banking, retail, HR, or any office environment, spreadsheet skills are career insurance. Yet most Filipino professionals only use 10% of what Excel and Google Sheets can do.
This 22-day course takes you from navigating the interface to building interactive dashboards. You will master essential formulas like SUM, AVERAGE, COUNT, IF, COUNTIF, and SUMIF, then level up to VLOOKUP, INDEX/MATCH, and the modern XLOOKUP. Every lesson uses real Philippine workplace scenarios.
From Formulas to Dashboards
Each day builds on the previous one. You will learn text functions, date and time calculations, and professional cell formatting. You will master pivot tables, conditional formatting for visual data analysis, and charts and sparklines for storytelling with data. The course then moves into dashboard building — first a foundational dashboard, then interactive dashboards with slicers, dynamic charts, and KPI panels. You will also learn data validation, dropdowns, named ranges, and real-world collaboration including sharing and protecting your work.
Beyond the Basics — Automation and AI
We cover both Excel and Google Sheets, including Google Sheets-specific power functions. You will learn Google Apps Script to automate repetitive tasks, and how to combine spreadsheets with AI tools for faster analysis and reporting. By Day 22, you will have the skills to handle any spreadsheet task your manager throws at you — and a cheat sheet to reference when you need it.