Excelligence · Lab Layer

FormulaLab

Real data. One formula. No macros.

Here’s the scenario. Here’s the dataset. Produce the target. We never name the formula — you figure out the pattern from the problem.

· /formulalab/ · Excelligence
How It Works

Guided Intro

Three steps. Same problem. Watch the pattern emerge.

Spreadsheet
Sheet 2 — Reference Table
EmployeeID
Department
1001
Mathematics
1007
Athletics
FRM-0001 · XLOOKUP
Press Next to begin the guided intro.

The Challenge Index

Challenges

Real scenarios. Registry-grounded. No formula named until you solve it.

#001 · The Overlapping Shifts
Intermediate FRM
LIVE

Pinecrest Urgent Care runs three overlapping shifts. The clinic manager needs to know: for each hour of each day, how many nurses are on the floor? The scheduling system exports start/end times but doesn’t calculate coverage.

Solve Challenge →

/learn/
Decomposition
Understand what each formula does and why, step by step.
/lab/
Application
Real scenarios. Figure out the pattern from the problem.
/play/
Competition
Formula scoring game. The registry is the rulebook.

Three ways in. One registry.