Spreadsheet basics: cells, data and formats
Almost every office job advert asks for "computer skills", and very often what they really mean is spreadsheets. The good news is that you don't need to be a maths person. You need to understand a few ideas, and then let the spreadsheet do the sums.
Microsoft Excel (on your computer or online) and Google Sheets (free in your browser) do almost exactly the same things, and this course works in both.
Finding your way around
Columns are labelled with letters (A, B, C...) and rows with numbers (1, 2, 3...). Where a column and a row meet is a cell, and its address is just the two together, like B4. A range is a block of cells: B2:B20 means everything from B2 down to B20. One file, called a workbook, can hold several sheets, the tabs along the bottom, like "January", "February" and "Summary". And the formula bar above the grid shows what's really inside whichever cell you've selected.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Date | Item | Category | Qty | Unit price |
| 2 | 2026-03-01 | Sugar 2kg | Groceries | 103 | 320 |
| 3 | 2026-03-01 | Cooking oil 1L | Groceries | 6 | 380 |
| 4 | 2026-03-02 | Soda 500ml1 | Drinks | 24 | 70 |
| 5 | 2026-03-03 | Rice 5kg | Groceries | 4 | 850 |
- 1The selected cell is B4: column B, row 4. Its address shows in the name box on the left.
- 2The formula bar shows what is really inside the selected cell.
- 3A range: D2:D5 is every cell from D2 down to D5.
Three kinds of data
Text, like names, items and notes, lines up on the left. Numbers, like quantities and prices, line up on the right and can be used in calculations. Dates are secretly stored as numbers, which is why you can do sums with them, like working out how many days a payment is overdue.
1500, and use number formatting to show the currency.| B | E | |
|---|---|---|
| 1 | Item | Unit price |
| 2 | Sugar 2kg | 320 |
| 3 | Cake | KES 1,500 |
| 4 | Soda 500ml | 70 |
| 5 | Total | 390 |
| B | E | |
|---|---|---|
| 1 | Item | Unit price |
| 2 | Sugar 2kg | 320 |
| 3 | Cake | 1,500 |
| 4 | Soda 500ml | 70 |
| 5 | Total | 1,890 |
Number formats
Select the cells and choose a format (in Excel, Home then Number; in Sheets, Format then Number). Number with thousand separators shows 1,500.00. Currency or Accounting adds a currency symbol or code. Percentage shows 0.16 as 16%. And Date lets you pick a clear style like 14-Mar-2026. Formatting only changes how a number looks, not its value, so your calculations stay right.
| A | B | C | |
|---|---|---|---|
| 1 | You type | Format | It shows |
| 2 | 1500 | Number | 1,500.00 |
| 3 | 1500 | Currency | KES 1,500.00 |
| 4 | 0.16 | Percentage | 16% |
| 5 | 46095 | Date | 14-Mar-2026 |
Moving around quickly
Enter moves you down and Tab moves you right. Ctrl + arrow key jumps to the end of your data, and Ctrl + Home takes you back to A1. To edit a cell, double-click it or press F2.