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