← Sheets with Martin

Level 6 プレミアム · 18 € 一度限り

Workbook boss

Dashboard, sharing and one source of truth. 12 lessons.

1. Mini dashboard Three numbers at the top, a filter, one chart. Nothing more. ⏱ 22 minutes
2. Sharing without chaos A comment yes, “anyone can edit” no. ⏱ 18 minutes
3. One truth in a table Do not copy numbers into chat. A link to the workbook is the source. ⏱ 20 minutes
4. KPI and a monthly overview Three numbers the teacher will see first — average, spending, winner. ⏱ 20 minutes
5. Links between workbooks IMPORTRANGE Data from another workbook — one truth across the internet. ⏱ 22 minutes
6. Versions and change history What changed yesterday? Versions on Drive and named copies. ⏱ 18 minutes
7. Comments and tasks A note at a cell — a teammate knows what to fix, without chat. ⏱ 19 minutes
8. Protecting ranges The dashboard shows, Znamky calculate — nobody overwrites a formula. ⏱ 21 minutes
9. A dashboard for the teacher One page, three KPIs, one chart — without dirt. ⏱ 23 minutes
10. Presenting data — print Dashboard on paper — colours, margins, the whole chart. ⏱ 18 minutes
11. Audit “one truth” Go through the workbook — where is a copy instead of a link? ⏱ 20 minutes
12. Workbook boss — finale Dashboard, sharing, PDF — the whole Excel project 完了. ⏱ 24 minutes

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