CellWorks

Google Sheets · Essentials

Navigate, enter data and write your first formulas.

Lessons

  1. 1Getting Started with Google SheetsFind your way around a Google Sheets spreadsheet and record a book club’s reading list.Not started10 min
  2. 2Rows, Columns & RangesComplete a community garden watering rota and understand ranges like A2:C5.Not started11 min
  3. 3Entering & Formatting DataFormat a weekend market stall’s price list with bold headers and two-decimal number format.Not started12 min
  4. 4Your First FormulasCalculate a school bake sale’s takings with formulas that reference cells.Not started12 min
  5. 5SUM, AVERAGE, MIN, MAX & COUNTSummarise a cycling club’s weekly distances using the Functions button and typed functions.Not started13 min
  6. 6Organising Data with Convert to TableTurn a home inventory list into a Google Sheets table and total its value.Not started13 min
  7. 7Relative & Absolute ReferencesConvert holiday expenses with one fixed exchange rate locked with $.Not started13 min
  8. 8Working with PercentagesCalculate discounts and each category’s share of an online shop’s sale.Not started13 min
  9. 9ROUND, ROUNDUP & ROUNDDOWNSplit carpool fuel costs fairly and round amounts the right way for payment apps.Not started13 min
  10. 10Counting with COUNTA & COUNTBLANKTrack RSVPs for a family reunion by counting filled and empty responses.Not started13 min
  11. 11Splitting & Joining TextPrepare name badges by splitting full names with SPLIT and joining text with &.Not started15 min
  12. 12Final Assessment: Club Event BudgetPractical assessment: complete a sports club’s event budget with entry, formatting, functions, locked references, percentages and rounding.Not started20 min