Lesson 1 of 10 · about 8 min

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.

  1. 1The selected cell is B4: column B, row 4. Its address shows in the name box on the left.
  2. 2The formula bar shows what is really inside the selected cell.
  3. 3A range: D2:D5 is every cell from D2 down to D5.
Columns have letters, rows have numbers, and the sheet tabs (March, April, Summary) sit along the bottom.
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.

A very common mistake: typing "KES 1,500" or "1500/=" into a price cell turns it into text, and formulas will quietly ignore it. Type just 1500, and use number formatting to show the currency.
Typed as text
Typed as a number
"KES 1,500" sits on the left because it is text, and SUM quietly skips it: 390 instead of 1,890. Type 1500 and the total is right.
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.

Formatting changes how a value looks, never the value itself. Even a date is just a number underneath (46095 is 14 March 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.

Try it: Open Excel or Google Sheets and download the Practice Workbook from the course page. Have a look around: find cell D7, select the range B2:B21, format the Unit price column as numbers with thousand separators, and give the Date column a clear date style.

Enjoying it? Create a free account to save your progress. Create free account