Google Sheets for Business
Tidy shared tables, SUMIFS reports, lookups, validation, conditional formatting and a team tracker: 8 hands-on labs with Excel-compatible formulas that work the same in Google Sheets.
The first 2 lessons are free — no account needed.
About this course
A Google Sheets for business course built on one coffee roaster's shared sheets, for teams that keep their numbers in Google Sheets. You turn an order log into a tidy table the whole team can share, with a total, an average and a check for missing customers, build a channel-by-month revenue report with SUMIFS and COUNTIFS and see what QUERY does in Sheets, complete an order sheet with VLOOKUP, XLOOKUP and INDEX/MATCH, clean names and build invoice IDs and due dates, check form responses with validation formulas, flag low stock with conditional formatting, build a one-page KPI dashboard with a combo chart and turn a task list into a tracker with overdue flags and status counts. The labs run in Tabellab's browser spreadsheet with formulas that work the same way in Google Sheets. Tabellab is not affiliated with Google. The first two labs are free.
Lessons
- Sharing-Ready Tables: Tidy Data, Totals and ChecksFree
- SUMIFS and COUNTIFS Reports (and QUERY in Sheets)Free
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE) Pro
- Text and Dates: Clean Names, Build IDs and Due Dates Pro
- Data Validation Logic: Checking Form Responses with Formulas Pro
- Conditional Formatting for a Shared Inventory Sheet Pro
- A One-Page KPI Dashboard with a Chart Pro
- Team Task Tracker: Status Counts and Overdue Items Pro