skill~180 mindifficulty

Spreadsheet Foundations

Spreadsheets are the universal first tool where most analysts touch, shape, and reason about data.

1

Learn it

A spreadsheet is a grid of cells you address by reference (A1, B2), organize into columns of one type of value each, and manipulate with sorting, filtering, and formatting. Think of one row as one record and one column as one field. Mastering navigation and cell references is the base every later skill builds on.

By the end you’ll be able to

  • Navigate rows, columns, cells, and sheets confidently
  • Sort, filter, and format a raw data table

Free resources

2

Practice

Download a messy sample CSV, open it in Excel or Google Sheets, freeze the header row, sort by one column, and filter to a subset.

3

Build it — your output

A cleaned, sorted, filtered worksheet with a frozen header and consistent formatting.

4

Prove it — check yourself

You’re ready to move on when you can honestly say yes to each:

  • Can you use absolute vs relative cell references correctly?
  • Can you sort and filter a table without breaking rows?
  • Can you explain why each column should hold one data type?

Do it with AI

Use a free AI tool as your tutor and pair-programmer. Copy a prompt below into Claude, ChatGPT, or Gemini (for building, try Cursor or Copilot).

The habit: Try it yourself first — a little struggle is where the learning actually happens. Then ask for a hint before the answer — never copy blindly.

  • Understand itClaude / ChatGPT / Gemini

    I'm a beginner learning "Spreadsheet Foundations". Explain it in simple terms with a real-world analogy, then ask me ONE question to check my understanding — don't reveal the answer.

  • PracticeClaude / ChatGPT / Gemini

    Give me 3 short practice problems on "Spreadsheet Foundations" (my goal: navigate rows, columns, cells, and sheets confidently), from easy to hard. Don't include the solutions yet — I'll try them first, then ask you to check.

  • Get unstuckClaude / ChatGPT / Gemini

    I'm stuck on this exercise about "Spreadsheet Foundations": [paste your attempt here]. Give me ONE small hint to move forward — do NOT give me the full solution.

  • Build & reviewCursor / Copilot

    Here is my work for a "Spreadsheet Foundations" task: [paste your code or answer]. Review it: point out what's wrong and WHY, and suggest improvements — but let me make the fixes myself.

  • Prove itClaude / ChatGPT / Gemini

    Quiz me on "Spreadsheet Foundations". Ask me 5 questions one at a time, wait for my answer each time, then tell me if I'm right and briefly why.

My notes