Spreadsheet modelling — Excel formulas, pivot tables

What you'll learn

1. 1

   Imagine you're planning a party 🎉 and you have a list of costs. A spreadsheet is like a giant grid where you can type numbers and make them do maths for you!

2. 2

   Let's build a simple cost table. In cell B2 type '5' (price of a pizza slice). In cell C2 type '3' (how many slices). Now in D2, we'll write a formula to multiply them.

3. 3

   Let's do one together: You have a column of prices (A2:A5) and a column of quantities (B2:B5). How do you find the total cost?

4. 4

   What symbol do you use to start a formula in Excel?

5. 5

   Now you try: In a new sheet, put '8' in A2 and '4' in B2. Write a formula in C2 to multiply them. What does it show?

6. 6

   You have 10 rows of data. You want to add up all the values in column D. Which formula do you use?

7. 7

   Pivot tables are like magic summary machines 🪄. They take a big list of data and group it for you — like 'how many pizzas did each person order?' without you typing formulas.