← Sheets with Martin

Level 2 free

Formula kid

Equals, SUM, AVERAGE and copying a formula. 12 lessons.

1. A formula starts with equals Without = the spreadsheet takes it as text. With = it counts. ⏱ 18 minutes
2. SUM and AVERAGE Ready-made functions instead of a long + + +. ⏱ 20 minutes
3. Copying a formula Write a formula once, drag down. The references shift. ⏱ 20 minutes
4. MIN and MAX The worst and best grade without hunting with your eyes. ⏱ 18 minutes
5. Counting cells COUNT How many answers in a survey — without counting on fingers. ⏱ 17 minutes
6. Absolute reference A dollar in the address — the cell does not move when copying. ⏱ 20 minutes
7. Relative reference deeper Copying right, a diagonal and traps with ranges. ⏱ 20 minutes
8. A formula across sheets An average from Grades on the Dashboard — one workbook, more sheets. ⏱ 20 minutes
9. Fixing errors (#DIV/0!) What the red bangs mean and how to fix them. ⏱ 18 minutes
10. Pocket money — income and spend A whole week in formulas: left, totals, an average. ⏱ 21 minutes
11. Conditional formatting — intro A cell turns red itself when a grade is worse than 2. ⏱ 19 minutes
12. Formula kid — finale Grades, pocket money and a dashboard — everything counts itself. ⏱ 22 minutes

Coding is still on the home page — this course does not replace it.