BusinessThe ProfessorIntermediate
Excel for Business Analysis, a free business course on Tomo

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.

43 bite-size levelsAbout 5 minutes each

Free forever · No credit card · iPhone & Android

Excalibur the Eagle, the guide who teaches the Excel for Business Analysis course
Excel for Business Analysis
with Excalibur the Eagle
43
Levels
5
Sections
5
Min/day
What you'll learn

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
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 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.

Try a question

Here's what playing it feels like

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

Why Modern Lookups Stay Reliable

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.

Course map

Where Excel for Business Analysis takes you

  1. 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. 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. 3

    Workbook Defense and Decision Modeling

    • Auditing and Defensive Formula Architecture
    • Controlled Data Input and User Validation
    • Sensitivity Analysis and Scenario Decisions
  4. 4

    Automated Data Ingestion with Power Query

    • Cleaning and Reshaping Data with Power Query
    • Combining Recurring Files and Automated Refresh
  5. 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.

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 Professor

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.

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
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
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
Math for Management Accounting course icon

Math for Management Accounting

Professor

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.

24 levels48mBeginner
CMA USA and Management Accounting course icon

CMA USA and Management Accounting

Professor

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.

24 levels48mBeginner
Start free

Start Excel for Business Analysis today.

Download Tomo, search Excel for Business Analysis, and play your first lesson in under a minute.