📗 Excel for Beginners · Lesson 3 of 10
Your first formula
How to write a formula in Excel: the equals sign, cell references, multiplying, adding and subtracting.
The tasks in this lesson
1. How much do the balloons cost?
- Click D2
- Type
=B2*C2and press Enter
💡 You can type = and then click B2 with the mouse instead of typing it.
2. Every row
- D3:
=B3*C3 - D4:
=B4*C4 - D5:
=B5*C5
💡 In lesson 5 you will learn to fill rows like these with a single drag.
3. Everything together, and what is left
- D6:
=D2+D3+D4+D5 - D9:
=D8-D6
💡 Change the pizza amount to 5 and watch every total update by itself.
All lessons
- ✍️ 1. Typing in cellsCells, typing, fixing and deleting
- 🎨 2. Format a tableSelect a range, bold and dollar format
- 🧮 3. Your first formulaMultiply, add and subtract between cells
- ➕ 4. SUM and AVERAGEThe total and the average of a column
- ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
- 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
- 🔀 7. IF: if... then...Pass or fail, and COUNTIF
- ↕️ 8. Sort a tableHigh to low, and alphabetical
- 📊 9. Your first chartA bar chart and a pie chart
- 🏠 10. Project: a family budgetEverything we learned in one sheet