Phase 3 · Intelligence & enterprise
From learning platform to Excel talent system.
Get context-aware coaching, inspect real workbooks, prove skills through evidence, build a shareable portfolio, and coordinate team learning from one connected platform.
Certification readiness0%Building verified evidence
Context-aware Excel CoachGuidance based on your current formula, evidence, and pathway.
Workbook InspectorUpload and grade formula quality, risks, and robustness locally.
Industry Project LibraryRealistic practice across manufacturing, quality, finance, and more.
Verified CertificationTimed assessment plus mastery, mission, and project evidence.
Shareable PortfolioExport a portable evidence-rich portfolio as standalone HTML.
Team Training ManagementTeams, assignments, deadlines, skills gaps, and reporting.
Context-aware coaching
A coach that understands where you are.
The coach reads the active learner’s pathway, mastery evidence, current challenge, review queue, project work, and latest workbook audit. It uses progressive hints so learners think before seeing a solution.
Private learner context
Your live coaching context
The built-in coach works offline. A secure organization endpoint can optionally replace the local reasoning adapter without exposing an API key in the lesson file.
How coaching works
Coach: I will first identify what Excel is trying to calculate, then isolate the smallest failing expression. I will not reveal the final formula unless you explicitly request it.
Automated workbook inspection & grading
Turn any workbook into actionable feedback.
Upload an Excel or CSV file to inventory sheets and formulas, detect formula errors and risky patterns, compare work against a rubric, and produce an audit report.
Workbook Quality Inspector
Formula-aware analysis · rubric grading · no server uploadDrop a workbook here
or choose a file from this device. The workbook remains in your browser.
Workbook quality0—
Priority findings
0 findingsPrivacy: analysis runs locally in this page. Formula results are read from the workbook’s stored values; the inspector does not recalculate Excel formulas or upload the file.
Industry-specific application
Practise Excel in the language of real work.
Choose projects by industry, level, and skill. Each brief includes realistic deliverables, a sample dataset, a verification rubric, and portfolio evidence.
Industry Project Library
18 applied projectsEvidence-verified certification
Prove you can build—not merely recognize answers.
The Excel Formula Professional credential combines a timed assessment with mastery, hidden-test missions, and completed project evidence. The certificate includes a locally verifiable credential ID.
Excel Formula Professional
UpSkillSprint evidence-verified credential · 85% standardReadiness0%0 of 4 requirements
Shareable workbook portfolio
Turn completed work into career evidence.
Select what to show, add external workbook links, preview the public-facing result, and export a standalone portfolio page that can be shared or published anywhere.
Portfolio Studio
Privacy controls · evidence summary · portable HTML exportVisible evidence
Public preview
Team & corporate training
Manage skills development across a workforce.
Create teams, assign pathways with deadlines, map local learners or imported roster members, monitor skills gaps, and export training evidence.
Organization Learning Center
Cohorts · assignments · competency reporting · LMS-ready exportTeams
0 teamsLearning assignments
Phase 2 · Personalized learning system
Your Excel learning command center.
A single evidence model now connects practice, recommendations, pathways, projects, credentials, and cohort reporting. Your work is saved to the active learner profile.
Adaptive learning hub
Welcome back
Complete the diagnostic or one live mission to generate a personalized route.
Evidence-based mastery0%0 assessed skills
—
Take the diagnostic
We need a little evidence before selecting your highest-value skill.
Excel FoundationsBuild a reliable formula core.
0% pathway readiness
Progress is protected in this browser. Configure a sync endpoint from your profile for cloud portability.
Skills graph · prerequisite-aware
See what unlocks what.
Recommendations prioritize the weakest unlocked skill. If an advanced skill depends on a weak foundation, the engine routes you to the prerequisite first.
Excel competency graph
Gathering evidence…ProficientRecommendedPrerequisite locked
Role-based pathways
Learn toward work you want to perform.
Each pathway combines prerequisite skills, focused practice, and a portfolio project. Enrolling changes recommendations—it never hides the rest of the course.
Choose a pathway
Five routes from first formula to advanced automationPortfolio projects
Prove proficiency with realistic deliverables.
Projects move beyond one-formula answers. Use the rubric to document design, validation, and communication quality, then add the finished work to your local portfolio.
Applied project studio
0 of 6 projects completedVerified milestones
Credentials backed by evidence.
Badges are awarded automatically from diagnostic, practice, hidden-test, and mastery evidence. Completion alone cannot unlock a proficiency badge.
Badge cabinet
0 badges earnedInstructor workspace
Turn learner evidence into useful intervention.
This device-level cohort view aggregates every local profile without fabricating data. A configured sync endpoint can replace the local adapter with an organization-wide cohort service.
Cohort pulse
Local profiles · live mastery evidence · review riskSkill heatmap
Orientation
Excel is a language, not a list of functions.
A strong Excel user does not memorize hundreds of isolated formulas. They understand references, arrays, criteria, calculation order, and how functions pass results to one another. That mental model lets them build unfamiliar solutions confidently.
Beginner: ReadInterpret formula symbols, references, operators, errors, and calculation order.
Intermediate: ComposeFilter, aggregate, look up, clean, and summarize data with dynamic formulas.
Advanced: EngineerDesign reusable, auditable formulas with LET, LAMBDA, array helpers, and formula-based summaries.
Learning outcomes
Decode
Explain what each symbol is doing and predict how a formula changes when copied.
Build
Create dynamic outputs using Tables, spill ranges, FILTER, SORT, UNIQUE, TAKE, and INDEX.
Design
Combine advanced functions while handling missing data, version compatibility, and workbook performance.
The core ideaEvery Excel formula is a pipeline: take inputs → transform them → return a result. Advanced formulas are simply longer, better-structured pipelines.
Module 1 · Beginner
Learn the grammar of a formula.
Symbols tell Excel where to look, what to calculate, and how to interpret the result. Click each part of the formula below to see its job.
(
,
,
,
,
(values))
Select a formula component to inspect it.
References: what moves and what stays fixed
| Reference | Column when copied | Row when copied | Typical use |
|---|---|---|---|
A2 | Changes | Changes | Row-by-row calculations |
$A2 | Locked | Changes | Always use one input column |
A$2 | Changes | Locked | Always use one header/assumption row |
$A$2 | Locked | Locked | Fixed threshold, tax rate, target, or selector |
Interactive lab
F4 cycles lock statesCopy-reference simulator
Enter a reference and simulate copying its formula. Positive row/column moves copy down/right; negative moves copy up/left.
B2 → C4
High-value symbols
| Symbol | Meaning | Example | Interpretation |
|---|---|---|---|
: | Continuous range | A2:A100 | Every cell from A2 through A100 |
! | Sheet separator | 'Production Data'!A2 | A2 on another worksheet |
[ ] | Structured Table reference | ProductionData[Tap Time] | The complete Tap Time column |
@ | Current Table row | [@Tonnes]*[@Rate] | Use values from this row |
# | Spilled result | D2# | The entire dynamic array beginning at D2 |
& | Join text / build criteria | ">="&M2 | Combine an operator with a cell value |
" " | Text literal | IF(A2="PASS",...) | PASS is text, not a name |
* | Multiply; array AND; wildcard in criteria | (A=A1)*(B=B1) | Both tests must be TRUE |
+ | Add; array OR | (Status="FAIL")+(Status="HOLD") | Either test may be TRUE |
<> | Not equal to | A2<>"" | A2 is not empty |
Context changes meaning.
* is multiplication in =A2*B2, logical AND in array tests, and “any characters” inside a criterion such as "*Steel*". Read the context before interpreting the symbol.Module 2 · Beginner → Intermediate
Make ranges respond to the data.
A dynamic range expands, contracts, or changes membership as records or user selections change. The strongest modern pattern is: put raw data in an Excel Table, transform it with dynamic-array functions, and refer to spilled outputs with #.
1. StoreExcel Table
2. SelectFILTER / CHOOSECOLS
3. ShapeSORT / UNIQUE / TAKE
4. AnalyzeMEDIAN / SUM / chart
Excel Tables: default choice
=AVERAGE(ProductionData[Tap Time])Tables expand automatically, copy calculated-column formulas, preserve headers, and make formulas readable. Press Ctrl + T, then rename the table under Table Design → Table Name.
Spill ranges: changing outputs
D2: =SORT(UNIQUE(ProductionData[Facility])) Any cell: =COUNTA(D2#)The anchor formula occupies D2; its results spill below. D2# always refers to the complete output. A blocked destination causes #SPILL!.
INDEX: dynamic ending point
=A2:INDEX(A2:A10000,XMATCH(2,1/(A2:A10000<>"")))This builds a reference from A2 to the last nonblank value. Prefer bounded ranges for performance. If blanks inside the data have meaning, design the last-row test around a reliably populated key column.
Volatile methods: use intentionally
=OFFSET(A2,0,0,COUNTA(A2:A10000),1) =SUM(INDIRECT("'"&F1&"'!B2:B100"))OFFSET and INDIRECT recalculate frequently. INDIRECT also turns text into references, is harder to audit, and cannot read a closed external workbook. Tables or INDEX are usually safer.
Interactive lab
AND logic with *Dynamic FILTER builder
Change the selectors and watch both the formula and spilled result update.
| Date | Facility | Heat ID | Week | Tap Time | Status |
|---|
Choose the right dynamic method
| Need | Best starting method | Why |
|---|---|---|
| New rows should be included | Excel Table | Native expansion and readable structured references |
| Return matching records | FILTER | Produces a live changing array |
| Unique, sorted selection list | SORT(UNIQUE(...)) | Ideal for data validation and dashboard selectors |
| Last N nonblank values | TAKE(FILTER(...),-N) | Clear modern formula |
| Dynamic chart source | Table or named spill range | Charts update without oversized ranges |
| Older Excel version | INDEX-based named range | Nonvolatile and widely compatible |
| Reference sheet named in a cell | INDIRECT, cautiously | Text-to-reference is its genuine use case |
Module 3 · Intermediate
Build analytical formulas from reusable patterns.
Most analytical work reduces to five patterns: retrieve, filter, aggregate, reshape, and clean. Master the pattern, then change the ranges and criteria.
Retrieve
=XLOOKUP(M2,ProductionData[Heat ID],ProductionData[Tap Time],"Not found")Use exact matching by default. Set search mode to -1 to retrieve the last occurrence.
Filter + aggregate
=MEDIAN(FILTER(ProductionData[Tap Time],ProductionData[WeekNum]=M2))FILTER creates the relevant population; MEDIAN summarizes it.
Conditional aggregate
=SUMIFS(ProductionData[Tonnes],ProductionData[Facility],M2,ProductionData[Date],">="&M3)Use & to combine comparison operators with cell values.
Multiple criteria: multiplication and addition
=XLOOKUP(1, (ProductionData[Heat ID]=M2)*(ProductionData[Test Type]=M3), ProductionData[Result], "Not found" )Each comparison creates TRUE/FALSE values. Multiplication coerces them to 1/0 and leaves a 1 only where both are true. Addition works as OR, but two true tests can produce 2—design the lookup value accordingly.
Weighted average: let the exposure matter
=SUMPRODUCT(ProductionData[Tap Time],ProductionData[Tonnes]) / SUM(ProductionData[Tonnes])A simple mean gives every row equal influence. A tonnes-weighted mean gives larger production runs more influence. Decide which definition matches the question before writing the formula.
Text and date patterns
| Task | Formula pattern |
|---|---|
| Text before a delimiter | =TEXTBEFORE(A2,"-") |
| Text after a delimiter | =TEXTAFTER(A2,"-") |
| Split into columns | =TEXTSPLIT(A2,"-") |
| Clean imported text | =TRIM(CLEAN(A2)) |
| First day of current month | =EOMONTH(TODAY(),-1)+1 |
| Monday of current week | =TODAY()-WEEKDAY(TODAY(),2)+1 |
| Current-month records | =FILTER(Data,(Dates>=EOMONTH(TODAY(),-1)+1)*(Dates<=EOMONTH(TODAY(),0))) |
Avoid whole-column array calculations.
A:A is convenient, but formulas such as FILTER, SUMPRODUCT, and array-based lookups may evaluate more than a million cells. Use Tables or sensible bounded ranges.Module 4 · Advanced
Treat a formula like a small program.
Modern Excel can name variables, define reusable functions, iterate over arrays, and accumulate results. The goal is not complexity—it is to make complex logic easier to read and reuse.
LET: name the logic
=LET( values, ProductionData[Tap Time], weeks, ProductionData[WeekNum], selectedWeek, $M$2, matching, FILTER(values,(values<>"")*(weeks=selectedWeek),""), IF(COUNT(matching)=0,"No records",MEDIAN(matching)) )Read it top to bottom: define the data, define the selector, build the matching subset, and return the final result. Repeated expressions are calculated once and named meaningfully.
LAMBDA
=LAMBDA(YS,UTS,IFERROR(YS/UTS,""))Save it in Name Manager as YT_RATIO, then call =YT_RATIO(B2,C2).
MAP
=MAP(B2:B100,C2:C100,LAMBDA(YS,UTS,IFERROR(YS/UTS,"")))Apply one calculation to corresponding values in multiple arrays.
BYROW / BYCOL
=BYROW(B2:F10,LAMBDA(r,AVERAGE(r)))Calculate one result for each row or column without copying formulas.
SCAN
=SCAN(0,B2:B100,LAMBDA(total,x,total+x))Return every intermediate value—ideal for running totals and balances.
REDUCE
=REDUCE(0,B2:B100,LAMBDA(total,x,total+(x>100)))Process the array but return only the final accumulated result.
GROUPBY / PIVOTBY
=GROUPBY(ProductionData[Facility],ProductionData[Delay Time],AVERAGE)Create live formula-based summaries. Availability depends on Microsoft 365 update channel.
Function availability
| Generation | Functions | Practical guidance |
|---|---|---|
| Broad compatibility | IF, SUMIFS, COUNTIFS, INDEX, MATCH, SUMPRODUCT | Use when files must work in older Excel installations. |
| Modern dynamic arrays | XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE | Microsoft 365 and newer Excel; outputs spill automatically. |
| Modern composition | LET, LAMBDA, MAP, BYROW, BYCOL, SCAN, REDUCE | Excellent for reusable logic; confirm recipient compatibility. |
| Newest formula summaries | GROUPBY, PIVOTBY, TRIMRANGE | May require a current Microsoft 365 channel; provide a PivotTable or legacy fallback when sharing widely. |
Module 5 · Advanced practice
Design formulas other people can trust.
A correct result is not enough. A professional workbook must be updateable, traceable, performant, and safe around missing or invalid data.
Separate roles
Keep raw data, assumptions, calculations, and presentation in clearly labelled areas or sheets.
Name meaning
Use Tables and LET variables such as selectedWeek, not unexplained cell coordinates repeated six times.
Handle edges
Check blanks, zero denominators, no-match states, and invalid inputs before calculating.
Formula quality checklist
- The business question and unit of analysis are clear.
- Inputs and thresholds live in visible cells—not buried as magic numbers.
- Absolute, mixed, and relative references behave correctly when copied.
- Source and criteria arrays have matching dimensions.
- No whole-column array formulas unnecessarily scan 1,048,576 rows.
- Missing data, no matches, and divide-by-zero cases return useful messages.
- A peer can read the formula without reverse engineering it.
- The functions are compatible with the intended users’ Excel versions.
Debug from the inside out.Test the Boolean criteria first, then the FILTER or lookup, then the aggregation, and finally the IF/IFERROR wrapper. Excel’s Formulas → Evaluate Formula command helps you inspect each stage.
Adaptive starting point
Begin at the level you actually need.
The diagnostic samples formula reading, reference behaviour, analysis, dynamic ranges, and debugging. Your results seed the mastery model and recommend a starting path; they do not reduce your course score.
Excel Skills Diagnostic
10 questions · approximately 7 minutes · personalized recommendation
Find your strongest starting point
You will interpret formulas, predict copied references, choose appropriate functions, and diagnose common errors. Complete it without searching for answers so the recommendation is useful.
10targeted questions across eight Excel skills
Your recommended entry point
Real spreadsheet practice
Build formulas in a live calculation grid.
Select cells, edit source values, enter a formula, and calculate the result. When you submit, the same formula is tested against four unseen datasets—so a hardcoded answer cannot earn mastery.
Live Workbook Lab
Editable cells · actual formula calculation · visible result · four hidden robustness tests
The live lab supports the formula families used by these missions. The companion `.xlsx` workbook remains the full-fidelity environment for modern functions such as LET, LAMBDA, and spilled arrays.
Module 6 · Deliberate practice
Formula Practice Engine
Work through 50 focused syntax and composition challenges. Use the Live Workbook Lab for result-based validation of alternative formulas; this challenge bank develops fluency with the intended Excel pattern and feeds your skill mastery and review schedule.
Worked solution
Two complementary practice modesThe Formula Lab develops syntax and composition against the intended pattern. The Live Workbook Lab calculates formulas and verifies their results across unseen datasets. Use the companion workbook for full Excel fidelity, spill behaviour, and advanced functions.
Adaptive mastery and retention
Know what you can do—not merely what you completed.
Mastery combines diagnostic evidence, practice accuracy, live-lab performance, hint use, and solution reveals. Incorrect or revealed challenges enter a spaced review queue automatically.
My Excel Mastery
Eight skills · evidence-based scores · personalized review queue
0%overall mastery
Due for review
Your spaced practice queue
Due now0
Wrong answers and revealed solutions return immediately. Successful reviews are scheduled at increasingly longer intervals.
Capstone
Build a weekly process-performance panel.
Use the downloadable workbook’s Production Data to create a selector-driven summary for a chosen facility and week.
Dynamic subset
Return matching rows with FILTER using facility and week as criteria.
Process metrics
Calculate median tap time, 90th percentile delay, total tonnes, and fail/hold rate.
Reusable design
Use LET to name inputs and filtered arrays; handle the no-record state cleanly.
Proficiency rubric
0–49%Foundation forming
Review symbols and references.
Review symbols and references.
50–69%Developing
Repeat guided dynamic-range practice.
Repeat guided dynamic-range practice.
70–84%Proficient
Ready for independent analytical formulas.
Ready for independent analytical formulas.
85–100%Advanced
Ready to engineer reusable workbook models.
Ready to engineer reusable workbook models.
Mastery standardReach at least 85% without revealing solutions, then complete the capstone from a blank worksheet. Finally, explain your formula aloud—if you can explain every reference and function, you own the skill.