Foundations Pro
Fast-track for users with Excel basicsSkip the basics. Learn the modern Excel methods that make the difference — Tables, Power Query, AI integration. Each module is short, interactive, and delivers one concrete capability.
Quick access
F1Structured Data★
F2XLOOKUP — Connect Two Tables
F3Excel Tables (Ctrl+T)★
F4Absolute References ($) & Named Ranges
F5IF / IFS — Logical Formulas
F6SUMIFS / COUNTIFS — Conditional Totals
F7Pivot Tables
F8Charts
F9Conditional Formatting
F10Power Query Essentials
F1
Structured Data
★
Organize your data into one clean block Excel can actually use.
You walk away with : A clean, ready-to-use dataset.
F2
XLOOKUP — Connect Two Tables
Unlock
Connect two tables by a shared key — no more copy-paste.
You walk away with : Two tables connected by a key.
F3
Excel Tables (Ctrl+T)
★ Unlock
Turn a frozen range into a table that expands on its own.
You walk away with : A maintainable dataset that auto-expands.
F4
Absolute References ($) & Named Ranges
Coming
Master the $ for formulas that copy down correctly.
You walk away with : Formulas that fill down and read correctly.
F5
IF / IFS — Logical Formulas
Coming
Set up decision logic row by row.
You walk away with : Row-level decision logic.
F6
SUMIFS / COUNTIFS — Conditional Totals
Coming
Compute totals and counts that match your criteria.
You walk away with : KPIs calculated straight from your data.
F7
Pivot Tables
Coming
Cross-analyze and summarize your data in a few clicks.
You walk away with : A dynamic cross-analysis.
F8
Charts
Coming
Build a readable visual that updates on its own.
You walk away with : A clear chart that updates.
F9
Conditional Formatting
Coming
Visually surface the values that matter.
You walk away with : Visual alerts on your values.
F10
Power Query Essentials
★ Coming
Import and clean your data in a repeatable way.
You walk away with : A repeatable import-and-transform pipeline.