← Sheets with Martin

Level 5 プレミアム · 14 € 一度限り

Modeller

Lookups, percents and what-if in a sheet. 12 lessons.

1. Locked address $A$1 The dollar holds the cell in place when you copy the formula. ⏱ 22 minutes
2. Find a value in a table SVYHLEDAT / XLOOKUP: subject code → name. ⏱ 25 minutes
3. What if — two scenarios One table, two numbers at the top: pessimist and plan. ⏱ 20 minutes
4. XLOOKUP / lookup deeper Looking left, a missing value, an exact list. ⏱ 22 minutes
5. Percents and growth By how many percent did spending grow? Year-on-year grade change. ⏱ 20 minutes
6. Scenario manager Save versions of the model — an optimistic and a pessimistic week. ⏱ 21 minutes
7. Data table — 1 variable F2 runs from 0.8 to 1.5 — the table shows results at once. ⏱ 22 minutes
8. Data table — 2 variables F1 reserve × F2 spending — a grid of results. ⏱ 24 minutes
9. Pocket money — a “what if” scenario Ice cream, saving, empty pocket — three stories in one model. ⏱ 23 minutes
10. Linking more sheets Znamky!B8 on the Dashboard — a formula, not a copy. ⏱ 20 minutes
11. Checking the model An audit of formulas — what breaks when you change one cell? ⏱ 19 minutes
12. Modeller — finale A pocket-money model, scenarios, linking — ready for the Boss. ⏱ 24 minutes

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