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.
Like Duolingo, but for Excel for Business Analysis. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
A deep dive: 43 levels across 5 sections, about 86 minutes end to end, roughly 17 days at five minutes a day. It moves through Fast Fixes and Reliable Lookups, Dynamic Summaries and Visual Auditing, Workbook Defense and Decision Modeling, Automated Data Ingestion with Power Query, and Scalable Spreadsheet Architecture. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android

Key ideas in Excel for Business Analysis
- VLOOKUP uses hardcoded index numbers that pull the wrong column when columns shift.
- XLOOKUP points directly to cell ranges that automatically adjust when columns move.
- Inserting columns breaks VLOOKUP silently instead of throwing an explicit error.
- XLOOKUP defaults to an exact match (mode 0) when its fourth argument is omitted.
- VLOOKUP defaults to approximate match (TRUE), requiring an explicit FALSE for exact hits.
- Omitted match modes in VLOOKUP can silently return the nearest smaller value instead of erroring.
- A nested XLOOKUP can dynamically supply the return array to an outer XLOOKUP.
- The inner XLOOKUP identifies the target column across the matrix headers.
- The outer XLOOKUP resolves the target row and extracts the intersecting cell value.
- Tiered scales using threshold floors require match mode -1 to match the next smaller item.
- Match mode 1 rounds up to the next bracket ceiling, which overpays lower thresholds.
- Approximate lookup modes in Excel allow stepped lookups without hardcoded nested IF statements.
- XLOOKUP includes a built-in [if_not_found] argument that replaces #N/A before it returns.
- Uncaught lookup errors propagate into downstream mathematical formulas like SUM and AVERAGE.
- Returning a fallback value like 0 allows downstream financial totals to calculate uninterrupted.
- Excel treats numbers stored as text as zero inside aggregation formulas like SUM
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 for Business Analysis 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 XLOOKUP stay reliable when someone inserts a column into your table?
Get it right to open this lesson and 42 more in the app.
Where Excel for Business Analysis takes you
- 1
Fast Fixes and Reliable Lookups
- Modern Lookups That Don't Break
- Taming Messy Raw Text and Dates
- Multi-Condition Aggregations for Executive Summaries
- 2
Dynamic Summaries and Visual Auditing
- Pivot Tables for Ad-Hoc Business Analysis
- Dynamic Arrays and Modern Spill Formulas
- Conditional Formatting for Operational Risk
- 3
Workbook Defense and Decision Modeling
- Auditing and Defensive Formula Architecture
- Controlled Data Input and User Validation
- Sensitivity Analysis and Scenario Decisions
- 4
Automated Data Ingestion with Power Query
- Cleaning and Reshaping Data with Power Query
- Combining Recurring Files and Automated Refresh
- 5
Scalable Spreadsheet Architecture
- Structured Tables as the Foundation
- Modular Workbook Architecture and Performance
5 sections · 13 units · 43 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 for Business Analysis is taught in the Professor style: clear, structured, thorough. 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.
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.
Excel for Project Coordinators
Learn the essential spreadsheet skills needed to track timelines, control budgets, and deliver clean status reports to stakeholders.
Math for Management Accounting
Bridge the gap between basic arithmetic and the quantitative tools used in corporate finance and the CMA exam. Learn to calculate margins, evaluate cost behaviors, analyze project investments, and quantify business risk to make confident financial decisions.
CMA USA and Management Accounting
Explore the core competencies of the US Certified Management Accountant credential, from cost behavior and operational budgeting to capital decisions and risk management. Learn how management accountants steer internal business strategy, evaluate performance, and uphold professional standards.
Start Excel for Business Analysis today.
Download Tomo, search Excel for Business Analysis, and play your first lesson in under a minute.