What Excel is and finding your way around
Meet Excel: the grid, cells, rows and columns, the formula bar and your first small sheet that calculates totals for you.
In this lesson you will
- Name the parts of the Excel screen
- Read and write cell addresses and ranges
- Type data and a first formula
- Save a workbook with a clear name
About 14 minutes
A notebook that does the sums for you
Mina sells handmade notebooks and pens at weekend markets. Every Sunday night she opens her paper ledger, adds up the week with a calculator, and, once a month, finds she has made a mistake somewhere. A friend says, ‘Put it in Excel.’ Mina is nervous. She imagines a screen full of tiny boxes and hard formulas. In this lesson you will see that Excel is much friendlier than it looks. By the end you will know the parts of the screen, you will have typed your first small sheet, and you will have seen Excel do a calculation for you.
What Excel is
Excel is a spreadsheet program. A spreadsheet is a large grid of boxes. You type words, numbers and dates into the boxes, and you can ask the program to calculate with them. When a number changes, every calculation that uses it updates by itself. That one idea, ‘change a number and the answers follow’, is why people have used spreadsheets for decades for budgets, price lists, marks, schedules, stock lists and reports.
This course uses Microsoft Excel, but almost everything also works in Google Sheets and LibreOffice Calc. Where something differs, the lesson will say so.
Free ways to start
| Tool | Where it runs | Notes |
|---|---|---|
| Excel for the web | Browser, with a free Microsoft account | Fewer features than the desktop app, but enough for this course |
| Google Sheets | Browser, with a free Google account | Very similar; works well for sharing |
| LibreOffice Calc | Free download for Windows, Mac, Linux | Opens and saves .xlsx files |
| Excel desktop | Paid Microsoft 365 or a purchased version | The full program; many workplaces use it |
Use whichever you can open today. The skills you learn transfer between all of them.
The parts of the screen
| Part | What it is |
|---|---|
| Workbook | The whole file, saved as .xlsx. Like a folder of sheets |
| Worksheet (sheet) | One page of the grid. Tabs at the bottom switch between sheets |
| Cell | One box in the grid. This is where you type |
| Column | A vertical line of cells, named with letters: A, B, C … |
| Row | A horizontal line of cells, named with numbers: 1, 2, 3 … |
| Name Box | The small box at the top left showing which cell is selected |
| Formula bar | The wide bar at the top showing what is really inside the selected cell |
| Ribbon | The tabs and buttons at the top (Home, Insert, Formulas, Data …) |
Cell addresses
Every cell has an address made of its column letter and its row number. The box where column B meets row 3 is B3. Addresses are how formulas find your data, so say them out loud until they feel natural: ‘A1, B2, C10’. A group of cells is a range, written with a colon: A1:A5 means every cell from A1 down to A5.
Your first sheet
- Open a new blank workbook.
- Click cell A1 and type Item. Press Tab to move right.
- Type Price, Tab, Quantity, Tab, Total, then press Enter. Excel jumps back to the start of the next row.
- In row 2 type Notebook, 40, 12. In row 3 type Pen, 5, 100.
- Click D2 and type =B2*C2, then press Enter. Do the same in D3 with =B3*C3.
The sheet now looks like this. The Total column was calculated by Excel. The values below were computed by really recalculating this sheet in a spreadsheet program:
| Item | Price | Quantity | Total |
|---|---|---|---|
| Notebook | 40 | 12 | 480 |
| Pen | 5 | 100 | 500 |
Click D2 and look at the formula bar. The cell shows 480, but the formula bar shows =B2*C2. This is the most important idea in this lesson: a cell shows a result, while the formula bar shows what is inside. Now change B2 from 40 to 45 and press Enter. D2 updates to 540 without you touching it.
Moving and selecting
- Arrow keys, Tab and Enter move the selection.
- Click and drag to select a range. Click a column letter or row number to select the whole line.
- Ctrl+Home goes to A1. Ctrl+arrow jumps to the edge of your data.
- Ctrl+Z undoes. Ctrl+S saves. Save early and often.
Saving and file types
| Type | Use |
|---|---|
| .xlsx | A normal Excel workbook: keeps formulas, formatting and charts |
| .csv | Plain text with commas; one sheet, no formatting. Good for moving data between programs |
| A fixed, read-only copy to send to people |
Name files clearly, for example market-sales-2026.xlsx, not Book1.xlsx. Future you will be grateful.
Practice
Build a three-row sheet for something real in your life: groceries, class marks or monthly bills. Give it a header row, at least two numeric columns and one calculated column. Change one number and watch the calculation follow. Save it with a sensible name.
A grocery sheet might have Item, Price, Quantity and Cost, with Cost as =B2*C2 copied down. If your calculated column does not change when you edit a number, check that you typed the equals sign at the start of the formula.
Typing a calculation as plain text, such as 40*12 without the equals sign. Excel treats it as words. Every formula must start with =.
Check what you learned
Five quick questions. Pick an answer and you will see straight away whether it is right and why.
What is the address of the cell where column C meets row 5?
- 5C
- C5
- CC5
- R5C
Column letter first, then row number.
What does the formula bar show?
- Only the result
- The file name
- The page number
- What is really inside the selected cell
A cell shows the result; the bar shows the formula.
What must every formula start with?
- An equals sign
- A colon
- A quote
- A space
Without = Excel treats the entry as text.
What does A1:A5 mean?
- Only A1 and A5
- Column A and row 5
- The range from A1 down to A5
- A1 divided by A5
The colon joins the start and end of a range.
Which file type keeps formulas and formatting?
- .csv
- .txt
- .png
- .xlsx
.csv keeps only plain values.
Summary
- A cell shows a result; the formula bar shows what is inside.
- Cells have addresses such as B3; ranges use a colon, such as A1:A5.
- Every formula starts with an equals sign.
- Save often and name files clearly.
Questions
Do I need to pay for Excel?
No. Excel for the web, Google Sheets and LibreOffice Calc are free and cover everything in this course.
Is it hard to learn Excel?
Not at the start. If you can use a calculator and a table, you can start. This course builds up one small step at a time.
What is the difference between a workbook and a worksheet?
A workbook is the whole file. A worksheet is one page (tab) inside it.
