ƒx
Formulas & Functions
Learn formulas for text, dates, numbers, logic, counting, summaries, and error handling.
SUMIFSCOUNTIFSIFERROR
Practical Excel Training for Real Work
Master Excel.
Work Smarter.
From raw data to confident decisions.
Excel @ Work helps students, employees, admins, and business owners learn the Excel skills used in offices every day: formulas, lookups, Power Query, dashboards, reports, and automation-ready workflows.
50+Core Formulas
10+Dashboard Skills
100%Work-Based
ID
Task
Formula
Status
001
Clean Names
PROPER
Done
002
Find Match
XLOOKUP
Ready
003
Build Report
Pivot
Live
=XLOOKUP(A2, Table[ID], Table[Name])
Dynamic Dashboard
What You Will Learn
Excel skills you can use immediately at work.
Every lesson is designed around office tasks: cleaning data, preparing reports, tracking records, and presenting results clearly.
↔
Lookups & Matching
Find records, connect tables, and reduce manual searching using lookup formulas.
VLOOKUPHLOOKUPXLOOKUP
▦
Tables & Pivot Reports
Turn messy data into clean tables, summaries, pivot tables, charts, and slicers.
TablesPivotTableSlicers
PQ
Power Query
Import, clean, combine, transform, and refresh data without repeating manual steps.
CleanMergeAppend
📊
Dynamic Dashboards
Create interactive dashboards with KPIs, charts, filters, timelines, and clear visual stories.
KPIChartsReports
⚡
Workflow Automation
Build smarter files using data validation, conditional formatting, reusable templates, and refreshable reports.
ValidationTemplatesRefresh
Function Samples
Famous Excel formulas included in the training.
These are the common formulas used for reports, student records, sales summaries, inventory, payroll, and office monitoring sheets.
SUMIFS
=SUMIFS(Sales, Region, "Cebu", Month, "June")COUNTIFS
=COUNTIFS(Status,"Done",Dept,"Admin")XLOOKUP
=XLOOKUP(E2,ID,Full_Name,"Not Found")VLOOKUP
=VLOOKUP(A2,Table,3,FALSE)HLOOKUP
=HLOOKUP(B1,Data,4,FALSE)INDEX MATCH
=INDEX(Name,MATCH(A2,ID,0))IF + AND
=IF(AND(C2>=75,D2="Yes"),"Pass","Check")TEXTJOIN
=TEXTJOIN(" ",TRUE,First,Last)FILTER
=FILTER(Table,Table[Status]="Pending")UNIQUE
=UNIQUE(Table[Department])PROPER/TRIM
=PROPER(TRIM(A2))IFERROR
=IFERROR(A2/B2,0)Power Query + Dashboards
Clean data once. Refresh reports anytime.
Learn how to turn raw spreadsheets into clean tables, then use them for pivot reports, charts, and dynamic dashboards.
Sales Dashboard
LIVE REPORT₱84KRevenue
326Orders
92%Target
1
Import
Load CSV, Excel files, folders, and tables into Power Query.
2
Transform
Remove blanks, split columns, change data types, replace values, and standardize text.
3
Model
Prepare clean structured tables for pivot reports and dashboards.
4
Refresh
Update reports quickly when new records are added.
Meet Your Instructors
Four mentors. One practical Excel learning path.
Each instructor brings a different workplace focus, from formulas and data cleaning to reporting and dashboard presentation.
KART VICTOR LAGUSTAN, CPA
Lead Excel Instructor
Education: Certified Public Accountant · Microsoft Excel Specialist
ENGR. JOHN MARK LADERA
Computer Engineer
Education: BS Computer Engineering · Data Analytics Certificate
JUDE IVO SILVA
Optum Data Contributor
LESTER JHONE SOLOMON
Management Accounting
Education: BS Management Accounting
Companies Served
Organizations that completed our Excel training.
Click a company card to view training photos and documentation.
Enroll Now
Start building Excel skills that make work faster.
Perfect for students, office staff, admin assistants, teachers, freelancers, small business owners, and anyone who handles spreadsheet data.
FAQ
Common questions.
Is this for beginners?
Yes. The lessons start with basic Excel skills and move toward advanced workplace outputs.
Will Power Query be included?
Yes. You will learn cleaning, transforming, merging, appending, and refreshing data.
Will dashboards be included?
Yes. You will learn KPI cards, pivot charts, slicers, timelines, and dynamic report layouts.
What is the tagline?
From raw data to confident decisions.