Excel · 30 days
Master spreadsheets in 30 days. From SUM to pivot tables, 10 minutes a day.
Day 1
SUM, AVERAGE, COUNT on a sample column.
Day 2
Cell references: relative vs absolute ($).
Day 3
IF formula: =IF(A1>10, 'big', 'small').
Day 4
VLOOKUP or XLOOKUP a value across sheets.
Day 5
Conditional formatting on a sales column.
Day 6
Build your first pivot table.
Day 7
Charts: insert a clean bar chart with titles.
Day 8
Review previous days and practice for 10 minutes.
Day 9
Day 10
Day 11
Day 12
Day 13
Day 14
Day 15
Day 16
Day 17
Day 18
Day 19
Day 20
Day 21
Day 22
Day 23
Day 24
Day 25
Day 26
Day 27
Day 28
Day 29
Day 30