WEBVTT 1 00:00:00.970 --> 00:00:22.269 William Rosener: Well, it's Dr. Rosner. Welcome back in this video doing how to create a spreadsheet using Google sheets similar to Google. Docs Google Sheets is a cloud platform. This technology lost people easily to share store and edit documents with various devices, and to collaborate in the connected age. Let's start by taking a look at what you learn how to create it, we'll go ahead and walk through it. 2 00:00:22.280 --> 00:00:41.060 William Rosener: So imagine we're running a little restaurant, and we want a little spreadsheet here to kind of help us track our sales. So we're gonna have various items, possibly on the menu price. How many of these items were solved every day. We'll use formulas to compute the weakness sales along with the total here, and then we'll go ahead and sort of chart here. 3 00:00:41.070 --> 00:00:44.240 William Rosener: But now that we don't want to do, let's get started here. 4 00:00:44.830 --> 00:00:49.909 William Rosener: So the very first section we want to do is going to go ahead and go to 5 00:00:49.940 --> 00:00:59.039 William Rosener: Google Com. You're going to press on your apps by pressing on these little dots up here which can take you to your Google apps, and you're going to press on drive. 6 00:01:00.600 --> 00:01:05.509 William Rosener: Okay, at this point, taking a look right here, here was the one I just got done looking at, 7 00:01:05.980 --> 00:01:08.279 William Rosener: and i'm going to come up here to new. 8 00:01:08.400 --> 00:01:11.520 William Rosener: The nomatures go on sheets. 9 00:01:13.680 --> 00:01:19.309 William Rosener: Okay, at the very top up here. I'm gonna simply type in my dollies. That's just an a one here. 10 00:01:25.880 --> 00:01:37.240 William Rosener: Okay, Then I want this to go to h one. Just kind of I'll come back and forth here so I can see. I want this information to be a centered in span from a one through h one. 11 00:01:37.250 --> 00:01:46.970 William Rosener: So i'm going to go ahead and highlight the cell a one, and just kind of keep kind of coming over here to h one, and I'm going to come right up here to format. 12 00:01:47.030 --> 00:01:51.159 William Rosener: We're going to go to merge cells and hit merge all. 13 00:01:51.730 --> 00:01:54.799 William Rosener: Then i'm going to go ahead and center this information. 14 00:01:55.140 --> 00:02:00.339 William Rosener: Maybe i'll make this a bold face and maybe even increase the font size a little bit there. 15 00:02:01.200 --> 00:02:05.799 Okay, next step is most. I have a little time here, so I need to get some data 16 00:02:05.860 --> 00:02:22.910 William Rosener: and input it there. So in the same era. As you found a length in this video, you should find some data. I'm just going to simply highlight this copy it. That was the control, c. Come back here. I'm going to position my cursor right here in a three and just paste. 17 00:02:23.940 --> 00:02:31.280 William Rosener: We'll go ahead and do a little formatting with this information. Actually, when we start up here we're going to put in weekly sales. 18 00:02:34.690 --> 00:02:37.259 William Rosener: There was a little dollar sign after that. 19 00:02:39.620 --> 00:02:49.819 William Rosener: Okay, So at this point let's go ahead and maybe change the film color on that. So i'm going to highlight all those cells come right up here. Maybe we'll make this ah kind of a light shade of blue, 20 00:02:49.990 --> 00:02:56.870 William Rosener: and i'm gonna highlight the various items on the menu, and we will see that with say green. 21 00:02:57.630 --> 00:03:14.169 William Rosener: Then, when I take a Look at this information. I want this format it as a currency with the dollar science and the highlight. That's B, four through B eight. I'm going to come right up here to format. I'm going to go to a number, and i'm going to come on down and choose currency. 22 00:03:14.920 --> 00:03:20.310 William Rosener: Then, if you want that, we could actually highlight all this data. Possibly you can get it centered, 23 00:03:22.860 --> 00:03:24.489 William Rosener: and it's probably a little or better. 24 00:03:24.500 --> 00:03:29.879 William Rosener: If you wanted to. You could even decrease the space in between some of these columns there. 25 00:03:30.200 --> 00:03:49.400 William Rosener: Okay. So the first thing we want to do is um have some formulas to compute the weekly sales. And what's that going to be? I'm going to add up all this case. All the Hamburgers that were sold on Monday, Tuesday, Wednesday, Thursday, Friday, and multiply by the price. Somebody come right out here 26 00:03:49.410 --> 00:03:50.680 William Rosener: the sum, 27 00:03:51.370 --> 00:03:55.280 William Rosener: and I'm going to simply specify C four. 28 00:03:56.520 --> 00:04:01.540 William Rosener: I can see It's kind of uh give me a little feedback there. Call on G, 29 00:04:02.080 --> 00:04:04.510 William Rosener: and that's going to be G four. 30 00:04:05.220 --> 00:04:21.300 William Rosener: Then I will take that, and i'm going to multiply it by the information in B. Four. So i'm going to add up all the Hamburger sold Monday through Friday. Multiply it by the price, three hundred and ninety-nine, and that should give me one thousand five hundred and forty four dollars there. 31 00:04:21.649 --> 00:04:29.210 William Rosener: I I saw it right there, but if I want, I can just simply I could repeat that for all the other ones I could write for them. There, 32 00:04:29.380 --> 00:04:34.289 William Rosener: I can just let this case go with sheets. Do it for me. Position my cursor over the film 33 00:04:34.300 --> 00:04:43.169 William Rosener: handle, or it turns to crosshairs, drag it on down. And what I can now do is come up here and take a look. Okay, It would turn up at some enough C. Eight 34 00:04:44.010 --> 00:04:50.099 William Rosener: through G. Eight, and then multiplying it in this case by Ba. Which was two hundred and forty nine. 35 00:04:50.450 --> 00:04:51.470 William Rosener: Okay. 36 00:04:51.530 --> 00:04:55.379 William Rosener: So that was the first part. Now let's get some a daily sales. 37 00:04:57.640 --> 00:05:11.069 William Rosener: You know. What I want to do here is I want to add up in this case how many were sold on Monday, Tuesday, etc. There. So i'm going to simply position my cursor right here. I come up here to some, 38 00:05:11.370 --> 00:05:13.940 William Rosener: and i'm going to go see for 39 00:05:14.390 --> 00:05:15.790 William Rosener: call in, 40 00:05:15.910 --> 00:05:17.390 William Rosener: see Hate 41 00:05:17.770 --> 00:05:18.900 William Rosener: and 42 00:05:18.910 --> 00:05:22.280 William Rosener: those sheets was anticipating exactly what I wanted to do. 43 00:05:22.290 --> 00:05:37.569 William Rosener: And now, just like we did a second ago. I can position my cursor on the fill handle and drag that on over, and I can take a look again. For the whole week There was three thousand seven hundred and four dollars there, and i'll tell you what Just make it consistent here. 44 00:05:37.620 --> 00:05:41.219 William Rosener: I'm going to come up up right up here and get that centered. 45 00:05:41.410 --> 00:05:57.769 William Rosener: Okay. So, taking a look here, here's what we've done. So far is this a top part we've used foremost. Make sure you use formless. If you want to get full credit there am I gonna That's the whole advantage that you some spreadsheets, If I come along and change one of these on which one in front of it. 46 00:05:59.310 --> 00:06:02.979 William Rosener: I can now see. The week with sales has increased 47 00:06:03.070 --> 00:06:04.600 William Rosener: along with 48 00:06:05.900 --> 00:06:08.199 William Rosener: at tables for that week. There. 49 00:06:10.850 --> 00:06:15.009 William Rosener: Okay, okay. Next step. What we want to do is chart that 50 00:06:15.090 --> 00:06:20.510 William Rosener: and all I want to chart is the item, and Monday through Friday 51 00:06:20.780 --> 00:06:22.419 i'm going to come right back here. 52 00:06:22.510 --> 00:06:28.579 William Rosener: I'm gonna highlight in this case A three through a eight. 53 00:06:29.290 --> 00:06:31.959 William Rosener: I'm. Now going to hold the control button down 54 00:06:32.560 --> 00:06:34.380 William Rosener: It's a grab, 55 00:06:34.670 --> 00:06:47.430 William Rosener: C three through G: Eight. Okay. So i'm going to grab this item, this information. Hold the control button down and grab this. Now, i'm going to come right up here to insert. I'm going to go to a chart, 56 00:06:48.920 --> 00:06:59.060 William Rosener: and there's various charts now. I'm just going to use the column chart if you wanted to take a look at some of the other items. You can come right over here, and here is the one we'll be using just a regular column charm, 57 00:06:59.520 --> 00:07:03.250 William Rosener: And at this point. I'm going to go ahead and try and drag this on down a little bit, 58 00:07:03.640 --> 00:07:06.770 William Rosener: and i'm going to challenge you just a little bit. Here, 59 00:07:06.820 --> 00:07:09.370 William Rosener: gentlemen. Ah, Megacadan, 60 00:07:09.510 --> 00:07:14.779 William Rosener: right here is where you're going to change the title. But let me see if you can do two things. There. 61 00:07:15.430 --> 00:07:18.799 William Rosener: One is uh get it change the the title, 62 00:07:18.810 --> 00:07:20.080 William Rosener: and then move 63 00:07:20.140 --> 00:07:27.289 William Rosener: rather than having Monday, Tuesday, Wednesday, Thursday. Kind of up here to see if you can get that over there on the right. I don't think that should be too hard for you there, 64 00:07:27.300 --> 00:07:35.560 William Rosener: so change the title, and then get Monday, Tuesday, Wednesday over on the ride, and I think we start clicking a little bit. There, you'll quickly find a way to do that. 65 00:07:35.570 --> 00:07:49.699 William Rosener: Okay, let me walk through the final steps on this one, and that's going to be first of all, I'd come up here. Why, don't you put your last name, and actually the go back and actually put in your last name, and then possibly assignment thirteen 66 00:07:49.720 --> 00:07:52.580 William Rosener: actually. Now, this one's assignment twenty-one, 67 00:07:53.140 --> 00:07:55.470 William Rosener: Okay. And 68 00:07:55.790 --> 00:08:16.000 William Rosener: then we're going to come up here and do two things here, maybe. Why, don't you download a copy? And Microsoft, Ex. I just say you've got to advance. You've got a backup on your hard drive, and you could even possibly upload that to the website. But what I really want you to do is come here to file and hit, share, and go share with others, 69 00:08:17.080 --> 00:08:34.420 William Rosener: and when I create these I purposely create them. As Paul rose there that way, I can show you It's like, Okay, Here is what you want to share with. You. Want to share this with Rosner, R. O. S. The N. E. R. And N. She. Okay, Edu: So you're going to highlight that 70 00:08:35.090 --> 00:08:44.429 William Rosener: you're gonna hit the send button, and I should have showed you that copy. But let me just go right back there. Now. I'm gonna come right back. Go to file, share, 71 00:08:44.940 --> 00:08:59.560 William Rosener: share with others. And right down here is the copy link i'm gonna and copy that, and that's going to copy the link which is shown up here in to your clipboard. So now, when you start working on your website 72 00:08:59.570 --> 00:09:05.490 William Rosener: where you're going to upload your assignments, what you're going to do with this assignment is just paste this Url, 73 00:09:05.500 --> 00:09:09.659 and there's going to be a video there on how to upload your work, and i'll walk you through that. 74 00:09:09.950 --> 00:09:20.670 William Rosener: So again. Probably the big thing here is to make sure you've used the formulas. When you create your chart you're going to highlight the information at column, a 75 00:09:20.680 --> 00:09:30.820 William Rosener: hold the control, button down and get the information and see through G to create your chart. And then finally, when you're finished here, make sure you share that 76 00:09:31.570 --> 00:09:47.079 William Rosener: and make sure you share that with Rosner at and the showcase, Ed, you? And then again, you're gonna hit the copied link when you start when you want to upload this to your website. And again there'll be a video that walks through that, anyway. Um, i'll catch you next video next time by.