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.
Free forever · No credit card · iPhone & Android

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
You've tried the other tabs
Thirty open tabs. Four facts you actually kept.
You watched. You nodded. By Sunday it was gone.
One answer, then back to scrolling.
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.
Here's what playing it feels like
A real question from this course. Take your best guess.
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.
Where Excel Formulas at Work takes you
- 1
Tidying and Connecting Disjointed Data
- Cleaning Raw System Exports
- Matching Records with Modern Lookups
- 2
Calculating Business Metrics and Timelines
- Multi-Condition Business Aggregations
- Tiered Decision Logic and Rules
- Working-Day Schedules and Period Math
- 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.
Tomo is in ChatGPT
Tomo is also a ChatGPT plugin: the same playable courses, built and played inside your chat.
Add Tomo to ChatGPT- What to ask
- “Make me a Tomo course on black holes.” “Turn this chat into a Tomo course.”
- What you get
- Quick questions with instant feedback, hearts and stars, ready to play in about a minute.
- Where it goes
- No sign-up to start. Connect your Tomo account and your streak carries on in the app.
You pick the voice
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.
More Business on Tomo
Excel: Dynamic Formulas and Clean Data
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.
Excel for Business Analysis
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.
Everyday Excel for Work
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.
Excel for Accounting
Build audit-ready spreadsheets, track cash flow, and automate financial calculations. Learn essential Excel formulas and ledger management tailored for accounting workflows.
Real-World Business Management
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.
Excel for Project Coordinators
Learn the essential spreadsheet skills needed to track timelines, control budgets, and deliver clean status reports to stakeholders.
Start Excel Formulas at Work today.
Download Tomo, search Excel Formulas at Work, and play your first lesson in under a minute.