What a Spreadsheet Really Is

Lesson 1 · taught by Pip · free preview

Pip here. Before we clean or chart anything, let's be sure of the ground under our feet. A spreadsheet is simply a grid for holding information — a program like Excel, Google Sheets, or Apple Numbers that arranges your facts into neat little boxes. That's the whole idea. It only sounds technical because it lives on a screen.

Think of a printed appointment book. Down the side, one line per appointment. Across the top, headings: time, name, reason for visiting. Every appointment gets its own line, and every heading holds one kind of detail. A spreadsheet is that book, made of light instead of paper — and able to do arithmetic for you.

Rows, columns, and cells

Three words will carry you through this whole course, so let's define them plainly.

A row runs left to right, and it stands for one single thing you care about — one customer, one sale, one day. A column runs top to bottom, and it holds one single fact about every thing — everybody's email, everybody's price, everybody's date. Where a row and a column cross, you get one box called a cell, and a cell holds exactly one value.

The golden rule, the one that makes everything later possible: one thing per row, one fact per column. A spreadsheet that respects this rule is a joy to work with. One that breaks it — two prices crammed in a box, a name and a phone number sharing a cell — will fight you at every step.

Rows are usually numbered down the left edge (1, 2, 3) and columns lettered across the top (A, B, C). So a single cell has an address, like B7, the way a seat has a row and number. That address is how you and the spreadsheet point at the exact same box.

The header row

The very top row is special. It's the header row — the line of labels that names each column: "Date," "Customer," "Amount." The header isn't data; it's the sign over each aisle telling you what's stored beneath it.

Good headers are short, plain, and unique. "Order Date" beats "When." One word per idea beats a sentence. And every column gets a header — a nameless column is a mystery you'll have to solve again every time you open the file.

Values, formulas, and why the grid is powerful

A cell can hold a plain value you typed — the number 40, the word "Tuesday." But a cell can also hold a formula: a small instruction the spreadsheet calculates for you, like "add these three cells together." You'll always see the answer in the cell, with the instruction tucked underneath.

That's the quiet magic. A spreadsheet isn't just storage — it's storage that does math. Change one number, and every formula that depends on it updates instantly, like a tide lifting every boat in the harbor at once. We'll lean on that power in later lessons.

Why this matters

Almost every business, club, and household keeps its important lists in a spreadsheet — money in and out, members, inventory, schedules. Understanding its true shape, this honest grid of rows and columns, is the foundation under cleaning, sorting, filtering, summarizing, and charting. Get the shape right and the rest of the course clicks into place.

Your turn

Open any spreadsheet you have, or picture one. Answer three quick questions:

1. What does one row stand for — the single kind of thing each line represents?
2. Name two columns — two single facts recorded about that thing.
3. Look at the header row. Is every column clearly named? Is any column missing a label?

If you can answer all three, you're reading the grid the way the rest of this course will. Next, we'll roll up our sleeves and clean a messy sheet so the data is actually trustworthy.