Lessons
62 short lessons in 13 modules. If you are just starting, follow them in order.
First steps: Typing in the sheet, doing math and copying formulas.
Everyday functions: Add, average, find the largest and smallest, count and round.
Automatic decisions: Make the sheet decide on its own: "if it's like this, show that".
Counting and adding with rules: Count and add only what matters, like "only delivered orders".
Looking up information: Find a piece of information in a table, like a product's price from its code.
Text: Cut, join and tidy up names, codes and other text.
Dates: Count days, find days of the week and calculate due dates.
Tricks with numbers: Podiums, rankings and other tricks with numbers.
Building the spreadsheet: The look of professional templates: tab, widths, title, fields, header, borders, formats and total.
Lists and automatic colors: Drop-down lists and conditional formatting: colored statuses, alerts, bars and heat maps.
Cards and dashboards: Cards with the key numbers, summaries by category, tabs that work together and dashboards with a pick list.
Charts: Column, pie, line and bar charts, linked to the table and updated automatically.
Schedules and Gantt: Timeline, Gantt bars and deadline alerts, like in project schedules.
- 1. Getting to know the spreadsheet
- 2. Your first calculation
- 3. Plus, minus, times and divide
- 4. Parentheses: what comes first
- 5. Copying a formula down many rows
- 6. The lock ($)
- 7. Percentages without fear
- 8. SUM: add everything at once
- 9. AVERAGE: the "middle" value
- 10. MAX and MIN: the largest and the smallest
- 11. Counting cells
- 12. Rounding values
- 13. IF: the spreadsheet making decisions
- 14. AND and OR: combining conditions
- 15. IF inside IF: more than two options
- 16. IFERROR: hiding errors
- 17. COUNTIF: count only what matters
- 18. SUMIF: add only what matters
- 19. AVERAGEIF: average only what matters
- 20. SUMIFS and COUNTIFS: several rules
- 21. VLOOKUP: look up a value in a table
- 22. VLOOKUP by ranges
- 23. INDEX and MATCH: the dynamic duo
- 24. XLOOKUP: the modern lookup
- 25. Cutting text
- 26. Joining text
- 27. Cleaning up messy text
- 28. Counting letters and finding positions
- 29. SUBSTITUTE: swapping pieces of text
- 30. Working with dates
- 31. How many days are left?
- 32. Day of the week and due dates
- 33. Podium: the largest and the smallest
- 34. RANK: who finished where
- 35. SUMPRODUCT: multiply and add at once
- 36. Hours and minutes: INT and MOD
- 37. Tab name and gridlines
- 38. Column width and row height
- 39. A professional template title
- 40. Information fields at the top
- 41. Table header
- 42. Borders and stripes
- 43. Currency, percentage and date
- 44. Group and total rows
- 45. Freeze panes
- 46. Drop-down list
- 47. Automatic colors by text
- 48. Color by value: red alerts
- 49. Data bars
- 50. Color scale (heat map)
- 51. Color rule with a formula
- 52. KPI cards
- 53. Summary by category
- 54. Summary on another tab
- 55. A dashboard that changes with a list
- 56. Column chart
- 57. Pie and doughnut charts
- 58. Line chart and Switch Row/Column
- 59. Bar chart for rankings
- 60. Date timeline
- 61. The Gantt bars
- 62. Deadlines and late alerts