Issue 05 · XLSim

Prove they can
do it in Excel.

Set an Excel exercise. Trainees download the starter workbook, complete it in Excel, and upload it back. Mltitude grades against the rubric you set — cells, formulas, sheet shape, formatting — and writes the trainee personalised feedback. No backlog. No grading.

· Real Excel· Auto-graded· Per-check feedback· No grading backlog· Audit-friendly
manager_bonus_q2.xlsx
·EmployeeSalesBonus
1EmployeeSalesBonus
2Alice75,0007,500
3Bob42,0000
4Carol90,0009,000
5Dan56,0005,600
Sheet1submitted · 11:42 AM
92 / 100Passed
Per-check feedback
  • Bonus formula uses IF — correct shape.
  • Alice 7,500 — passes threshold rule.
  • D3 should be 5,600. You entered 5,500.
  • Columns A:D formatted as currency.
Section I · A graded submission

The score is the easy part.
The feedback is the point.

Every submission gets a score and a list of per-check results — what passed, what didn't, and a short narrative for the trainee. Trainers see the same view at the cohort level: who's done, who's stuck, what they're getting wrong.

Run a sample on your own brief
Submission · Sales Bonus Eligibility
Carol Owens · attempt 1
Passed
92 / 100
Feedback

Solid work, Carol. Your IF formula correctly distinguishes who hits the bonus threshold, and your currency formatting is on the money. The one cell that didn't land is D3 — small rounding error in Bob's bonus calculation. Re-check the multiplier (it should be 0.1, not 0.105). The shape of your solution is right; the precision is one tweak away.

Per-check results · 7 of 8 passed
  • A1 = 'Employee'
    Header column 1 matches.
    5 / 5
    pts
  • A2:A5 contain four employees
    Alice, Bob, Carol, Dan all present.
    10 / 10
    pts
  • C2 uses an IF function
    Correct conditional logic shape.
    20 / 20
    pts
  • C2 = 7,500 (Alice bonus)
    Threshold rule applied.
    15 / 15
    pts
  • C3 = 5,600 (Bob bonus)
    Got 5,500. Re-check the multiplier (0.1, not 0.105).
    7 / 15
    pts
  • C4 = 9,000 (Carol bonus)
    Threshold rule applied.
    15 / 15
    pts
  • C5 = 5,600 (Dan bonus)
    Threshold rule applied.
    10 / 10
    pts
  • Columns A:D formatted as currency
    All cells use the correct format.
    10 / 10
    pts
Section II · Why this exists

"They completed the training" isn't a measure.

Excel is the second job description in finance, operations, analytics, sales-ops, FP&A — anywhere a spreadsheet is real work. L&D teams run training on it constantly. Most of the "did they learn it" measurement is still self-report and a multiple-choice quiz.

The usual measurement
Did they finish the module?
  • LMS marks the module complete. We assume they watched it.
  • Multiple choice at the end. Four options. They pass.
  • Manager asks the team six weeks later — "Are you using it?"
  • Three trainees actually changed their workflow. The others didn't.
  • Next quarter we run the same training.
With XLSim
Can they actually do it?
  • Trainee downloads the workbook. Real Excel, real data.
  • They complete the task. We grade against the rubric.
  • Per-check feedback tells them what to fix and why.
  • Trainer sees the cohort: who's stuck on what, who's done.
  • Mastery — not seat-time — becomes the measurement.
Section III · Where it earns its keep

The programmes that need proof.

Anywhere a spreadsheet does real work, "they completed the training" stops being enough. These are the four programmes XLSim earns its seat on.

Finance onboarding

From the model to the muscle memory.

Internal models, recons, reporting workflows. The new joiner doesn't just read about VLOOKUP — they prove they can do it on data that looks like the data they'll see on Monday.

Operations analysts

Pivots, lookups, and SUMIFS — verified.

The skills you'd want before someone touches the live dashboard. Demonstrated against a workbook, not promised in a self-rating.

