What a spreadsheet actually is
A spreadsheet is a grid for storing information and doing arithmetic on it. Each piece of information sits in its own box, and you can write small instructions that read from those boxes and show a result. When a number changes, the results that depend on it update by themselves. That one idea, a table that recalculates, is behind nearly everything people do with these tools, from keeping a shopping list to tracking a small project.
The details differ a little between programs, and many are available online and in desktop form. The core ideas below apply to all the common ones, so this guide describes the general features rather than any particular product’s menus.
Rows, columns and cells
The grid has three basic parts:
- Columns run vertically and are usually labeled with letters (A, B, C and so on).
- Rows run horizontally and are usually labeled with numbers (1, 2, 3 and so on).
- Cells are the individual boxes where a row and a column cross. Each cell has an address made from its column letter and row number, so the cell in column B, row 3 is called B3.
A group of neighboring cells is called a range. A range is written with the first and last cell, such as B2:B6, meaning every cell from B2 down to B6. You will see ranges constantly once you start calculating.
Most files also contain more than one sheet, shown as tabs along the bottom or top. Sheets are a handy way to keep related material in one file, such as raw entries on one sheet and a summary on another.
What goes in a cell
A cell can hold text, a number, a date or a formula. The program treats these differently. Numbers can be added; text cannot. A date is stored as a special kind of number, which lets the program work out the days between two dates. If something you typed will not add up, a common cause is that the cell holds text that only looks like a number, for example a figure with a stray space or symbol attached.
Formatting changes how a value is displayed without changing what is stored. A cell can show a number as currency, a percentage or with two decimal places while the underlying value stays the same. This is useful, but it also means what you see is not always the exact value, a point worth remembering when totals seem slightly off.
Set up your data in a tidy table
Good habits at the start save a lot of trouble later:
- Put a short, clear heading at the top of each column, in the first row.
- Give each row one item or event, such as one order or one expense.
- Keep one kind of information in each column. Do not mix names and amounts in the same column.
- Avoid blank rows and columns in the middle of the data, since many features treat a blank line as the end of the table.
- Keep notes and totals away from the main table, or on another sheet, so they do not get mixed into the data.
This layout makes sorting, filtering and summarizing straightforward. It is also what later steps such as data cleaning and pivot tables expect.
Your first calculations
A formula starts with an equals sign. After it you write what you want, using cell addresses instead of typing the numbers again. Here is a small hypothetical order list:
| A (Item) | B (Quantity) | C (Price each) | D (Line total) | |
|---|---|---|---|---|
| 2 | Notebooks | 3 | 4 | 12 |
| 3 | Pens | 10 | 2 | 20 |
In D2 you would enter =B2*C2, which multiplies 3 by 4 to give 12. In D3, =B3*C3 multiplies 10 by 2 to give 20. To find the grand total you could enter =D2+D3, which gives 32, or use the built-in sum function with a range, =SUM(D2:D3), which also gives 32. The sum function becomes much more convenient as lists grow longer.
Because the formulas refer to cells, changing the quantity in B2 from 3 to 5 would update D2 to 20 and the total to 40, with no retyping. The ideas behind sums, averages, counts and simple conditions build on the basic formulas, and the median average is worth knowing when a few unusual values could distort a typical figure.
Copying formulas and cell references
When you copy a formula down a column, the program usually adjusts the cell addresses to match the new row. A formula in D2 that reads =B2*C2 becomes =B3*C3 in D3. This is called a relative reference, and it is why you can write a formula once and fill it down a whole list.
Sometimes you want an address to stay fixed, for example when every row should use the same tax rate stored in one cell. Placing a dollar sign before the column letter and row number, as in $F$1, locks the reference so it does not shift. If copied formulas give odd results, the reference type is one of the first things to check.
Habits that prevent most mistakes
- Keep the original data untouched. Do any experiments on a copy, or on a different sheet, so you can always get back to what you started with.
- Label things. A heading that says “Price each (USD)” is clearer than “Price”.
- Look at the result and ask whether it is reasonable. If a total is ten times what you expected, something is probably wrong with a range or a typed value.
- Avoid typing numbers inside formulas when they could change later. Put them in a labeled cell and refer to that cell.
- Save versions and keep copies. Sensible file naming, a clear folder structure and regular file backups matter just as much for a spreadsheet as for any other document.
Where to go from here
Once the grid, cell addresses and simple formulas feel familiar, the next skills build on each other fairly naturally: sorting and filtering to find rows, charts to show patterns, and summary tables to answer questions about groups. Spreadsheets are also a common way to organize personal records, and many people start by tracking something small, like a list of tasks or a monthly budget.
Learning at a comfortable pace works better than trying to memorize every function. Most people use a small set of features for nearly everything, and the rest can be looked up when a need arises. If you share your files with others, it is also worth learning about permissions early, so that a casual share does not turn into an accidental exposure of private information.