BusinessThe BestieBeginner
Excel for Project Coordinators, a free business course on Tomo

Excel for Project Coordinators

Like Duolingo, but for Excel for Project Coordinators. 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.

21 levels across 3 sections, about 42 minutes end to end, roughly 8 days at five minutes a day. It moves through Building Your First Live Tracker, Automating Statuses and Protecting Data, and Connecting Data and Reporting Out. It starts from scratch.

21 bite-size levelsAbout 5 minutes each

Free forever · No credit card · iPhone & Android

Piper the Penguin, the guide who teaches the Excel for Project Coordinators course
Excel for Project Coordinators
with Piper the Penguin
21
Levels
3
Sections
5
Min/day
What you'll learn

Key ideas in Excel for Project Coordinators

  • In Excel, each row should hold exactly one item or task
  • Each column must represent one specific attribute (like Due Date, Owner, or Status)
  • Stacking multiple items in one cell or splitting single tasks across multiple rows prevents Excel tools from filtering properly
  • Freeze Panes pins specific rows or columns in place while the rest of the sheet scrolls
  • Freezing row 1 prevents losing track of which column is which as lists grow long
  • Excel Tables automatically apply banded row styling and built-in filter drop-downs
  • Formulas and formatting in an Excel Table automatically expand down when you type a new task directly below the last row
  • Double-clicking a column divider auto-fits the column width to the longest cell entry
  • Wrap Text increases row height and breaks text into multiple lines within a fixed column width
  • Auto-fitting is ideal for short labels, while Wrap Text keeps wide note fields readable without stretching the sheet off-screen
  • Holding Ctrl while pressing an Arrow key jumps immediately to the edge of the current contiguous data block in Excel
  • Ctrl+Down Arrow jumps to the last filled cell before an empty cell in that column
  • Starting a cell with '=' tells Excel to treat the entry as a live formula
  • Without an equals sign, Excel treats numbers and math symbols as plain text
  • Formulas dynamically update their result whenever referenced numbers change
  • Full-column references like B:B automatically absorb newly added rows
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 Project Coordinators 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.

Laying Out Your Task Tracker

When setting up columns in your tracker, what should each column represent?

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

Course map

Where Excel for Project Coordinators takes you

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

  1. 1

    Building Your First Live Tracker

    • Setting Up a Clean Project Tracker
    • Budget and Resource Calculations
  2. 2

    Automating Statuses and Protecting Data

    • Tracking Milestones with Dates and Logic
    • Standardizing Inputs and Visual Alerts
  3. 3

    Connecting Data and Reporting Out

    • Linking Project Information Across Sheets
    • Instant Reporting with Pivot Tables
    • Building Executive Status Dashboards

3 sections · 7 units · 21 levels. Built to play, not to enroll.

How it's taught

You pick the voice

This course
The Bestie

Excel for Project Coordinators is taught in the 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.

Start free

Start Excel for Project Coordinators today.

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