BusinessThe BestieIntermediate
Excel Formulas at Work, a free business course on Tomo

Excel Formulas at Work

Bridge the gap between raw spreadsheet data and executive-ready reports. Master the core lookup, logic, text, and date formulas companies rely on daily, while building resilient models that resist errors.

Like Duolingo, but for Excel Formulas at Work. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.

25 levels across 3 sections, about 50 minutes end to end, roughly 10 days at five minutes a day. It moves through Tidying and Connecting Disjointed Data, Calculating Business Metrics and Timelines, and Scaling Reports and Preventing Model Failure. It assumes you already know the basics.

25 bite-size levelsAbout 5 minutes each

Free forever · No credit card · iPhone & Android

Fiona the Fox, the guide who teaches the Excel Formulas at Work course
Excel Formulas at Work
with Fiona the Fox
25
Levels
3
Sections
5
Min/day
What you'll learn

Key ideas in Excel Formulas at Work

  • System exports frequently append invisible trailing or leading spaces to text fields
  • Excel lookup functions demand exact character-for-character matches to succeed
  • TRIM strips leading and trailing spaces while keeping single spaces between words
  • Excel math functions like SUM ignore numbers stored as text strings
  • Mathematical operations like multiplying by 1 or double negation (--) force coercion
  • The VALUE function explicitly transforms parseable numeric text into numbers
  • Fixed-length functions like MID fail when ID segment lengths vary across rows
  • TEXTBEFORE pulls characters appearing ahead of a designated delimiter
  • Using a negative instance number in TEXTAFTER searches backward from the end
  • Basic concatenation like A2&", "&B2 creates dangling separators if cells are blank
  • TEXTJOIN takes a delimiter, an ignore_empty boolean, and ranges to combine
  • Passing TRUE to ignore_empty skips blanks entirely without inserting extra delimiters
  • Excel stores dates internally as serial numbers starting from January 1, 1900
  • Concatenating a raw date cell converts it directly into its underlying serial number
  • The TEXT function applies explicit number formatting before string concatenation
  • VLOOKUP relies on a static column index number that does not shift when columns are inserted
Why not just Google it

You've tried the other tabs

Wikipedia

Thirty open tabs. Four facts you actually kept.

YouTube

You watched. You nodded. By Sunday it was gone.

ChatGPT

One answer, then back to scrolling.

Online courses

Eight weeks. You meant to finish. You didn't.

Tomo gives Excel Formulas at Work the Duolingo treatment: levels, streaks, and quick quizzes that test what you just learned. That game loop is what the tabs above never had, so it's the one you actually finish.

Try a question

Here's what playing it feels like

A real question from this course. Take your best guess.

Fixing Messy Raw System Exports

Why does an exact lookup like XLOOKUP fail even when two text values look identical?

Get it right to open this lesson and 24 more in the app.

Course map

Where Excel Formulas at Work takes you

  1. 1

    Tidying and Connecting Disjointed Data

    • Cleaning Raw System Exports
    • Matching Records with Modern Lookups
  2. 2

    Calculating Business Metrics and Timelines

    • Multi-Condition Business Aggregations
    • Tiered Decision Logic and Rules
    • Working-Day Schedules and Period Math
  3. 3

    Scaling Reports and Preventing Model Failure

    • Dynamic Arrays and Spilled Results
    • Structured References in Tables
    • Defensive Auditing and Error Control

3 sections · 8 units · 25 levels. Built to play, not to enroll.

New

Tomo is in ChatGPT

Tomo is also a ChatGPT plugin: the same playable courses, built and played inside your chat.

Add Tomo to ChatGPT
How it's taught

You pick the voice

This course
The Bestie

Excel Formulas at Work is taught in the Bestie style: your friend who just gets it. Want a different feel? In the app you can spin up the same topic in any of Tomo's teaching styles. Same facts, totally different vibe.

Keep going

More Business on Tomo

Excel: Dynamic Formulas and Clean Data course icon

Excel: Dynamic Formulas and Clean Data

Professor

Upgrade from basic cell coordinates to resilient, modern spreadsheet techniques. Learn to build dynamic lookups, multi-criteria summaries, and self-expanding formulas that never break when data changes.

12 levels24mIntermediate
Excel for Business Analysis course icon

Excel for Business Analysis

Professor

Bridge the gap between entering data and driving business decisions. Learn how to clean chaotic exports, automate reporting workflows with modern dynamic functions and Power Query, and build resilient, auditable models for your workplace.

43 levels1h 26mIntermediate
Everyday Excel for Work course icon

Everyday Excel for Work

Bestie

Learn the essential spreadsheet skills that save hours on routine office tasks. Clean messy exports, automate repetitive calculations, and summarize raw records into clear, professional reports.

21 levels42mBeginner
Excel for Accounting course icon

Excel for Accounting

Explain Like I'm 5

Build audit-ready spreadsheets, track cash flow, and automate financial calculations. Learn essential Excel formulas and ledger management tailored for accounting workflows.

24 levels48mBeginner
Real-World Business Management course icon

Real-World Business Management

Professor

Step into management with practical, battle-tested tools to steer work and teams without burning out. Learn to delegate effectively, handle operational bottlenecks, and make sound business trade-offs with imperfect information.

12 levels24mBeginner
Excel for Project Coordinators course icon

Excel for Project Coordinators

Bestie

Learn the essential spreadsheet skills needed to track timelines, control budgets, and deliver clean status reports to stakeholders.

21 levels42mBeginner
Start free

Start Excel Formulas at Work today.

Download Tomo, search Excel Formulas at Work, and play your first lesson in under a minute.