Spreadsheets in Practice: Real-World Data
Like Duolingo, but for Spreadsheets in Practice: Real-World Data. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
For the part of you with thirty open tabs that never became anything.
24 levels across 4 sections, about 48 minutes end to end, roughly 10 days at five minutes a day. It moves through Reshaping and Slicing Raw Records, Reconciling and Joining Split Datasets, Cleaning and Defending Messy Inputs, and Actionable Summaries and Analytical Models. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android
Key ideas in Spreadsheets in Practice: Real-World Data
- SUMIFS evaluates multiple column ranges simultaneously using an implicit AND condition.
- Unlike legacy SUMIF, SUMIFS places the sum_range argument first, followed by pairs of criteria.
- Native multi-criteria formulas eliminate the need to concatenate lookup keys in auxiliary columns.
- Comparison operators in criteria arguments must be enclosed in quotes as text strings.
- The ampersand (&) operator links the logical operator string to a live cell reference or DATE function.
- Failing to concatenate leaves cell references trapped as literal text that fails matching.
- The asterisk (*) acts as a wildcard representing any sequence of zero or more characters.
- The question mark (?) represents exactly one single variable character in criteria arguments.
- Wildcard patterns allow conditional aggregation across inconsistent naming conventions without cleaning.
- Referencing a cell holding filter criteria makes a summary dashboard update without formula edits.
- Hardcoding criteria text directly into formulas requires tedious manual finds-and-replaces across sheets.
- Dynamic criteria cells enable standard formulas to be dragged down summary tables cleanly.
- SUMIFS automatically ignores text entries in the sum range rather than raising a #VALUE! error.
- Imported numeric values formatted or stored as text strings are silently treated as zeroes by SUMIFS.
- Using VALUE or text-to-columns restores the numeric type needed for conditional aggregations to sum.
- FILTER writes calculated outputs elsewhere leaving the source table completely untouched
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 Spreadsheets in Practice: Real-World Data 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.
Where does the sum_range column go when you write a SUMIFS formula?
Get it right to open this lesson and 23 more in the app.
Where Spreadsheets in Practice: Real-World Data takes you
Bridge the gap between basic cell entry and functional data management. Learn to clean messy inputs, reconcile records, and build reliable models for school administration and financial tracking.
- 1
Reshaping and Slicing Raw Records
- Targeted Aggregation with Multi-Condition Math
- Dynamic Filtering and Sorting with Formula Arrays
- 2
Reconciling and Joining Split Datasets
- Modern Lookups Across School and Ledger Tables
- Table Merging and Transaction Reconciliation
- 3
Cleaning and Defending Messy Inputs
- Normalizing Inconsistent Real-World Text and Dates
- Error-Proofing and Input Governance
- 4
Actionable Summaries and Analytical Models
- Multi-Dimensional Pivot Table Analysis
- Variance, Cohort, and Financial Modeling
4 sections · 8 units · 24 levels. Built to play, not to enroll.
You pick the voice
Spreadsheets in Practice: Real-World Data is taught in the Explain Like I'm 5 style: no big words. promise.. 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 Technology on Tomo
Everyday Excel
Stop doing repetitive manual data entry and let the spreadsheet work for you. Learn the essential formulas, cleanup tricks, and summary tools to turn messy numbers into clear answers fast.
Talking to Databases with SQL
Learn how to store, find, and organize information using SQL. This course takes you from your very first query to joining complex tables like a pro.
Mastering the Magic of Spreadsheets
Stop fighting with rows and columns and start making them work for you. Learn to organize your life, automate your math, and turn messy data into clear answers in minutes.
Mastering Maps with QGIS
Stop just looking at maps and start building them. Learn to track weather patterns, analyze local changes, and solve real-world problems using the world's most powerful free mapping tool.
Applied Data Science: From Raw Data to Real Impact
Move beyond the basics of clean datasets and learn how to solve messy, high-stakes problems in production environments. Master the art of feature engineering, model monitoring, and translating technical metrics into business value.
Python: Building Real-World Tools
Move beyond basic syntax to build functional applications. Learn to automate your life, manage complex data, and create software that people actually use.
Start Spreadsheets in Practice: Real-World Data today.
Download Tomo, search Spreadsheets in Practice: Real-World Data, and play your first lesson in under a minute.