1
00:00:00,690 --> 00:00:04,150
Now that we've got some of the basics
out of the way, let's jump in and

2
00:00:04,150 --> 00:00:06,200
start working with the spreadsheet.

3
00:00:06,200 --> 00:00:09,020
In this video,
we'll work through an example spreadsheet

4
00:00:09,020 --> 00:00:13,200
that is a list of all transactions
from a growing retail network.

5
00:00:13,200 --> 00:00:16,680
You're being interviewed by
the owner to help run the operation.

6
00:00:16,680 --> 00:00:20,540
As a test in the interview process,
they sent you a simple spreadsheet and

7
00:00:20,540 --> 00:00:22,920
asked you to help them
understand the information.

8
00:00:24,230 --> 00:00:27,710
>> Clearly, your potential new boss
didn't do much with this file.

9
00:00:27,710 --> 00:00:30,420
Let's organize it a bit so
it's easier to work with.

10
00:00:30,420 --> 00:00:34,600
First I'm gonna expand all the columns so
that I can see the text in each cell.

11
00:00:34,600 --> 00:00:39,649
You can do this by manually clicking and
dragging columns out like this,

12
00:00:39,649 --> 00:00:42,810
or you can double-click the column header.

13
00:00:46,477 --> 00:00:51,124
Note, you can also select All Columns and
double-click the top right column

14
00:00:51,124 --> 00:00:54,930
header and it will expand all
columns to fit all text, like so.

15
00:00:58,393 --> 00:01:01,123
However if you manually adjust one column,

16
00:01:01,123 --> 00:01:03,939
it will make all columns
selected that size.

17
00:01:10,446 --> 00:01:13,283
Okay, now that we can see all of
the data in each cell clearly,

18
00:01:13,283 --> 00:01:15,880
let's calculate some basic info.

19
00:01:15,880 --> 00:01:20,849
Before doing that I'm going to do
something called freezing the panes so

20
00:01:20,849 --> 00:01:24,198
that the cells don't
change when I scroll down.

21
00:01:24,198 --> 00:01:27,222
I'm gonna drag this bar
here one row down and

22
00:01:27,222 --> 00:01:31,670
now you'll see that these cells
at the top are stuck there.

23
00:01:31,670 --> 00:01:35,630
So when I scroll down
they're always visible.

24
00:01:35,630 --> 00:01:38,110
So we're gonna calculate
some basic info now.

25
00:01:38,110 --> 00:01:40,920
For example what were the company's
sales over this time period?

26
00:01:41,970 --> 00:01:47,290
I'll go down to the bottom of the tab and
then use the sum formula.

27
00:01:48,450 --> 00:01:53,973
I click this cell, enter equals

28
00:01:53,973 --> 00:02:00,240
sign SUM, then parentheses.

29
00:02:00,240 --> 00:02:02,880
It asks us what data we want to sum?

30
00:02:02,880 --> 00:02:06,540
The sales figures in column C
are what I'm interested in.

31
00:02:06,540 --> 00:02:12,949
So, I can select the cells with my mouse,
Like so,

32
00:02:15,783 --> 00:02:19,799
And put an end parentheses and
click Enter.

33
00:02:21,992 --> 00:02:25,872
Google sheets calculates
the total amount of sales for

34
00:02:25,872 --> 00:02:29,000
this time period which is $25,205.

35
00:02:29,000 --> 00:02:32,160
Let's talk through the notation
of the sum function.

36
00:02:32,160 --> 00:02:37,576
If you look up here in the formula bar,
we can see =SUM.

37
00:02:37,576 --> 00:02:43,176
Parenthesis C2:C88,

38
00:02:43,176 --> 00:02:48,220
C2 is this third column C and

39
00:02:48,220 --> 00:02:53,990
2 is the row up here the first
row that I wanna start summing.

40
00:02:53,990 --> 00:02:59,911
So C2 means this in
the context of that formula.

41
00:02:59,911 --> 00:03:06,820
C88 is the last cell in this column
that has data on sales for this period.

42
00:03:06,820 --> 00:03:09,650
Why don't you sum the figures
in this column yourself?

43
00:03:09,650 --> 00:03:11,020
Go ahead and pause the video.

44
00:03:11,020 --> 00:03:11,520
I'll wait.

45
00:03:12,880 --> 00:03:15,320
Okay, were you able to do it?

46
00:03:15,320 --> 00:03:16,710
Let's just walk through it again.

47
00:03:17,770 --> 00:03:22,256
I'm gonna delete when I put here
initially and then do it again.

48
00:03:22,256 --> 00:03:26,280
I'm gonna put equals then sum,
parenthesis.

49
00:03:27,410 --> 00:03:33,808
I'm going to select all the sum or
the cells that have dollar values and

50
00:03:33,808 --> 00:03:41,520
then Close the parentheses and hit Enter.

51
00:03:43,510 --> 00:03:47,480
Sum is one of the most
common functions you'll use.

52
00:03:47,480 --> 00:03:49,135
We'll dig into it more later.

53
00:03:49,135 --> 00:03:53,685
In other functions as well, but for now
why don't you try and calculate an average

54
00:03:53,685 --> 00:03:59,635
in median sales prices as well,
using the average and median functions.

55
00:03:59,635 --> 00:04:02,555
Give it a go yourself, and we'll show
you how to do it in the next video.