Convert PDF table into Excel
If you’re tired of manually extracting data from PDFs and want a
smarter way to import and clean data, then this is for you.
Most people don’t realize that Excel has a tool called Power Query,
which can simplify and automate tasks you thought were impossible.
This workbook has worksheets for each level in my video tutorial. In
the video, I show you how to transform a PDF table into a clean,
structured Excel table.
You’ll learn how to remove unnecessary rows, keep the data in its
original order, and get it ready for analysis. All without writing a
single line of code!
Click below to watch the video on YouTube
CLICK HERE
Launch Excel
Level 0 - Copy and Paste
Hover over for instructions
Source of data: https://ir.tesla.com/#quarterly-disclosure
FINANCIALSUMMARY
(Unaudited)
($ in millions, except percentages and per share data)
Q3-2023
Q4-2023
Q1-2024
Q2-2024
Q3-2024
YoY
Total automotive revenues
19,625
21,563
17,378
19,878
20,016
2%
Energy generation and storage revenue
1,559
1,438
1,635
3,014
2,376
52%
Services and other revenue
2,166
2,166
2,288
2,608
2,790
29%
Total revenues
23,350
25,167
21,301
25,500
25,182
8%
Total gross profit
4,178
4,438
3,696
4,578
4,997
20%
Total GAAP gross margin
17.90%
17.60%
17.40%
18.00%
19.80%
195 bp
Operating expenses
2,414
2,374
2,525
2,973
2,280
-6%
Income from operations
1,764
2,064
1,171
1,605
2,717
54%
Operating margin
7.60%
8.20%
5.50%
6.30%
10.80%
323 bp
Adjusted EBITDA
3,758
3,953
3,384
3,674
4,665
24%
Adjusted EBITDA margin
16.10%
15.70%
15.90%
14.40%
18.50%
243 bp
Net income attributable to common stockholders (GAAP)
1,853
7,928
1,129
1,478
2,167
17%
Net income attributable to common stockholders (non-GAAP)
2,318
2,485
1,536
1,812
2,505
8%
EPS attributable to common stockholders, diluted (GAAP)
0.53
2.27
0.34
0.42
0.62
17%
EPS attributable to common stockholders, diluted (non-GAAP)
0.66
0.71
0.45
0.52
0.72
9%
Net cash provided by operating activities
3,308
4,370
242
3,612
6,255
89%
Capital expenditures
-2,460
-2,306
-2,773
-2,270
-3,513
43%
Free cash flow
848
2,064
-2,531
1,342
2,742
223%
Cash, cash equivalents and investments
26,077
29,094
26,863
30,720
33,648
29%
aste
Launch Excel
Level 1 - Word Hack
Hover over for instructions
Source of data: https://ir.tesla.com/#quarterly-disclosure
(Unaudited)($ in
millions, except
Q3-2023 Q4-2023 Q1-2024 Q2-2024
percentages and per
Total automotive
share 19,625 21,563 17,378 19,878
Energydata)
revenues generation
1,559 1,438 1,635 3,014
and storage
Services andrevenue
other
2,166 2,166 2,288 2,608
revenue
Total revenues 23,350 25,167 21,301 25,500
Total gross profit 4,178 4,438 3,696 4,578
Total GAAP gross
17.90% 17.60% 17.40% 18.00%
margin
Operating expenses 2,414 2,374 2,525 2,973
Income from
1,764 2,064 1,171 1,605
operations
Operating margin 7.60% 8.20% 5.50% 6.30%
Adjusted EBITDA 3,758 3,953 3,384 3,674
Adjusted
Net incomeEBITDA
Net income to 16.10% 15.70% 15.90% 14.40%
margin
attributable
attributable to 1,853 7,928 1,129 1,478
common
EPS attributable to
common
stockholders (GAAP) 2,318 2,485 1,536 1,812
common
EPS attributable
stockholders (non-to 0.53 2.27 0.34 0.42
stockholders,
common
GAAP) diluted
(GAAP) 0.66 0.71 0.45 0.52
stockholders, diluted
Net cash provided by
(non-GAAP) 3,308 4,370 242 3,612
operating activities
Capital expenditures -2,460 -2,306 -2,773 -2,270
Free
Cash,cash
cashflow 848 2,064 -2,531 1,342
equivalents and 26,077 29,094 26,863 30,720
investments
Q3-2024 YoY
20,016 2%
2,376 52%
2,790 29%
25,182 8%
4,997 20%
19.80% 195 bp
2,280 -6%
2,717 54%
10.80% 323 bp
4,665 24%
18.50% 243 bp
2,167 17%
2,505 8%
0.62 17%
0.72 9%
6,255 89%
-3,513 43%
2,742 223%
33,648 29%
Launch Excel
Level 2 - Power Query (Beg
Hover over for instructions
Source of data: https://ir.tesla.com/#quar
($ in millions, except percentages and per share data) Q3-2023
Total automotive revenues 19625
Energy generation and storage revenue 1559
Services and other revenue 2166
Total revenues 23350
Total gross profit 4178
Total GAAP gross margin 0.179
Operating expenses 2414
Income from operations 1764
Operating margin 0.076
Adjusted EBITDA 3758
Adjusted EBITDA margin 0.161
Net income attributable to common stockholders (GAAP) 1853
Net income attributable to common stockholders (non-GAAP) 2318
EPS attributable to common stockholders, diluted (GAAP) 0.53
EPS attributable to common stockholders, diluted (non-GAAP) 0.66
Net cash provided by operating activities 3308
Capital expenditures -2460
Free cash flow 848
Cash, cash equivalents and investments 26077
ery (Beginner)
tps://ir.tesla.com/#quarterly-disclosure
Q4-2023 Q1-2024 Q2-2024 Q3-2024 YoY
21563 17378 $19,878 20016 2%
1438 1635 $3,014 2376 52%
2166 2288 $2,608 2790 29%
25167 21301 $25,500 25182 8%
4438 3696 $4,578 4997 20%
0.176 0.174 $0 0.198 195 bp
2374 2525 $2,973 2280 -6%
2064 1171 $1,605 2717 54%
0.082 0.055 $0 0.108 323 bp
3953 3384 $3,674 4665 24%
0.157 0.159 $0 0.185 243 bp
7928 1129 $1,478 2167 17%
2485 1536 $1,812 2505 8%
2.27 0.34 $0 0.62 17%
0.71 0.45 $1 0.72 9%
4370 242 $3,612 6255 89%
-2306 -2773 -$2,270 -3513 43%
2064 -2531 $1,342 2742 223%
29094 26863 $30,720 33648 29%
Launch Excel
Level 3 - Power Query (Adv
Hover over for instructions
Source of data: https://ir.tesla.com/#qu
Custom format: #,##0_);(#,##0);-_);@
($ in millions, except percentages and per share data) Q3-2023
Total automotive revenues 19,625
Energy generation and storage revenue 1,559
Services and other revenue 2,166
Total revenues 23,350
Total gross profit 4,178
Operating expenses 2,414
Income from operations 1,764
Adjusted EBITDA 3,758
Net income attributable to common stockholders (GAAP) 1,853
Net income attributable to common stockholders (non-GAAP) 2,318
EPS attributable to common stockholders, diluted (GAAP) 0.53
EPS attributable to common stockholders, diluted (non-GAAP) 0.66
Net cash provided by operating activities 3,308
Capital expenditures (2,460)
Free cash flow 848
Cash, cash equivalents and investments 26,077
ry (Advanced)
ps://ir.tesla.com/#quarterly-disclosure
##0_);(#,##0);-_);@_)
Q4-2023 Q1-2024 Q2-2024 Q3-2024
21,563 17,378 19,878 20,016
1,438 1,635 3,014 2,376
2,166 2,288 2,608 2,790
25,167 21,301 25,500 25,182
4,438 3,696 4,578 4,997
2,374 2,525 2,973 2,280
2,064 1,171 1,605 2,717
3,953 3,384 3,674 4,665
7,928 1,129 1,478 2,167
2,485 1,536 1,812 2,505
2.27 0.34 0.42 0.62
0.71 0.45 0.52 0.72
4,370 242 3,612 6,255
(2,306) (2,773) (2,270) (3,513)
2,064 (2,531) 1,342 2,742
29,094 26,863 30,720 33,648
