← Sheets with Martin

Level 4 プレミアム · 10 € 一度限り

Sorter

Sort, filter, IF and cleaning data. 12 lessons.

1. Sort and filter Data → Create a filter. Sorting is not deleting. ⏱ 22 minutes
2. KDYŽ — the table decides When a grade is worse than 3, write “practice”. ⏱ 22 minutes
3. Cleaning data Spaces, empty rows and “n/a” break the average. ⏱ 20 minutes
4. Advanced filter More conditions at once — AND, OR, between two numbers. ⏱ 20 minutes
5. Text to columns One cell with first name and last name → two columns. ⏱ 19 minutes
6. Removing duplicates The same row twice? The table finds it and deletes it. ⏱ 18 minutes
7. Nested KDYŽ KDYŽ inside KDYŽ — more than two options. ⏱ 22 minutes
8. Summary table — intro Counts without filtering by hand — COUNTIF and a summary. ⏱ 21 minutes
9. Data validation — a list Only what is on the list will go into the cell. ⏱ 19 minutes
10. Survey — cleaning answers From a form to a table that fits with COUNTIF and a chart. ⏱ 22 minutes
11. Check before sharing Filter off, totals fit, no hidden dirt. ⏱ 18 minutes
12. Sorter — finale Data clean, summaries fit, ready for the Modeller and the Boss. ⏱ 24 minutes

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