Sales-ops upskilling

CRM export → pipeline analysis.

Show the work, not just the click-through. The output is a workbook that does what it claims to do, graded automatically and returned with feedback.

Compliance training

The test they passed, not the deck they watched.

Documented competency for the audit, not 'they were marked complete'. XLSim records the attempt, the score, and the per-check trail — exportable when finance auditors come asking.

Section IV · Anatomy

How an assessment
actually runs.

Two roles. One workflow. The trainer authors and assigns; the trainee attempts and receives feedback. The engine handles the grading and writes the narrative. No spreadsheet inspection, no marking up a workbook by hand.

I.
Trainer authors

Pick from the seeded library (Fundamentals, Intermediate, Advanced) or generate a new assignment from a brief. Edit the rubric. Set the passing score.

II.
Assign

Pick the trainees — one, a cohort, the whole programme. Idempotent, so you can re-assign without duplicating.

III.
Trainee attempts

They see only what's assigned. Download the starter, complete in Excel, upload the .xlsx. No XLSim-specific app — they use the tool they already know.

IV.
Auto-grade

The engine runs the rubric against the workbook — cells, formulas, ranges, sheets, formatting. Each check returns pass/fail with detail.

V.
Feedback

A short narrative explains what passed and what to revise. Trainer sees the cohort view: scores, attempts, who's stuck where.

Six check types · composable into any rubric
Cell value

A specific cell must equal a specific value.

D6 = 74000
Cell formula

A cell must use a specific formula shape.

B7 = SUM(B2:B6)
Required functions

The formula must contain certain function names.

C2 must contain IF
Range values

An entire range must contain the right sequence.

B2:B12 = [Jan, Feb, …]
Sheet exists

A specific sheet (by name) must be present.

A 'Pivot' sheet exists
Formatting

Cells must use a specific format — currency, bold, fill, font size.

D2:D12 = currency

Composable. Build a rubric of any size by mixing check types. Grading is deterministic — a model writes the per-check narrative, but the score itself is calculated, not opinion.

Section V · Asked & answered

The questions L&D leads ask.

Procurement, security, and audit teams ask their own questions too. Those live in the trust center.

  • Is the grading actually accurate?

    Yes — and it's deterministic. The engine runs each rubric check against the workbook (e.g. "D6 must equal 74000", "C2's formula must contain IF"). No model is making the pass/fail call. Where a model is involved is the per-check narrative; the trainer can override any score.

  • Do trainees need to install anything?

    No. They open the assigned assignment in their browser, download the starter .xlsx, complete it in whatever Excel they already have (desktop, online, LibreOffice — anything that produces a valid .xlsx), and upload it back. We meet them in the tool they already know.

  • How do we author the rubric — is it technical?

    Two ways. (i) Pick from the seeded library — Excel Fundamentals, Intermediate, Advanced — and assign as-is. (ii) Generate a new assignment from a brief: describe the exercise in plain English and the system writes the title, instructions, rubric, and starter workbook. Either way, you can edit the rubric before publishing.

  • Can trainees re-attempt?

    Yes, by default. You can also cap attempts per assignment. Every attempt is stored separately with its score, evaluated_at timestamp, and per-check trail — useful for the audit conversation later.

  • Will it work for our internal Excel templates?

    Yes. The starter workbook can be your internal template (we host it; trainees download it). The rubric checks the parts that matter for the exercise — typically not the whole template, just the cells the trainee was supposed to fill.

  • What gets logged for audit?

    Every submission — file, attempt number, score, max score, pass/fail, evaluated_at, per-check results, and the rubric used. Org admins can export the workspace audit log as CSV. See /trust for the full posture.

Section VI · One last thing

Run one assessment.
Watch a cohort.

Pick a real Excel skill you're training this quarter. Assign it to one cohort with XLSim. Watch what happens when "did they learn it" stops being a self-report. Then decide whether you'd run every Excel programme this way.

Talk to L&D sales