Course · v1.0.0

Google Sheets

Keep data clean enough to trust, then get answers out of it. Entry and formats, sort and filter, validation, the six formulas that cover most small-business questions, pivot tables, charts and a careful look at Gemini in Sheets.

9 lessons · about 62 minutes · pass at 80% · certificate does not expire

What you will be able to do

  • Enter and format data so each column holds one kind of value, with a frozen header row and consistent number, date and currency formats.
  • Sort and filter data without scrambling rows, and use data validation to stop bad entries at the source.
  • Write and read the core formulas SUM, AVERAGE, COUNTIF, SUMIF, IF and XLOOKUP with the right ranges.
  • Summarise a table with a pivot table by region, category or month and sort it to find the biggest and smallest.
  • Choose the chart that answers the question being asked and label it so it stands on its own.
  • Use Gemini in Sheets to draft formulas and summaries, and check its output against the data before relying on it.
  • Clean a messy sales sheet and answer business questions from it accurately.

Lessons

  1. Data entry and formats

    One row per record, one kind of value per column, a header row that stays put. Everything else in this course depends on it. · 8 min

  2. Sort and filter without scrambling rows

    Sorting one column by itself tears the rows apart. Use a filter on the whole table and the rows stay together. · 7 min

  3. Data validation, stop bad entries at the source

    A dropdown or a rule on the column means "Paid", "paid" and "PAID" never happen in the first place. · 6 min

  4. Formulas 1: SUM, AVERAGE, COUNTIF, SUMIF

    Four formulas answer "how much", "how much on average", "how many of these" and "how much for these". · 8 min

  5. Formulas 2: IF and XLOOKUP

    IF makes a decision for each row. XLOOKUP fetches a value from another table so nobody retypes prices. · 8 min

  6. Pivot tables

    Total by region, count by status, sales by month, in a minute and without writing a formula. · 7 min

  7. Charts that answer a question

    Decide what question the chart answers, pick the one chart type that answers it, label it so it stands alone. · 6 min

  8. Gemini in Sheets

    Gemini can draft a formula, build a table or summarise a sheet in seconds. Treat the result as a draft from a fast new colleague, and check it. · 6 min

  9. Lab: clean the sales sheet and answer four questions

    A messy export arrives. Make it a clean table, then get four answers out of it that you would be happy to repeat to the owner. · 6 min

  10. Assessment: Clean the sales sheet and answer four questions

    Tidy a seeded sales sheet, then read the data to say which region fell most, the total for a category, how many rows meet a condition and which formula fits.

Start lesson 1