Google Sheets: White Belt Beginner | Miguel Echeverria | Skillshare

Google Sheets: White Belt Beginner

Miguel Echeverria

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (32m)
    • 1. Introduction

      1:03
    • 2. Part 1

      8:13
    • 3. Part 2

      5:56
    • 4. Part 3

      6:25
    • 5. Part 4

      7:35
    • 6. Part 5

      2:30
12 students are watching this class

About This Class

If you have been looking to improve your Google Sheet skills then this is the course for you. I will take you through building a personal expenses sheet and along the way you will learn about formatting cells, creating functions, autofill, alternating colors and many other beginner tools. Consider this equal to earning your white belt in preparation for earning higher belts in Google Sheets. I hope you enjoy this course and come back.

You can also try something a little more advanced by clicking here.

Transcripts

1. Introduction: everybody. My name is Miguel Exteberria, and today you are going to earn your white belt in Google sheets. Okay, this is a great intra lesson learning Google seats if you've ever wanted to, now is the day you will use them in your lives and your business. It's really a great skill to know how to use. And during this course, I'm gonna take you through all the fundamental things you need to know so that you'll be a white belt, right? And later on, you'll want to come back and get a higher belt. Be work proficient and Google seats. So please follow along the video. Enjoy. I would do is I'm doing in the video. Have my video going here and Google Google Drive going the other side. So, um, thanks for for staying tune and hopefully enjoy this course and you'll see more 2. Part 1: Okay, let's go ahead. Get started. I really encourage you to follow along. They don't just watch, but But get involved and you'll learn a lot better that way. So the first thing we want to do is how do we get to Google Sheets? Well, you could just literally google it. Google sheets. Whatever Web browser you're using, there is Google, chrome or safari. And whatever it is, you're gonna come up with the first hit Google Sheets. Okay. And then you're gonna want to log in. You're going to need a Google account. Um, the best way I honestly found to get the Google seats. If use chrome is simply open a new tab and come over here to Google drive and from here, go to new. Who knew she? Okay, here's Google sheets. Awesome. All right. Just so you know, there are a bunch of cells, right? That's how this works. These cells are used to different formulas, different things. Um, here's how you rename a file. Go ahead and rename it right now. I'm gonna call my my expenses. Remember, this is all about creating an expense sheet for your personal budget for your own personal life is to list all of your expenses, and we'll we'll do some stuff with those numbers. Um, okay, So remember these are cells. This is B two right here. This is see to anyone writes like playing battleship. So case I say go to D four. Well, the whole right there get started. Goto. So a one. Let's type my expenses. This is going to be the title of our of our you will she We're gonna make it kind of styled into our google sheets, so we're gonna make this little bit nicer. Do you notice when I typed it, um, it ah, my cursor is gone Once I clicked away. Okay, so if I wanted to go back into this, I need to double click it to get back into it so I can continue typing something, you know, the year or something. But if you want to completely replace that, you just start typing over the top of it. Um, it go takes over whatever you're typing. So that's how you go in and out of the cell. Good to know. All right, go ahead and find a nice spot. I'm gonna go play fair display But if you want to find your own, that's fine. You can even search more funds. I'm gonna go this one. Okay, Now they found a good fun. Please go ahead and change your farm size to 24. All right, You notice that it increased the height of this row to fit the the height of my text, so really convenient. Okay, um, it's going to change the color of this now so far in a nice, beautiful color. I'm gonna go with his blue right here, but held her over its his dark, cornflower blue Awesome name. You'll right? Don't do this, but I just want to show you something quick. I'm gonna change the cell color. I'm gonna change it is to a beautiful yellow. And you'll notice that what's happening is it's not flowing all the way across the word because it's really only happening and sell a one. Okay, It's only happening in that cell, so we'll talk more about that later. But just know that this is actually, um, flowing longer than the column with only just all that later. But go ahead. I'm gonna undo that. That brings up my next point toe. undo. You can undo and radio and learn the shortcut. It will tell you what it if using, Mac, it's ah, Command Z. These windows, it's controls the very useful. Okay, the command z m. And I do that. So if you ever get stuck, just rewind and you'll be just fine. Yeah, Let's go ahead and add in our expenses. Um, Item column, heading someone type item. Okay. And I'm gonna list all the items. Well, I'm only going to a few if you want to add more. That's fine about food, mortgage, things about that. More goods. Um, not personal cell phone, by the way. I'm just pressing enter and it's moving my myself down one every time I press return and entered tain. Okay, we've got all of our We got a column heading here. We have all of the different, um, items in here. What's that? Another column heading right here. So click on Selby one and go ahead and type. And the month So January and press return. Okay, go ahead and click back on January right here in b two. And one thing I want to point out real quick is this little do hickey thing. I think it's called the Okay. Click back on Selby, too. I just want to point something out on this cell. You know, says I move my mouse around. It gives me different things, so you'll see the hand the hand represents, like grabbing and moving it. Okay, The arrow represents, like, selecting something. So if I wanted to select, they could be to all the way to be nine or something. You click and drag from the middle wherever the arrow is pointing, and you can drag him out and go any direction you want. Okay. And then one more thing, this little cross hair thing. This is kind of your auto fill, but really useful. So it actually recognize that I'm typing January and so knows I'm doing months. So if I click and drag to the right or straight down, it's gonna auto fill the months it recognizes patterns. So that's awesome. But spreadsheets. So if you would right now, actually drag your auto fill button, continue that all the way across to January. All right, Karen, to December. Okay, um, one thing I want to point out don't do this, but I just want to show you. Let's say that type of one. And I tipped to here, and I wanted to keep going with all the way, like 100 or something. So the auto fill is super useful in that it recognizes patterns. So in this case, I want a quick and drag across these two cells. And now, if I drag my auto fill and you can try this if you want, it automatically recognizes a pattern. 123 So, just depending on what you're doing, if you want to listen five all the fives you're teaching your kids how to do multiple casing to chart or something. Anyway, I just want to point that out real quick. Me delitos to delete something out of the cell. I usually don't quick, innit? Click on the cell and President Lee on my keyboard. Okay, already, that is the kind of the first part. So stay tuned for the next part. We're gonna talk about resizing columns and rows and stuff like that 3. Part 2: All right. Moving on now. So let's talk back about this. My expenses real quick. So right now it's in. So a one, right? We want to actually be centered across our whole our whole expenses. She'll look nice. So we're gonna have to merge themselves. So this a one. We can actually merge it with all of these other cells. Okay, That will allow us to to center and make it look a little better. So if you would right now, old on your mouse and click with the arrow in the middle, Quick and drag from a woman all the way across Teoh em once all the way across. Kidding. When President merge sells this button right there. And by the way, if you can't see that, it's because you're screen might be squished in right. There's more stuff. We give yourself a nice big screen so you can really work with that. You know, we go ahead and go ahead and merge that cell. You'll notice its giant one giant cell now. Okay, The the expenses things over here weaken. Center it. Let's go and do that. Click this little a line of bun. And because center Okay, Looks much better now it's starting to come together. Um, all right, now let's talk about re sizing the row in the combs. I can resize column you can simply putting amounts right in between each one of these letters and it becomes like an arrow. You see that? So if I click and drag, it can move. It is big that want So no, a one is is a too much bigger a one is this whole thing to seeing of it? A two is now this wife. But I'm gonna move that back And let's say I didn't want it to go all the way over to January. Way over there, I just wanted coming right there. And then I want to move that one right? Here's the problem. Like they're all gonna look a little bit different. But that doesn't look pretty, right? We want these things to it. Kind of identical. What we could like this and the drop down arrow and click Greece eyes call may say, Oh, it's taking that wolf. We could re size and be all right. Coming over here and playing in number, right? That would take too long to do all of these. So here's a quick way to resize all of the columns. You gonna hold down your mouths on a this little column, heading a in click and drag all the way across to this one. Okay. Now, wherever you put your mouse in between any of these between H night, for example, I'm gonna click and drag my mouth. You notice it will do them all at the same time? Hey, saving you a lot of time. So if I double quick, we'll actually find, um, the width of all of them a making those exactly. But if I want it all to be the same, you move them all. So I want them all the same. I wanted at least to go past entertainers. I'm gonna come in here and go past that word entertainment so they're all gonna be the same . Whip down just like that. Okay. Looks awesome. You could do the same thing with the row. Okay? He could adjust the height of those which you can if you want. You don't have to. You can say you make a little bigger. Okay? I'm gonna move that back. Actually command Z community All right, let's plug in some, um, numbers in here, so we're gonna be putting dollar amounts, right? So, I mean, all of these will have dollar amounts. The cells don't know that. You're gonna put a dollar here until you tell it. This is going to be a dollar amount. You don't notice up here. This is the This is the formatting option. FreeCell. So I could easily just quick format as currency or percent. Aiken, decrease the decimal place. Increase the decimal place. I can also other formats like, is it a number that a percent scientific accounting? Financial date time? Like if you're doing with time and dates, you want to use this stuff. So and there's more options as well. But in our case, we're actually just getting use currency. So going is quick down, which would've been the same is clicking that button. So but here's the problem. I don't wanna have to do this individually, right? Your use the power of selecting multiple things at once, so I'm gonna actually have you select. What do you think exactly? Be three all the way through to, um and okay, so all of that needs to be selected now, just by pressing that button, it's all going to be dollar signs. I mean, you show you and we're gonna plug this the first ones in together. So, um, to 80 is the 1st 1 100 the 2nd 1 to to six 29 100 35. Going to plug these in and you composite so you can get all these number. Then make sure your numbers match my numbers. I'm going to just go all the way here. Not gonna go all the cross. I'm just going to Okay. It's not critical that they all match, but at least go all the way to march. You don't need to go any further. I just want to make some points with January, February and March. Go ahead. Um, that's part of this videos. And next we're gonna talk about functions 4. Part 3: all right. The next thing we want to talk about is functions gay, which is probably one of the most useful parts of a spreadsheet. I think that's one of the reasons you want to use a spreadsheet. Um, but before we get into functions, let's just style this up just a little bit. So what I want you to do right now is it gonna select from a to quick and drag amounts all the way toe em two. So the months just give that a bold so you could press command be or you can come apparent Busby for both. Okay. Down here on selling and I'm That's right. The word total's okay. You'll notice it's a line to the left, which it kind of don't like. So click on here. Let's talk about aligning. If I come over here to this button right here, it's gonna allow it to a line to the right, which these are other lining things. We'll get into those a little bit later. So Okay, now that that's a line to the right, let's go ahead and put a line all the way across this thing so you can select from l nine all the way to and nine. So we're gonna put a little border things up here. You're pricing this border things. Okay, What it does that basically draws a line wherever you want on the border of that. So Okay, so in this case, if I click this, it would put a border all the way around each one of these cells, or depending which, when you click on this would be the inside of it. This would be the middle. Um, anyway, just depend on which one you click, what it will do. The one that we want to do right now is the top one. This guy right here. So go ahead and click it. You know, notice it is. Put a nice line on each one of these cells, all the way crossed. Click away. You can see that. So it kind of gives it a better look for an expense sheet. Okay, Now, let's go ahead and plug in a function. So in Selby nine right here, let's add in a function. So let's look over here real quick and some of the functions this right here is the function symbol. So good and quick on it. One of the most common ones or some average count maximum. But there's all sorts of functions, and I encourage you to kind of look through here. I mean, there's this endless amount of amazing things. Everybody has their favorites. It seems like once you figure one out, you just love using it. But we're going to start with some simple basic ones this time. So let's actually just post some quick it. If you look over here, it says, equals some and in parentheses, it's asking you, what do you want to some? Okay, what we want to some is all of this, right? So it actually weaken is click and hold down our mouths. Did you see how it this is B three, which is right here? And then this This corn, it means through b eight, which is this cell. Look, it even gives you a short answer right there. But as soon as I press return on the keyboard, it will plug that function right there, which is really, really cool, because these air actually live now. Basically, if I make any changes to one of these numbers, this is gonna update. So like Let's say I actually put I meant to put 34 here. You notice how it changed from 14 41,091 other four or 95. So I'm gonna do that. Command Z. Okay? You're probably thinking your head. Okay, so I got to go through each one of these, but you know the answer. That right. The auto filled one. Super cool. It's actually just, um, that's actually is click and drag away. Cost 2 December 000 Because it's adding all these upright. There's nothing in there where there's stuff added them up. And it the spreadsheet was smart enough to realize that we're talking about different columns here. Okay, So what I want you to notice up here now is this functions bar. So if I click on it, she was showing me the function. It's in that cell. So that is the same B three through B eight. If I click on this one C three to see a, which is all that click here is is de three through D A's all of that. So it knows I need to adjust the calm. Really cool. Okay. Just because it will look good. Let's go ahead and bold this part of it so quick from a nine all the way crossed to there. And press command or control Be or command be on your computer or President. Bold. There we go. Looks pretty, right. We're gonna add some more stuff, this expense see sheet to kind of show off some other things you can dio. All right, so let's go ahead and move on a little. We're gonna add a couple more things to this spreadsheet. So move your now it's down to a 12. Good. And clicking this box and type the word item and then press tab and take planned because tab average tab difference. Ah, I asked Have been master one lowest. Okay, let's go ahead and bold thes. So click all those and bold does look nice and pretty. Okay, let's go ahead and we're gonna add in our items here. But we're gonna cheat a little bit because we're smart now and we're not gonna re type all of this. That wouldn't make any sense. We're gonna use the power of ah functions. Really? So if you would in this cell type equals and just click this button right here, a three like it tells you what it's gonna put in there and go and press return. You notice there's a function here. It's a three is the function which is really basically just looking up. What's in a three. And I'm going to click and drag this little auto fill button down to one more entertainment . Look at that automatically filled in all of our stuff. We didn't have to type it again. Thank goodness. Right Case, the next part we're gonna talk about some more functions and dive in a little bit deeper on some more formatting, so 5. Part 4: Okay, We're getting close here for this first. All right, let's go. And continue on. Let's come in here. We need to plug in a few numbers together here. So remember, this is kind of expenses. She is showing us how much were planning for every month and how much we spend in all of that. So let's put in how much we plan for every much we plan in 300 boobs. One things wrong here, right? It's not putting in dollar. We love to see dollars. Where? Those dollars. So go ahead and fix this. Go from here to here. Put dollar amounts. You can figure it out. Going try. Good job. Okay. Exactly. And by the way, I don't need to do anything. I can actually just go in and press the dollar sign. And I did talk to you about decimal points. I do have. I actually don't have anything in here that really has anything to do with decimal points. In reality, these would have changed amounts, right? But if you ever wanted to get rid of desperate, increase your dick decrease, you can just increase increase. Well, I'm gonna go ahead and leave the change there. All right, from mortgage from 800 200 for personal, 30 for pets, 100 for cell phone and 50 for entertainment. Okay, let's go ahead and plug in some awesome functions. So let's start with the average one. So this time we're not going to go up to their to the cheat thing up here, right? We could plug in. We're gonna go click on it. But you can also just type it. So is click here and type equals and start typing of the word average, hoping that there's a formula called average. Have you notice it starts to bring up a list of things and whenever you're not sure, usually just hover over it and kind of read a little short description, a miracle, average value and data set. Ignoring text. That's it. Right there. Go ahead and click on it. Well, what do we want? Average. What we want to average how much we we spend on food every month. Yeah, I would be like the entire year. What's what's the average amount that we spend on food? So the way we can do that is actually just come up here to be three and click and drag your mouse and all the way across. Right? By the way, if you ever get stuck, his press escape, okay, don't keep clicking on things that kind of gets create just press escape on the keyboard and it'll jump out of this formula. But now that we have that formula and they're going press, we turn there. That's how much we spend all year so far average. Go ahead and click the auto filling. Drag that down Now. It did eat and every one of our our items here I would buy difference. Going type equals. All right, So what do you think? What do you think it's gonna be to get the difference? Okay, it's gonna be planned, minus average. So it's actually just click here and president minus this cell. So this cell minus the cell press return. Very good. Click here and drag this one out of Phil down. Okay. Looking good. So far. So you can see they were overspending on personal. We've planned 200 but we actually spend to 18 on average, so well, we might to readjust in our lives of the highest. Well, it's good to have equals. You probably noticed up here at this former nothing. One of the functions. It was called Max Smart. So if you come up here and type Max, Okay, go and click on it. Que the max of what? Right? That Max of all of these, all the food. So we can also just type this in, just so you know, if you know the name of the cell. So I know that this is B three right here, and I know that this one, um, se I know that this one is m three. I could actually plug that in. So be I'm gonna do in Capital B three through. Well, down shift and press the semicolon B three through m three. And I like that. Closed the print that seat, actually. Don't have to you in this press return from there, but can close that out. Press return. Okay. Very good. Quick. Here and drag this thing out are awesome. Last one equals this time it's men said good to have in my hand and going click. I just want to show you a couple things on here real quick. Um, this button, this is the most valuable button whenever you're not really sure how to use a formula. And you like reading through this and it's not quite meeting making sense. You click on this, and what will happen is a little helping will appear. It will tell you all about the men function. You can search whatever you want, but gonna tell you how to plug it in notes. See also examples super useful. So get used to getting help. Okay, I use it all the time. All right, Now it's men. And you remember that The ranges from B three through M three in turn. So quick I'm here and drag down, down. Done came folks, we and completed this thing nearly gonna do one last thing here. Let's stylist that this makes it hard to read when you're reading across a lot of information. Your eye has a hard time figure out how to follow this line all the way across, so make that a little bit user friendly and easier. We're going to, um we're gonna change the colors on these little bits. So what I want you to do is select from a to from here. All of this will do this 1st 1 first this top part all the way to and nine. So you're gonna select all of this? Okay, with that selected, let's go ahead and right here to this fill color. Okay, If I click on one, it is It's gonna fill all of the cell the same color. But if you look down here, there's a thing. This is alternating colors. So good and click on that. And you see, it's already started. It is putting in some nice colors for us, and you can change it, right? We have a header. It brought up this thing over here. So if I click Header, uh, fetching this off that it will make that one darker. But we do have header, so let's leave that on. We don't, um Linguine quick. Whatever color you want, you can even make your own coast, um, color. So find a nice, pretty color. Think I'm just gonna go with this one right here and president and click away we go pretty looks, do the same thing of this one quick and drag across the whole thing. Had another alternating color and should do the same one now through different but done. There you go. 6. Part 5: Okay, You've done a great job. So a couple things I just want to point out for you. I'm first of all. Since these are all formulas that air in here, right? Any time I plug in a number, and here it's gonna automatically change this stuff. So if I come over here and I'm in April now on I'm I spent $231 press return. You'll notice it changed this. And it changed Basically everything that the formula is affected by. And anyway, that is all. That's pretty cool, right? It always step today. I'm gonna delete that. Okay. Also, one thing I want to point out if I got a file and let's say I want to print this thing for so amusing, right? She was quick. File print. Okay, there's the print settings. You can change it from landscape two. Portrait. Um, you can change the size of the paper, so it's kind of long. I'd probably stick with landscape. It does keep all this border around it unless you come over here and turn off show grid lines. Right. And it turns off the good lance looks kind of better without it right. And yeah, you could make some adjustments. You can center on the screen. Um, so it's And on the screen on the on the paper. What, depending on, whenever you do normally, you to send it horizontally and your president X and you can print this thing out looks really pretty, But it on your fridge, I'm gonna press cancel here. Also, one thing on a point out as you can download it as pdf's a Microsoft Excel a fuse that, um, another thing here version history. If you go toe if you ever mess up or you need to go back for some reason, you can go see your version History and see every change you've made to that throughout working on this whole thing. Okay, saved it from the first day. Started it. If you click, the drop down arrow will give you more details. You can kind of go back in time like really cool. Thank you. Then you can just click, restore there's version and will restore it to whatever you're working on. I'm gonna go back here not going to store anything. So that is done. Now we're all done at this part this is gonna lead into some more advanced things, more things that we have not covered. So continue on with the lesson is good luck.