What a spreadsheet is
A spreadsheet is a grid for storing numbers and text, with the ability to calculate from what you enter. Typical uses for a learner include tracking grades, planning study hours, keeping a budget or tidying a small set of data from an experiment. The most common programs behave in broadly similar ways, so what follows should carry across most of them, although menu names and some details differ.
Cells, rows and columns
The grid is made of cells, the boxes where you type. Cells line up in rows, which run across the page and are numbered (1, 2, 3…), and in columns, which run down and are lettered (A, B, C…).
Each cell has an address made from its column letter and row number. The cell in column B, row 3 is B3. You will use these addresses constantly.
A cell can hold text, a number, a date or a formula. A good habit is to put headings in the first row, such as “Week”, “Hours” and “Score”, and to keep one kind of information in each column. Leaving blank rows or columns in the middle of data makes sorting and calculation less reliable.
Entering data
Click a cell and type. Press Enter to move down, or Tab to move right. To change what is in a cell, select it and retype, or double-click to edit in place. Dates and numbers are recognized automatically in many cases, but if a value looks odd, such as a date turning into a number, check the cell format, which controls how a value is displayed.
Your first formula
A formula starts with an equals sign. Type it into a cell, and the cell shows the result.
Try a small hypothetical example. Suppose you enter four practice scores in cells B2 to B5: 12, 15, 9 and 14. In cell B6, type:
=SUM(B2:B5)
The result is 50, because 12 + 15 + 9 + 14 = 50. The part in brackets, B2:B5, is a range: the colon means “from B2 to B5”.
To find the average, type in another cell:
=AVERAGE(B2:B5)
The result is 12.5, which is 50 divided by 4. This is the mean. The middle value and the most common value are different summaries, and having averages explained in plain terms helps you pick the right one for your data.
You can also use ordinary arithmetic. =B2+B3 adds two cells, =B5-B4 subtracts, =B2*2 multiplies by 2, and =B2/4 divides by 4. The program follows the usual order of operations, so multiplication and division happen before addition and subtraction, and brackets change the order. For example, =(B2+B3)/2 finds the mean of two cells.
Other useful early functions are =MIN(B2:B5) and =MAX(B2:B5), which give the smallest and largest values (9 and 15 here), and =COUNT(B2:B5), which counts the numbers in the range (4 here).
Why cell references matter
The big advantage of a spreadsheet is that formulas refer to cells, not to fixed numbers. If you change B3 from 15 to 16, the total updates by itself to 51. This saves you from redoing sums, and it makes errors easier to find, because you can click a formula and see what it is using.
Copying a formula
If you have a column of values and want a total for each row, write the formula once and copy it down. Most spreadsheets adjust the references automatically: a formula =B2*60 copied one row down becomes =B3*60. This is called a relative reference.
Sorting without scrambling
Sorting puts rows in order, for example highest score first or dates from earliest to latest. The main danger is sorting a single column and leaving the others behind, which breaks the link between a value and its row.
To sort safely:
- Make sure your data has a header row and no blank columns inside it.
- Click any cell inside the data, or select the whole table.
- Choose the sort command, pick the column to sort by and choose ascending or descending.
- Tick the option saying your data has headers, if it appears.
- Check afterwards that every row still makes sense.
Keep a copy of the original before your first few sorts, and remember Ctrl + Z for undo. If rows are numbered in a column, keep that number if you may want to restore the original order. Using proper year-month-day dates in a date column means they also sort in time order.
Filters and charts
A filter hides rows that do not match a condition, such as scores above 10, without deleting them. You can also turn a column into a chart, though choosing and labeling one clearly is a skill of its own.
Common beginner mistakes
- Typing numbers with units like “12 hours” in a cell. The cell is then text and cannot be added. Put the unit in the heading instead.
- Forgetting to check a result. Do a rough calculation in your head to see if the answer is plausible.
- Ignoring error messages. Messages like #DIV/0! mean the formula tried to divide by zero; look at the cells it refers to.
- Not saving versions. Use clear file names and keep a backup.
Next steps
Build something small and real, such as a grade tracker with one row per assignment, a column for the mark and a column for the possible maximum. Add a formula for the percentage (mark divided by maximum, times 100) and an average at the bottom. Using your own data keeps practice meaningful. As with other skills, a little regular practice works better than one long session.