Master Excel & Google Sheets Formulas
Spreadsheets run the world's offices — and the people who can write formulas get the work done in seconds while everyone else does it by hand. This track takes you from your very first cell reference all the way to dynamic arrays, LAMBDA, and live dashboards, using plain language and real examples. Everything works in both Microsoft Excel and Google Sheets, so the skills follow you anywhere.
What You Will Learn
You will start with how a spreadsheet is laid out and how to write your first formula, then master the everyday workhorses — SUM, AVERAGE, COUNT, IF, and absolute versus relative references. From there you move into text and date functions, conditional math with SUMIF and COUNTIF, and the lookup family that powers real reports: VLOOKUP, HLOOKUP, the modern XLOOKUP, and INDEX-MATCH. Advanced courses cover dynamic arrays and spilling, LET and LAMBDA, financial and statistical functions, Google Sheets QUERY, cleaning data with regular expressions, and assembling everything into formula-driven dashboards.
The Learning Path
Thirty courses progress from A1 through B2. You begin with Spreadsheet Foundations and Writing Your First Formulas, build through the essentials with The SUM and AVERAGE Functions, Absolute and Relative References, and Working With Text Functions, then reach the report-building core in Lookups With VLOOKUP and HLOOKUP, Modern Lookups With XLOOKUP, and INDEX and MATCH Together. The track advances into Dynamic Arrays and Spilling, LET and LAMBDA Functions, and Google Sheets QUERY and ARRAYFORMULA, and finishes by Building Dashboards With Formulas.
How It Works
Each course is broken into short, focused lessons with clear examples and quick quizzes to lock in what you learn. Every formula is shown step by step in plain English — no prior experience needed — and an AI tutor is on hand whenever you get stuck. Learn a little each day and you will become the person in the room who actually knows the formula.