Foundations Pro

Fast-track for users with Excel basics

Skip 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.
Data · AI · Beginner
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.
Formulas · Beginner
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.
Data · Automation · AI · Beginner
You walk away with : A maintainable dataset that auto-expands.
F4 Absolute References ($) & Named Ranges Unlock
Master the $ for formulas that copy down correctly.
Formulas · Beginner
You walk away with : Formulas that fill down and read correctly.
F5 IF / IFS — Logical Formulas Unlock
Set up decision logic row by row.
Formulas · Analysis · Beginner
You walk away with : Row-level decision logic.
F6 SUMIFS / COUNTIFS — Conditional Totals Unlock
Compute totals and counts that match your criteria.
Formulas · Analysis · Beginner
You walk away with : KPIs calculated straight from your data.
F7 Pivot Tables Unlock
Cross-analyze and summarize your data in a few clicks.
Analysis · Beginner
You walk away with : A dynamic cross-analysis.
F8 Charts Unlock
Build a readable visual that updates on its own.
Visualization · Dashboards · Beginner
You walk away with : A clear chart that updates.
F9 Conditional Formatting Unlock
Visually surface the values that matter.
Visualization · Dashboards · Beginner
You walk away with : Visual alerts on your values.
F10 Power Query Essentials ★ Unlock
Import and clean your data in a repeatable way.
Data · Automation · AI · Intermediate
You walk away with : A repeatable import-and-transform pipeline.