1
00:00:00,000 --> 00:00:05,152
[MUSIC]

2
00:00:05,152 --> 00:00:09,224
Hi I'm Mike Watson, I'm the CFO here at
Treehouse and I'm super excited to be

3
00:00:09,224 --> 00:00:12,940
teaching you about spreadsheets today
because I use them all the time.

4
00:00:14,060 --> 00:00:17,300
A spreadsheet is an electronic
document that arranges data

5
00:00:17,300 --> 00:00:20,420
in a table by using columns and rows.

6
00:00:20,420 --> 00:00:25,610
Among other things, spreadsheets let you
store, manipulate, share and analyze data.

7
00:00:26,918 --> 00:00:28,660
Spreadsheets are used for
both business and

8
00:00:28,660 --> 00:00:31,810
personal use all over the world, everyday.

9
00:00:31,810 --> 00:00:34,610
This is because the spreadsheet
is a fairly simple,

10
00:00:34,610 --> 00:00:39,790
accessible way to store, analyze,
collaborate and present information.

11
00:00:39,790 --> 00:00:44,090
People use spreadsheets to help analyze
data to make well informed decisions, for

12
00:00:44,090 --> 00:00:49,185
things as complicated as where to open new
restaurant locations or build wind farms.

13
00:00:49,185 --> 00:00:51,600
Sometimes simpler tasks like
what type of television to buy.

14
00:00:52,670 --> 00:00:55,800
If you've been tracking your household
expenses from month to month

15
00:00:55,800 --> 00:00:56,920
in a spreadsheet,

16
00:00:56,920 --> 00:01:00,460
you'll be able to see what purchases
fit within your monthly budget.

17
00:01:00,460 --> 00:01:02,140
That's a simple example, but

18
00:01:02,140 --> 00:01:05,060
utilizing spreadsheets can help
you bring clarity, and insights,

19
00:01:05,060 --> 00:01:09,560
to decisions much more quickly than
if spreadsheets weren't around.

20
00:01:09,560 --> 00:01:12,670
Knowing how to use spreadsheets
will make you a more valuable and

21
00:01:12,670 --> 00:01:14,300
productive team member.

22
00:01:14,300 --> 00:01:16,270
That's not just in business either.

23
00:01:16,270 --> 00:01:19,480
You can actually use spreadsheets
to analyze gaming strategies for

24
00:01:19,480 --> 00:01:22,220
academic research, or administration.

25
00:01:22,220 --> 00:01:25,690
Unlike some other very valuable skills,
with a little bit of practice and

26
00:01:25,690 --> 00:01:28,290
learning, working with spreadsheets
is actually pretty easy.

27
00:01:29,330 --> 00:01:33,260
Let's open up a spreadsheet right now and
learn the basic format.

28
00:01:33,260 --> 00:01:36,470
There's a link to an example spreadsheet
that includes data on Amazon's

29
00:01:36,470 --> 00:01:39,350
2016 stock price in the Teacher's Notes.

30
00:01:39,350 --> 00:01:41,610
If you're unfamiliar with
how to use Google Sheets,

31
00:01:41,610 --> 00:01:45,030
we've also included a link to a video
with instructions on how to get started.

32
00:01:46,130 --> 00:01:48,410
Right now we're looking at a spreadsheet.

33
00:01:48,410 --> 00:01:50,960
You can see data organized
in a table format.

34
00:01:50,960 --> 00:01:55,720
A collection of columns going from
left to right of the screen and

35
00:01:55,720 --> 00:01:58,090
rows going from top to bottom.

36
00:01:58,090 --> 00:02:02,250
At the top there are column titles,
also known as data header rows.