A calm, beginner-friendly walk through the spreadsheet skills you will actually use: what cells, rows, and columns are, how to type in your data, how to add a column of numbers with SUM, and how to sort a list into order. Along the way you will pick up the one habit that saves beginners the most grief — not typing over a formula or your only copy, and saving a backup before you experiment.
Never type over a formula or your only copy — save a backup first, then experiment freely.
Last reviewed 2026-06-17 by the IT Lunchroom Editorial Team. Free, plain-English guidance for everyday work technology.
By the end of this lesson you will be able to open a blank spreadsheet, type in a simple list, add a column of numbers with SUM, sort your list into order, and do it all without fear of breaking anything.
A spreadsheet is just a grid of little boxes. Each box is called a cell, and it is where you type one piece of information, like a name or a number. The rows go across (they have numbers down the side) and the columns go up and down (they have letters across the top). So a cell has an address made of its column letter and row number, like B3, the same way a seat has a row and a number on a plane ticket.
To put something in a cell, you click the cell once and start typing, then press Enter to move down or Tab to move across. Text sits on the left, numbers sit on the right, and that is normal. A common first spreadsheet is a simple list: put a heading in the top row of each column (like Item, Price), then fill in one item per row underneath. Keep one kind of thing per column and you will thank yourself later.
Say you have a column of prices and you want the total. Instead of adding them in your head, you let the spreadsheet do it. Click an empty cell below your numbers and type =SUM(, then click and drag over the numbers you want to add, and press Enter. The equals sign is you saying "this cell is a calculation, not plain text." SUM just means "add these up." The best part: if you change one of the prices later, the total updates on its own.
When your list gets long, you can put it in order without retyping anything. Click any cell inside your list, then look for a Sort button (often under a Data menu, and sometimes shown as A to Z). Sorting can put names in alphabetical order or numbers from smallest to largest. The important thing to know: a good sort keeps each row together as one unit, so a person's name stays lined up with their own numbers. Take a quick look after sorting to make sure the rows still match up.
It tells the spreadsheet that the cell is a calculation, not plain text. When you type =SUM(...) the program does the math and shows the answer. If you leave the equals sign off, it just shows the words you typed and adds nothing up.
No, that is completely normal. When you click a cell that holds a formula, the spreadsheet shows you the recipe behind the number, usually up in the bar at the top. Click away to any other cell and you will see the calculated number again. Just avoid typing over that cell, or you will replace the formula with whatever you type.
Before you make a big change like sorting or deleting, save a copy first, for example with a name like Budget-backup. That way the original is safe if something goes wrong. Making a copy takes a few seconds and can save you an afternoon of redoing everything.
Reading is a good start — now try a short, interactive version. Spotting Sensitive Information Before You Share It lets you make the real decision in a safe practice run, no login needed.
Create a free account to save your place across all the free lessons. Work through an interactive track and you earn a shareable certificate you can add to a résumé or job application. No payment, no catch.
We use cookies for basic analytics to improve these free lessons. See our Privacy Policy.