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.