Real-world projects
Build files you'll reuse: a budget, an invoice, a timesheet, trackers, a dashboard and more.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 14 min
Build a monthly budget
Build a budget that totals your spending by category, shows what's left of each plan and turns red when a category goes over.
See the lessonIn the full course. Confident · 14 min
Invoice template
Build an invoice that looks up each price from a price list and works out line totals, a discount, sales tax and the amount due.
See the lessonIn the full course. Confident · 12 min
Timesheet with overtime
Turn start and end times into hours worked, total the week, split out overtime above 40 hours and work out the gross pay.
See the lessonIn the full course. Confident · 14 min
Inventory tracker with low-stock alerts
Track stock on hand, flag every item at or below its reorder point in red, count them and work out how much to order.
See the lessonIn the full course. Confident · 13 min
Expense report
Build an expense report with a category dropdown, totals per category that add up, and a flag on every expense over the policy limit.
See the lessonIn the full course. Confident · 14 min
Project tracker with status and due dates
Build a project tracker with a status dropdown, red overdue dates that clear when a task is done, and counts by status and owner.
See the lessonIn the full course. Confident · 13 min
Gradebook
Build a gradebook that averages each student's scores, turns the average into a letter grade and counts how many students got each letter.
See the lessonIn the full course. Confident · 10 min
Savings goal planner
Work out how much to save each month to reach a goal by a date, with and without interest.
See the lessonIn the full course. Confident · 13 min
Weekly shift roster
Build a weekly roster with shift dropdowns from a list, count each person's opening, mid and closing shifts with one formula, and total their hours.
See the lessonIn the full course. Confident · 13 min
Event budget and guest list
Count RSVPs and the people they bring, total an event's spending by category and turn any category that goes over budget red.
See the lessonIn the full course. Confident · 13 min
Price comparison sheet
Compare three suppliers' prices row by row, show the lowest price and who offers it, and highlight the cheapest quote automatically.
See the lessonIn the full course. Confident · 12 min
Attendance tracker
Build an attendance sheet with P and A dropdowns, count each person's attendance, work out their attendance % and flag anyone below 80%.
See the lessonIn the full course. Advanced · 15 min
Sales dashboard
Build a one-page sales dashboard with headline numbers for any month, a monthly trend chart and a product breakdown, all fed by the order list.
See the lessonIn the full course. Advanced · 15 min
Loan repayment calculator
Build a loan calculator with an amortization table that splits every payment into interest and principal, tracks the balance and totals the interest by year.
See the lessonIn the full course. Advanced · 14 min
Shopify orders analysis
Turn an exported list of online store orders into real dates, a product-by-month pivot table and SUMIFS totals by sales channel.
See the lessonIn the full course. Advanced · 14 min
Employee directory with lookups
Build a staff lookup card that shows every detail for an employee ID with one copied formula, and says "Not found" for an unknown ID.
See the lessonIn the full course. Advanced · 12 min
Commission calculator
Build a sales commission calculator that totals each rep's orders, looks up a tiered rate, adds a bonus and shows the total pay.
See the lessonIn the full course. Advanced · 14 min
Break-even analysis
Build a break-even table from fixed costs, price and variable cost, chart revenue against total cost, and work out the break-even volume.
See the lessonIn the full course. Advanced · 14 min
KPI scorecard
Build a monthly KPI scorecard that totals actuals with SUMIFS, shows the percent of target and colors each row green, yellow or red.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Google Sheets for small business
For quotes, stock and money kept in a spreadsheet.
12 lessons · about 2 h 15 min · 3 free · Confident
See the pathTeam trackers in Google Sheets
For tracking tasks, requests or projects in a shared sheet.
10 lessons · about 1 h 40 min · 1 free · Beginner to Confident
See the pathGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.