Lesson 1: Typing in cells
- Click cell A2, type Milk and press Enter
- Click B2 and type 2
- In row 3: Bread, amount 1
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | |||
| 3 | |||
| 4 | Eggs | 30 | |
| 5 | Cheese | 2 | |
| 6 | Delete me | ||
| 7 |
- A2 = Milk
- B2 = 2
- A3 = Bread
- B3 = 1
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Your first Excel lesson: what a cell is, how to type text and numbers, and how to fix and delete them. Enter moves down one cell. Tab moves to the next column. F2 or a double-click opens the cell for editing without erasing what is inside.
Explore more: Excel course: all lessons, and Format a table.