📊
CC10045 min
Day 12
Spreadsheets That Calculate
Ready for some spreadsheet magic?
Today's Lesson
Claude Code creates spreadsheets with working formulas, not just numbers. This means your spreadsheets actually calculate things - add new data and the totals update automatically.
Today's Tasks
- 1Ask Claude Code to create an expense tracker
- 2Include: Date, Description, Category, Amount columns
- 3Add formulas: Total, Category subtotals
- 4Open it and verify the formulas work
Prompt to Use
Create an expense tracker spreadsheet (.xlsx) with columns for Date, Description, Category, and Amount. Add 5 sample expenses. Include formulas that calculate the total and show spending by category. Make sure the formulas actually work - I'll test them.
Expected Outcome
A working expense tracker with live formulas.
New Terms
- .xlsx
- Formula
- SUM
- SUMIF
Pro Tip
Ask for "formulas" not "totals". Claude Code will calculate a total for you, but a formula recalculates when you add new data.
Coming Tomorrow
We'll generate PDFs.
P.S. Spreadsheets with formulas are basically mini-programs. You just built one.
Your Study Progress
11%
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Day 12 of 100
Today's Tasks
0/4