What Excel Is
Excel Fundamentals
Chapter 1 · What Excel Is: Workbooks, Worksheets, Cells & the Grid Mental Model
Every other chapter in this course assumes you already have one thing straight: Excel is not a document you type into — it's a grid of independent, addressable storage boxes, each of which can hold a value or a formula that calculates one. That distinction sounds small, but it's the single idea everything else in Excel is built on top of. Get the grid mental model right in this chapter, and formulas, functions, and PivotTables later on will feel like natural extensions of something you already understand, rather than a pile of separate tricks to memorise.
What Excel Actually Is
A word processor like Word treats a page as a flowing stream of text — content pushes other content down as you type. Excel works nothing like that. It treats its workspace as a fixed grid of independent cells, each one identified by its own address, each one able to hold its own piece of data completely independently of its neighbours. Nothing "flows" from one cell into the next unless a formula explicitly says so.
That grid is the reason Excel can do things a word processor fundamentally can't: change one number in one cell and have forty other cells — totals, averages, charts — instantly recalculate, because those forty cells contain formulas that point at the cell you just changed rather than a fixed copy of its old value.
The Three-Level Hierarchy: Workbook → Worksheet → Cell
Everything you do in Excel happens inside one of three nested containers:
| Level | What it is | Real-world analogy |
|---|---|---|
| Workbook | The actual file you save (.xlsx). One workbook can contain many worksheets. | A ring binder |
| Worksheet | One tab inside the workbook, its own independent grid of cells. | One page inside the binder |
| Cell | A single addressable box on a worksheet, holding one value or one formula. | One labelled compartment on that page |
This matters practically the moment a formula needs data from a different tab — a workbook tracking "January," "February," and "March" as three separate worksheets can still have a "Summary" worksheet whose formulas reach across and pull totals from all three, because a cell reference can name which worksheet it's pointing at, not just which cell.
Cell Addresses: The A1 Reference System
Every cell has an address made of two parts: a column letter (A, B, C… running out at Z, then continuing AA, AB…) and a row number (1, 2, 3…, currently running to 1,048,576 in modern Excel). The address B7 means "column B, row 7" — always column first, then row, never the other way round.
You can see and change the currently-selected cell's address directly in the Name Box, just above column A on the left of the formula bar. Typing an address into the Name Box and pressing Enter jumps you straight there — useful once a worksheet grows too large to scroll through comfortably.
C12 is instantly distinguishable from a plain number, so a formula referring to C12 can never be confused with the literal value 12.
What Can Actually Live in a Cell
A cell holds exactly one of four kinds of content, and Excel decides which kind you meant based on what you type:
- Text — anything Excel can't interpret as a number, date, or formula. Left-aligned by default.
- Numbers — plain values Excel can do arithmetic on. Right-aligned by default.
- Dates — typed in a recognisable pattern (e.g.
7/28/2026) and silently converted to a special date-serial number underneath, which is why dates can be added, subtracted, and sorted like numbers even though they display as text. - Formulas — anything starting with
=. The cell displays the calculated result, not the formula text itself, unless you specifically ask to see the formula.
The fourth type is what makes Excel a calculator, not just a table. A formula always begins with an equals sign:
Notice the second example uses a range — A1:A10 means "every cell from A1 through A10 inclusive." Ranges are how Excel lets a single formula operate on dozens or thousands of cells at once, and they're the foundation Chapter 4's functions build on directly.
Navigating the Grid Efficiently
Learning to move around a large worksheet without the mouse pays off almost immediately:
- Arrow keys — move one cell at a time in that direction.
- Ctrl + Arrow — jump to the last cell before a gap in that direction (the fastest way to reach the bottom or edge of a data block).
- Ctrl + Home — jump straight back to cell A1.
- Ctrl + End — jump to the bottom-right corner of the worksheet's actual used range (not the theoretical edge of the grid).
- Tab / Enter — after typing a value, Tab confirms it and moves right; Enter confirms it and moves down.
4.50 while actually storing 4.4978 underneath — formatting only changes what's shown, never what's actually stored or calculated with. This is a genuinely common source of "the totals don't quite add up" confusion, and it's worth remembering the moment formulas start comparing or summing formatted numbers in later chapters.
Hands-On Exercises
Open a new blank workbook. Using only the Name Box (no scrolling or arrow keys), navigate to cell Z100, then to AB4. Explain in your own words what each part of both addresses refers to, and why AB comes after Z rather than after A.
In a blank worksheet, enter the following into four separate cells: the text Total, the number 250, today's date, and the formula =100+50. Describe how each of the four cells displays differently (alignment, appearance) and why, based on the four content types this chapter covers.
Without opening Excel, work out on paper exactly which cells the range B2:D5 refers to (list every individual cell address it covers), then explain what =SUM(B2:D5) would actually add together.
Chapter 1 Quick Reference
- Hierarchy: Workbook (the file) → Worksheet (one tab) → Cell (one addressable box)
- Cell address: column letter + row number, e.g.
B7— always column first - Four things a cell can hold: text, numbers, dates (stored as serial numbers), formulas (start with
=) - A range like
A1:A10means every cell from the first address to the second, inclusive - Fast navigation: Name Box (type an address), Ctrl+Arrow (jump to data edge), Ctrl+Home/End (jump to A1 / used-range corner)
- A cell's displayed value and its stored value can differ once number formatting is applied — covered again in Chapter 6