 Here we go. So if you are ready to rock and roll, here are some links. There are two links here. They're both bit least. They, um, there are some uppercase letters. So you need to be aware of that. Alright, so here we go. We're on the sheets. We're on the sheets tips. We're going to bend the data. What is sheets? Sheets is a spreadsheet. Okay, so those of you that work with Microsoft, you're familiar with Excel. Same thing. Exactly. Almost to the, the minuscule little data points. Same thing. Yes, whatever you can do in Excel, you can do in sheets. Can you do it the same way? Heck no. They're different. Okay, they are different. Google sheets is also an app that you can install on any tablet or any phone. I don't recommend you do that because it is really, really small. You can do all kinds of things with sheets. And for those of you that aren't familiar with forms, everyone look up here or look at me. Forms is the sidekick to sheets. Everyone thinks sheets is this, or forms is this great big monster and it's, it's the big brother of sheets and it's actually not. Sheets is the big brother to forms. So when you create a form, their responses are going into the form, but all of their answers can also be put into a sheet. So everything, every quiz that you create, every data set that you have that you're collecting from people. I don't care if it's a poll, or it could be, what do you bring into the potluck in six months? What are you doing for this? What are you doing for that? How do you, what are your opinions on this that are the other thing? Upload your files, do all of this stuff. That's forms, but it all goes into a sheet. So all of the information from your form goes into a sheet. You have to know how to work with the sheets so that you can manipulate the data that you're collecting. Don't just look at the form for the data. You're going to get so much more functionality out of the sheet when you collect the data in the form. So just remember that sheets is the big brother forms is the little brother. Okay, it's the sidekick. So some terms to know, you have to know these terms. Some of, for those of you that work with sheets or you work with Excel, you already know these bear with me. We've got to get everybody up to speed. You have to know what a cell is. You have to know the cell range, what a cell range is. You kind of have to know what a chart is, if you're going to be working with charts. Okay, all sheets, and I'm going to open up a new sheet before I get to the sheet tips. All sheets have cells. So when you click in a sheet, click this little square thing that I when I click it becomes a little square. This is a cell and it's in line with a letter, which is a column and a row. So this cell right here is at B3. You have to understand that so that you understand the formulas that you're going to be creating. So this right here, this is B3 and I'm going to shade that so you see it a little better. Okay, this would be C3 right next to it D3 right next to that. Okay, in the top of the most corner we've got a one. So it's really simple, but you need to understand that. Okay, so we've got cells. This is a cell. B3 is a cell. The entire row would be the row three. The entire column would be column B. So we've got cells, rows and columns. Okay, what else do you need to understand? You need to understand that everything that is put into a sheet is data. Everything that is in a sheet is data. Okay, so even this one little cell right here that has B3 on it, that is data. I don't know what it means, but it's data. Sort. That's just, you can go from A to B or A to Z, I'm sorry, A to Z or Z to A. So sorting is something you need to understand as well. Format. We all understand format. Even spreadsheets have a format function. So I can take this cell right here and I can make it bold. Okay, you can't really see it all that much, but I can make it bigger. Okay, so that's part of the formatting. There's a lot more you can do on a sheet with format. We're going to cover this in a little bit. By using the format menu, you can do all kinds of things to the sheet that you can't do in a Word doc, that you can't do on the slides. So there's lots of functionality here with format. So just some words that you need to understand, read over those, get them in your head because I'm going to be saying them. So if you're not quite sure what I just said, what does she mean by format? Well, just click on slide four and look at that definition. So here we go. We're going to have some fun now. We're going to open a new sheet. Don't do it yet. There's two ways to do it. Actually, there's more than two ways. There's many ways. There's two methods, I should say. There's a conventional method and unique methods with an S. Okay, the conventional method, most of us know. And if you're new to drive, you might not know this and that's okay. We're going to, I'm going to show you this if you want to follow along. Feel free from the Google window. I know I'm signed in because I see my little avatar right here. There's a little tiny person right here. I see myself. You might just see a letter. And if you just see a letter, that's okay. As long as it's your letter. If your name's Jean, it should be a J. If your name's Anthony, it should be an A. Okay. So just make sure it's you. And then right next door is a waffle next to in the waffle. You're going to see drive. Alright, so that's one way to get to drive by using the waffle. It'll be with you on any Google tool. Click on the waffle and you can go to drive or I don't know. I kind of like typing. So I just type drive.google.com and enter. So go to drive if you've never opened a new sheet before. We're going to click on the new button. This is the conventional way to open a sheet. I'm going to click on new and you can see because Google Sheets is one of the top three apps. You can see Google Sheets right here. Now there's a couple things you can do. And you might want to look over if you already know how to do this. So next to Google Sheets, you're going to see a little arrow. If you click on the word Google Sheets, it's the same as clicking on blank spreadsheet. Same, same. But from here, you also get the option from a template. Just wanted to let you know that I'm not going to do that. You can do it if you wish, but then you're on your own. Don't ask me questions. Okay. I'm just going to click on Google Sheets and by the being about a boom, wait for the magic. The first thing you should do when you open up any new file on Google is to title it. So where it says untitled spreadsheet, just type something in there to let you know what it is. Okay, because Google doesn't care what you name this. You could leave it untitled spreadsheet. You could end up with 30 untitled spreadsheets, which when you go and look for that spreadsheet that had all of the quizzes in it, you're going to have to play a hard time finding it. This up here in the Omni bar, that is actually the name of the file. That's Google names the file as soon as you hit new spreadsheet. Okay, so you need to make sure that you title it something that you're going to remember because I can guarantee you you are never going to remember this big long URL that's up here in the address bar. Alright, and even if you're on Safari or Explorer or Firefox any of the other browsers that big long link up in the address bar that is actually the name of your file. Okay, so title it something you're going to remember. Alright, so this is one way the conventional way to create a sheet. There are a bunch of other unique ways. So I'm going to go back to the slides that get the next slide. And this only works if you're using Chrome. If you're going to use Safari Firefox or Explorer, you have to either use the waffle. Okay, so you're going to select the waffle and find and select that sheet icon, or you're going to go to drive hit the new button, go to Google sheets. Okay, if you're using Chrome, you could on a new tab type sheets.new or type sheets.google.com. Either way you do it, you're going to be creating a new sheet sheets.new is one click. So I'm going to open a new tab. I'm going to type sheets.new sheets with an s dot new. Get my enter key. And there we go. I've already been signed into Google. Maybe I've seen something really cool that I want to copy or I want, I went, oh, this is a great idea for data. Boom, I go sheets.new and I created a new sheet just like that because I know I'm signed into Google. I'm always signed into Google. So I just go sheets.new. Boom. Done. Okay. Now, because I'm not going to use this, I'm going to type delete here. So I remind myself to delete it because the other way to open a new form is to click open the new tab. Right. And then actually type sheets.google.com. Well, why would I want to type all of that because you're going to see up at the top of the page, your template gallery. If you don't see template gallery up at the top of your screen, you probably see something that looks like your district name, which means you're using your club, which is fine. So you just click on that and up towards the top of your screen, you're going to have tabs that I don't see because I'm on the pub, I'm on a public Google. Okay, but you'll probably have tabs up here. One will have your district name and then the other one will say general templates or something to that effect. Okay. So template gallery. Look at all of these templates I could use. And as soon as you click one, it's yours. So don't click. Don't click because it will be yours. Okay, and you're going to, you're going to, oh, what's this look like? Click. Oh, what's that look like? Click. What's this look like? Click. And you're going to have all of these different spreadsheets in your drive and, you know, two weeks from now you're going to, what the heck was I thinking? So there's a lot of good sheets here. And after you click in it and it is yours, go ahead and click one if you want to. You're going to be able to change it. Okay, so I'm going to click on this one down at the bottom. Mine says grade book. I'm going to click on a grade book as soon as I click it. I have to wait for the magic. Okay. And somebody has created this template because they think it's a big beautiful thing. And if you look at this template, if you follow it along with me and you've got the grade book template, you would go look at the bottom and you see different tabs. So here I have grades. I've got student want to one and two and they've already put in some data for me so I can follow along. I can put my teacher name and so you can make it anything you want. This is your yours to do what you want with. Okay. You can also change the color. You don't like the color blue that's been selected. You can make it red. The template gallery. Let me go back over that. I opened up a new tab. I went to sheets.google.com sheets with an s.google.com. Okay, and up at the top of the screen, you should see the plus sign with a blank. And then on the top right hand corner, you're going to see something that says template gallery. If you don't see that you might see your district name. So you click on your district name and then you'll see two options. You'll see two at tabs. One will be your district which has no templates or maybe just one. I don't know. And then the other tab will say general tab or general templates or something to that effect. By the way, while you're here. Maybe you don't ever want to use templates. Fine. Click on the skinny snowman and hide your templates. Don't do that unless you never want to see templates again. Okay. Yes, you can get them back, but it's kind of hard to do. I found that out. So I'm from experience. So this is the templates gallery. So and that's and if you scroll down when you go to sheets.google.com. These are all of your sheets as you scroll down. Now I'm looking at every one of the sheets that I've ever had that I've ever touched or that's ever been shared with me. Okay. I'm going to look for just owned by me. Here we go. These are all of my sheets, all of the ones that I've created. Why is this so so what I could just go to my drive and get these. Yeah, you can go to your drive and then you'd have to do a search to find all of your sheets to put them in a list like this. Google's already done this. This is exactly what you see when you have the app installed on your tablet on your phone. You're actually going to the app site. Okay. So instead of stall, you don't have to install anything because you're on a desktop. Right. So you open it up in a browser sheets.google.com. That is the app site. So this is actually what the apps see. Okay. In line with each one of these sheets that I've created. There's a skinny snowman way over to the right. And when I click on it, I can remove it. Okay. Or I can rename it. Or I can open it up in a new tab or who I can make it available offline. This is not in the sheet tips. So you better pay attention. Okay. So how did I get here? How do I make it offline? You go to sheets.google.com. You find the sheet. Don't make them all off available offline. That takes up a lot of space when you are working on the tablet or Chromebook. Okay. Or your phone. So when you make it offline, what it's going to do the next time you open it is it's going to download it onto your device so that you're able to make changes on it, whether you're near a Starbucks or not. Okay. So don't make them all offline. Just the ones that you're going to have that you want to manipulate offline. This goes the same with slides and docs. You can do it the same way. You click on the skinny snowman. You click on available offline. Wait for the magic. And then we see this little check mark next to the name. And that's telling me, okay, this one I can work offline if I want to. Okay. Also in line with the skinny snowman is the remove. So I'm going to turn off available offline and now I'm going to remove it, which basically just moves it to trash. All your files are saved to trash for I think at six months now. And then they will be deleted. They will be deleted in date order. Okay. So we've opened up new sheets in a couple of different ways. We've done it the conventional way through drive. We've done through the waffle. You can go to the waffle if you're signed into Google. Yeah, Linda, you're going to have to use Chrome. So one of the you have, you have to use Chrome in order to make your, your, your stuff offline. So we have forgot that one little part. We've also done sheets.new and you've gone to sheets.google.com so that you can see the templates. Okay. I have a sheet that's shared with me that has an extension XLS or how do you convert it. Okay. If you want to convert. Yes, you can, you can manipulate sheets if they are an Excel spreadsheet. You can keep them an Excel spreadsheet. What you do is you go to drive. Okay, so I'm going to drive. And you would find the spreadsheet or the first let's let's go over uploading so you would find the spreadsheet and you would upload it. There's a couple of different ways to do it. I'm going to do it the way that I can show you right now. You go to new and then file upload. All right, so you upload that Excel spreadsheet. Okay, before you do that though, you want to go to the gear. So you're going to click on the gear. You're going to go to settings. And then you're converting uploaded files to Google Docs editor format. This includes docs sheets slides. So everything that you convert, if you go if you have a word file and you upload it, it will convert to docs. If you had a ppt it will convert to slides. If you have an XLS it will convert to sheets. So you have to go to drive. You have to go to drive.google.com. You select the gear up at the top of the page on the right. You go to settings and then convert uploaded files to docs. Okay. All right, so that's how you convert it if you've already uploaded it and it's already converted go ahead and click it open. And then up at the top of your screen, you're going to see open with this is on doc sheets and slides. It works the same way across the board. So you open that PowerPoint or you open that spread spreadsheet or you open up the doc and at the top of screen you'll see open with and it will give you the option to whatever it will convert to it'll give you the option to open it up in a spreadsheet. PowerPoint slides or a doc and then you choose the appropriate format boom it's converted. So you have to do one or two more steps that way, but that's how you convert. Okay, let's move on. We want to get to do some some some stuff some stuff. It does throw off the formatting but you know what is the price you pay for being free grin, smile, laugh through it. Okay, change your formatting. All right, I'm going to go to the sheet tips worksheet in just a minute before I do that. I want you to see what we're going to be doing first. So we're going to select an empty cell, and then we're going to type in a function, and then we're going to have a formula. Okay, so we're going to actually format or formula lies a sheet here. So this is mine. And here's the address just and there's 41 of you here already that's cool. So now you're not going to be able to write on this. You're not going to be able to write on mine. What you're going to have to do is go to file. Make a copy. Okay, and you're not given any options. So you just make a copy, rename it if you want to. That's fine. It'll come up as copy of right so you can rename it here if you want. And then you can type it on it, type it on it yourself. All right, down at the bottom of this worksheet tips is a simple sum tab way down at the bottom and I'm not quite sure it's showing up on you guys a screen. I know this is really small. I apologize, but I can't make it any bigger. All right, so simple some I'm going to go to that tab. Now, before we before we do any summing. All right, formatting is kind of important when you're putting in numbers, sometimes for no rhyme or reason, Google will left align right align or even center align for no apparent reason at all. So let's line up our numbers. Okay, so I'm going to choose a to that's the cell and I'm going to hold down my shift key to a seven and you can see I've selected a range of cells. I'm starting to use those words. So I've got a range of cells here. Okay, I want to center align all of them. So I'm going to look at my toolbar and right next door to the merge cells button there's a horizontal align tab so there's a little arrow next to it. Okay, then all those little lines right there. I'm going to click on the arrow and then I have three options here. I'm going to center align the one in the middle and look at that all my numbers are centered aligned. Okay, that makes it a little easier to view. I might have even included the header if I wanted so that they're all central line together. There we go. All right. Now, next step, we're going to add all of these numbers right now are select a eight. So it's the number after the number 87 or the cell after number 87. It's also yellowed out a little bit. Okay, so we've selected that cell. All right, now Google knows things and sometimes it reads our minds. Okay, so with this cell selected. I am going to, I'm just going to start typing. Okay, and all formulas must start with equals must. So we're going to add all of these cells right here. We're going to add all those cells and the formula or the function for that is called sum. Now I just know that because I've been doing this a long time. If you want to do something else different, you don't want to do a sum or you want to know where that sum is at there right here this little I don't know what that icon is called. I used to it's the functions icon right now but it that that backwards looking E or the weird looking E is a Greek letter for something. Anyways, so functions. There's a arrow next to it. And here are all the functions that I could add to the cell that I have selected. Okay, so I can hit that some and then look the cursor starts blinking exactly where it should and it has already put in equals some for me. Now what I have to do is I have to figure out which cells I want to some. Summation. Yes. Okay, so I could do a one and then plus a two and then I could do plus a three and for your old school folks you're going oh my God what is she doing. Oh by the way I don't want to do a one because that's the header right that doesn't have a number in it. So a two plus a three plus a four. That's a lot of typing. Okay, you can do it that way. You could do equals some a two a three a four a five a six a seven. You can do it that way if you want. There's a much easier way. When you're doing a range of cells you want to remember the colon. Okay, so I'm going to see if I can zoom in here. I can't because it's. There we go. So, right here, I've got equals some and I could have typed that I didn't have to use the function of our their menu. So I've got a two colon. A seven. Then I'm going to hit my tab. Boom. And this range of cells equals 284 if you double click in the cell that you just put the formula in you will see that the range has been highlighted for you. So if any of those numbers are missing. Thank you, Jean. Okay, if any of the numbers are missing, then you know, oh, I got to add something. So let's let me show you that. Hey, whoops, a five. Okay, so I see here that I've got these cells are selected they're highlighted, but I'm missing a six and a seven. So I need to go back to my formula. All right, go right back here. And then I can change the numbers as I need to. It's a very simple function, the sum. Okay, so if you're following along, I want you to do average now. Okay, so right now it equals some leave that there in the cell below it a nine. I want you to do your own average I want you to average a two through a seven. If you want to look to follow along you may. I'm actually going to type it. You have to have the cell ranges within parentheses. And they changed the function name on me. Oh my God, I haven't used the average in a long time. This happens all the time. Oh my God, you have to actually type it out now. All right, so I just learned something the function for average used to be AVG, but now they make you type it out. And there we go. There's the average. That's a really long number. We're going to learn about formatting here in just a sec. I'm going to scroll over a little bit so I can look at the timer duration you might not have to do that. But I also wanted you to see that you can also and this is really important, especially on a form. If you ask students how long did it take you to read this how long did it take you to read that how long did it take you to do this or that, and they put in the minutes. They play the 30 minutes, took me 15 minutes. It took me an hour and 15 minutes so they put in the time that it took them to do something. We need to make sure that Google understands that this is not a time, but a duration. Okay, so right here, this one colon 15 colon 00. That could be misunderstood to be 115 am. Okay, 45. This must be a duration. Okay, it decided that as I was putting in these numbers as the form was putting in these numbers. Okay, but you can see this one it says 130 30 am. So it's understanding that as a time instead of a duration so I need to make sure all of these are duration. So I have to format them. So I'm going to select the cell range. I'm going to select. What is this? There we go. This is C, the C column. Okay, so I've got C to I'm holding down my shift key through C seven. Okay, so you're going to go to format, then down to number. And now down in that list, you're going to see something that says duration. So click that. Now Google knows all of these are duration and that you notice that the 115 that was 115 am is now 115 00.000. Okay, I want to make all of these right aligned. I'm going to select the cell range again. And I'm going to, because I've made my screen bigger, I've got to look for the alignment, the horizontal alignment, and I'm going to make them all right aligned. There we go. Now they're all lined up. So okay, I'm going, I wanted to show you that you could sum a duration, right? Google knows that this is a duration. So I'm going to do exactly the same thing that I did over in the A column. I'm going to just sum. I'm going to go equals, oops, equals some C to colon C seven in parentheses. And there we go four hours 35 minutes, 30 seconds. So you can add up time that your students have spent on something. You can add up scores that your students have spent on something you can get the average time the average score you can do all kinds of stuff. Okay, how did I make a duration. So I put, let's just say the form fed the sheet, a bunch of times that the students all put in how much time they put in. When it's coming into the sheet, the sheet doesn't really know, is this a time or a date. So you select the cell range. By the way, I know everybody has duration. So that's been pushed out long, long ago. So I selected my entire cell range. I'm going to go ahead and do the, the, the equation as well. Okay, so I selected that I'm going to go up to format. Remember, we're making it look like something it's a format. I'm going to go to number. That's what throws people off usually they're looking for the duration or the time right there. But you need to go to format number and then duration should be right in line underneath date and time. Okay. Alrighty. So simple sums very cool. You can do all kinds. There are lots of complicated sums. And I'm sure there's some of you out there is going to come on. Let's get to the complicated stuff. No, not going to do it. All right, the we got some stuff coming up. It's going to be more complicated. So I've got you covered but simple some start simply learn it, live it, use it, and then go. Now, I want to learn how to go to your expressions. I want to learn how to count or I want to learn what a minimum means. Okay, if you want to learn what a function means, when you go to the, thank you, Jane, expressions tool scroll all the way down and click on learn more. This is not in the tips slides you need to remember this. You're going to go to expressions, learn more. Another website basically is going to open up for you. And here is the entire function list. Some of these are going to go. Oh my God. Some of them are really simple. All right, you can also narrow these down by, let's say you want to do something to text, or you want to do something mathematical. You want to filter. You can actually choose any one of these and all of those text functions will come up for you. If you want to type in keyword. You could type in a keyword. Didn't find some you're kidding me. It's a mathematical function. Learn something new every day. There we go. So I had too many filters here so I just leave it as narrow by then I typed in some and here we go. It's down here somewhere. Boom. Okay, so there. And thank you again. All right, so here I'm going to go ahead and close that sheet. And then I'm going to go back to the slides. You can stay on the sheet if you want. Okay, and I've got to make this smaller. I can't see. All right. Now, next one, we're going to split data. So how many times have you had students maybe on a form and they're selecting or they're they're just typing in their full name. And that's probably easiest for your students. Okay, or you have them type in two things in a cell and you really need them to be in two different cells when it comes to the sheet. The name is a good example, or a name is good example. So I'm going back to the sheet and I'm clicking on the split tab. Okay, now here are a bunch of names. Okay, there's also some date and time. So let's do the names first. Okay, here's the thing when you do a split, you must must must must make sure that the column next door has nothing in it, because when you do a split, everything that is coming into this column. The next column, it all goes to the right to the right to the right. It's splitting to the right. Okay. If there's anything in that column, it gets overwritten. So make sure you have a blank column before you split. Let's say that there was something in this column, and I don't want to get rid of that data. Okay, what I would do is click, right click on the column, right click on the column, and then I just add one to the left. Boom. I didn't screw up my data. I didn't get anything. I didn't mess up anything. But now I have a blank column to the right of the text that I'm going to separate. Why do you want to separate first and last names? I'm so glad you asked that question. How the heck are we going to sort by last name? Do you have the answer? There is no answer because you can't. Okay, I can't sort by last name if they're all in the same cell, right? So I need to split that up. I need the last names to go into their own cell because right now, if I did a sort, it would alphabetize or in order or reverse order, doesn't matter, but it would be by the first name. So here we go. We're going to select ourselves. So I'm selecting A2. I'm scrolling down to A21. I don't have to do them all. I could just do a couple of them. All right, but I'm going to do the whole set here. So I've got my cell range selected. I'm going to go now we're doing something to the data. We're not formatting it. We're not making it look different. We're actually doing something to the data. So if you can remember that, you will remember where split is. So click on data and on here you're going to see split text two columns. Okay, I'm going to click that. Now it's going to give me the option. There's a little tiny box. I don't know if you can see it on yours or on mine. It says detect automatically. Google will detect commas, semicolons, periods, and spaces automatically, and it will split on those. Now let's say maybe for whatever reason I want to split some text that has a what is that called the slash, the right slash. Okay, or maybe it has maybe I want to split it based on the parentheses. Okay, so I can customize I can select what I want this text to be split on. You'll you'll know when it happens. All right, right now though that the common thing between all of these names is a space right so I'm just going to select space boom. Now, Trish, when I go up to my column, my B column, and I click the arrow on it, and I sort my sheet A to Z, but a Bing but a boom, we have our last names alphabetized. So you might want to do that. You might want to do that. I could also put them together. That's a whole nother function is called concatenate. We're not going to cover that. Look it up. Look it up. Go to the the functions list here. And you might even see it here. No, we don't see it here. So learn more, learn more by concatenation. All right, now I'm going to scroll down on this split tab. And on a 22 I see there are some dates and times now maybe I want the times to be in their own own column. Did the first name stay with the last name when we sorted. Absolutely. Oh my goodness. Let me let me show you something else. Now Oh, it might not have. Oops. You know what I forgot to show you the freeze. Okay, I did forget to show you that. All right, so everybody look back over here because this is kind of you got a visualizing when I hover my cursor right above the number one. It's an arrow until it turns into a hand right about there. Okay, when it's a hand I can grab it and pull it down. Okay, what that does is that freezes this column right here. I just made a blue so it stands out a little bit. So this is frozen. Okay, now I could freeze. I could go even further down to number two down to number three or whatever. But I wanted to stay at number one because that's my header row. That's very important. So when you're sorting you have to freeze the row above what you're going to sort. Okay, so let's just write the word last. Alrighty. Now, now when you sort the first names will stay with the last names. Let's sort by first name first. Okay, I'm going to go to the A column. I'm hitting the arrow next to this in line with the A. And then I'm going to sort sheet A to Z boom. And all the numbers came up first. Very cool. All right, and now I'm going to go to the B column. And I'm going to sort sheet A to Z last name. They all stay with their respective cousins next door. Okay, so yes, when you sort as long as you have that header row frozen, you're okay. All right. Now, let's move down because we're splitting. Okay, I'm going to select the range that has dates. Okay, I am going to go to the data. I will repeat the freezing just a sec. I'm going to go to data. And then I'm going to split text to column and it does it automatically. I didn't go. I didn't select the separator. All right, I let it do it. Okay, so I wanted to show you that now we have the dates and the times and two separate columns. Okay, you don't have to go in and select space or comma or whatever. You can do it as you wish. Now I'm going to select the four o'clock PM. There's an eight o'clock in here as well. And I'm going to separate again data, split text to columns, and I wanted to show you custom. So the custom separator now is going to be. Oh, it already did it. The son of a gun. They did it already. I wanted to show you this. The AM PM, it already split it. So Google's so smart, it just went boom. What happens if the name is first, middle, and last? Hang on a sec. We're going to freeze. Audrey, that's very important because we have a Smee who has, and I'm going to kick them to the curb. Ryan, if you're here, I love you dearly. Ryan de la Vega, he has four. No, three de la Vega is three names in his last name. So I'm going to show you what happens when I have to do Ryan. All right, I'm going to get rid of this stuff here so I can show you Ryan de la Vega. And I'm also going to get rid of my dates because I don't need those. All right, so let's say we have Ryan de la Vega. Okay. So I want to split this. Yeah. I'm going to go to data. I'm going to split text to columns and I'm going to go. No, I don't want to do that yet. I don't want to do that yet because I need to make sure that there are one, two, three, four spaces for columns just for safety's sake, next to his name. Because if there's anything right here, watch what happens when I split Ryan's name. I'm going to go to data, split text to columns. I'm going to tell it the space and whatever I typed right here is gone. But it did split his name up, right. And now because it split his name up, I have to put his name back together. So what I usually do with someone like this, I'm going to undo what I just did. What I usually do is I look through the names really quick and I go, okay, I've got somebody with a space or more than one space between their names and I'll do something like this where I take out the spaces between de la Vega. Okay. And then I'll split to get rid of that. And then I'll put his spaces back in. And that's what you need to be aware of. If it's first, middle and last, then you're taking up three columns just make sure that that third column doesn't have any data in it that you don't want erased. Okay. All right, I think I'm coming back to the sheets. We've just split the data so that's again all of this is on the handout. The slide stack so you'll be able to see it. If you want a worksheet, then you would make a copy of it and you can go ahead and do it to it. So here's where selected the range, the different you can customize. How do you get rid of the extra space. Hmm, if it's at the end there's a trim white space on the data. And you could trim white space if there is an extra space in a name, you might have to actually go in and do it. You might have to look at and go there's an extra space here I have to delete that so every once in a while, you know, Google's good. So is Excel, but it can't do everything. Sometimes we get to do it ourselves. Okay. Oh, shortcuts is really cool. I'm going to go back to the sheets. I'm going to go to the format and quick keys tab. Okay. And control semicolon control shift semicolon and control shift alt semicolon sometimes you want to put the date in you don't have the one to type or you don't want to type the darn thing in right. So there are some quick keys here. They're in the blue the light blue. All right, I already did this. Okay. Okay. In the yellow area, I'm going to do it again. I'm going to hold down my control key and hit the semicolon. Look at that. And then I'm going to go control shift semicolon. Oh my God, it's 10 o'clock already darn. Okay. And then control shift alt semicolon by the way the word control is command on a Mac. Okay. So there we go. Easy way to put in the date control shifts or control semicolon. I don't know that you'd ever want to put in the exact time like this but again you if you want the time to be a different format, you would select the cell. Go to format, go to number. And then you can have more time formats you don't have to have it down to the last second so we go to more formats. More date and time format same as you go down down down so I went to format. I went to number. I went to more formats and then more date and time formats and when you select that you get this really long list of different time format so here's the one that I would want just the minute for the hour in the minute. Okay. And then I apply boom. It's done. It's also 24 hour time so I'd have to go back and change it if I wanted to Google is used throughout the land. Okay, and most of the land uses military time. We call it military time. They call it European time. You know, share the love. Okay. January, February, March. Now the next three or four cells. Do I have to type April, May, June, July? No. I'm selecting January. I'm holding down the shift key. I'm going to select February and you'll notice they're all being selected. The cell range is being selected. Okay. So I've got January, February, March selected by holding down the shift key. I'm taking my hand off the shift key. I'm going to take my cursor over to the square at the bottom right hand corner of where March is at. I'm going up. There it is. There's the crosshair. It turns into like a little, a big plus sign. It's a crosshair. I click on that square and drag it down and the months fill in. Okay. Now do the same thing for two, four, six. I'm going to select two, then four, then six. Do you notice a pattern? Two, four, six. You can do it with two, Ada. Yes. I just put in three because it's a safety for me. So I've got two, four, six. What would the next number be? 12? No. Google knows though. Watch. It is. If you have any kind of a pattern set up, you can select that pattern. Okay. So if you've got a pattern of four things set up, select the pattern of four and then drag it down and it should maintain that pattern for you. We're going to rotate the text now. Most people don't know about this. It adds a little space to your column, but it's really kind of cool. I'm going to select January through July because I had those dates. If you only have January through May, that's fine. Just select your months. Okay. Up next to the link tool to the right of the link tool, you're going to see an A that looks like it's out of whack. It's text rotation. If you click on the arrow next to it, look at all of these different options you have. So you can make your text go in any direction you want. You can select this one, the one that's kind of a tilt up. Boom. Now, I can readjust my column. It can be a little bit smaller maybe. Yeah. And it looks a little more like I know what I'm doing. Okay. Like, wow, how did you do that? It's just a text rotation. There's lots of different rotations that you can try, including the up down, the vertical rotate up, rotate down. And you can also add, if you want your own degree of rotation, you can also select that. So that's pretty cool. If you have a long paragraph, if your students have on their form, they wrote this really long paragraph. And when they do that, all of the text goes into one cell. This cell right here, Loram Ipsen-Dohler, that's one cell. It's not going across the page. Well, it is going across the page because I'm allowing it to. Right now, go up to the top of your menu, you're going to see text wrapping. It's next to that A tool that we just discovered. Okay, the text wrap. There's an arrow next to the text wrap. Okay. And then there are some options here, one of which is clip. So that will stick everything in its cell without allowing it to wrap or extend past. If you want it to wrap, and it is a long paragraph, you can do that. But you notice it becomes a really long cell with its own little scroll bar. Okay, so you might want to clip it, you might want to wrap it. I don't know. It's up to you. But that's how you can make a cell, all of the data stay within a cell and still be able to read it is by letting it wrap instead of extending past. If you have something in this cell, just type something really quick, and we allowed it to extend, it won't because there's something there. It will only extend if the cell next to it is blank. Okay, so we've learned, oh, and we've already gone over alignment, right, you also have vertical alignment. So you can select that arrow and maybe put it in the middle. Sometimes you want things to line up differently because one sells bigger than the other. So there's horizontal alignment and there's vertical alignment along with the text wrap. Okay, can you enter, can you put in a picture? Sure. So you go to insert, you go to image, and you can put image in the cell or image oversell. So that means you can move it around. Okay, they want you to upload or give it by, you know, a Google image search or maybe you have an image on your drive. So you decide where the image is, and then yes, you can go to the insert menu to insert. So we've done the insert already. The cell contains web entries. Is there a way to shorten the URL? If the cell contains website entries, is there a way to shorten the URL? No, Bruno, there's not. You have to allow it to stay. When you have a website listed in a cell, it actually is a formula. And that's why it's so long and it looks really weird, but you have to leave it that way. Okay. Alrighty, I think I'm going to come back to the sheet. Okay, so we've done all of these, or these right here. You've also got some different quick keys. Use them on your own. So it's quickly to format as a decimal. Quickly to format as time is control shift to control shift three is the date currency percentage and exponent. So all of those are quick keys that you can use. You don't have to go to format and then find how to do that. Can you do mathematical operations in Excel as to present a math lesson? Well, that would be Excel, but I'm sure you can do it in sheets. Yes, Maria. Okay. Yes, you can. As a matter of fact, I'm going to be asking one of our SMEs to do a little more in depth on math. That would be Barry Backein because he's done a workshop like this before only he's done it face to face. So we'll see if we can get him in to do something like that for you. Okay, conditional formatting. You're going to love this. I'm going to go back to the sheet. Okay, I'm going to go to, oh, we should do charts first. Yeah, we're going to go to conditional formatting. So skip the charts tab and I'm going to go conditional format. Okay, these cells up at the top through B six have already been formatted. Okay, they've already been for conditionally formatted. All right. Now what we're going to do is first I'm going to show you how to put conditional formatting on a cell. All right. And then we're going to, I'm going to show you how to extend it to a range. So we're going to add formatting or we're going to do conditional formatting to these, this cell, everything that's dated February. Okay, everything that's dated February. So I'm, I'm selecting a seven through B 11 a seven through B 11. So select those cells. Now we're going to go to conditional formatting is in format. So I'm going to click on format and then down towards the bottom, I'm going to click on conditional formatting to my left. A little window is going to open up and Google Google thinks it knows what I want. So it puts its own little conditional formatting in there for me. Okay, off to the left, I see that it has decided that since I selected the range a seven through B 11, which I can change at any time if I want. They've decided that if the cell is not empty, then it's going to turn green. If the cell is not empty, then it's going to turn green. This isn't if then. Okay, so you need to remember that you're applying to these cells. If this is true, then this happens. I don't want this. I want something different. I want to follow the instructions here add formatting to these cells to color all cells red that are blank. Okay, here we go. So it's the if part is not empty right now selected but if I select the arrow next to is not empty. I can select is empty. And then I can change the color to instead of being green. It could be red. And there we go. We've just formatted conditional format. So when I go to February 20 or February 2, and I add a number. What do you think is going to happen. Look at that. So it's just the blank cells that are reddish in color. Okay. And now, here we go. Now what I want you to do is go back up to where you see the orange in the green. Okay, so we've got January through January 5. I'm just going to click in one of those cells. First, I'm going to get rid of that. I'm going to click in the cell that the top one the 30. Okay, and I'm going to go to format, and I'm going to go to conditional formatting. Here are the two rules for this formatting. So I'm going to click on the green one. Value is greater than or equal to 50. So if the value is greater than or equal to 50, then it's green. If the other one, let me go back, is if it's less than 50, then it's orange. So think of this as far as maybe scores. Okay, you might want the ones that are really having problems. The scores are low. You might want those to pop out at you. Alright, so let's I'm going to customize this a little more and I'm going to make it so we've got the range be one to be six. Right. And we want it less than I want all the the I want the grades that aren't so good to come out so my point of no return is let's say 75. Okay, and I'm going to make it instead of orange. I'm going to make it red, because I really want to pop. And we have a 55 there that's still green. So I got to figure that one out be one to be six. Yeah. All right, we're going to say done. And we're going to go to the 55 and figure out what's going on here, because that. Oh, here we go. Because the formula on the green one is says greater than or equal to. So, ah, this is why I wanted to show you this. So we're layering, we are layering conditional formatting. Okay. I want everything that's less than 75 to be read. But the rule that says value is greater than or equal to 50 is first. So this is going to be the overriding rule. So do I have to delete my rules and make new ones. No, all I have to do is drag this rule to first place. And notice as soon as I did that, the 55 over here turned red. Okay. So again, you got some form, you've got a quiz, you want to be able I'm a very visual person. So I could look through the numbers or I could arrange them or I could sort them, I guess, but I want to, I want, boom, I wanted to pop out at me. Okay. So I do conditional formatting on forms when I have quizzes submitted. That way I can see, I need to talk to, I need to talk to Anthony. All right, because Anthony is, yeah, man, he's just not getting it for some reason. Anthony, I know that's not the case. But I had to think of a name. All right. So we're going to add, here's another cool thing that you can do on a form. So maybe you want to know whether or not you've done something, or you want people to tell you whether or not you've done something. So I'm going to select, I'm going to put a checkbox in here. Most people don't know that there are checkboxes in Google Forms. So I selected a cell. I'm going to go to insert and I'm going to, oh, there it is. Checkbox. Click. Okay. I got a checkbox right here. So I've selected a cell. This cell has the square. Let me see if I can zoom in a little bit. All right, here's the square, right here. And as I, there's a little hand. I don't want the little hand. There's my cursor error. No, I don't want that either. I have to find that sweet spot. There it is. You have to find the sweet spot. So as soon as you get right in the middle of that square, it's your cursor should turn into a crosshair. If you're on a tablet, good luck with that. And I'm not joking. Tablets are really hard to manipulate the cursor into the hand of the crosshair. So if you're on a laptop or a desktop, you shouldn't have any problems with it, especially if you're using a mouse. Trackpad. You know, if you're really good with trackpads, it should be okay. All right, so here's my crosshair right there. I'm going to drag this down. Why am I dragging you down? So I don't have to go insert, insert, insert. Okay, so I'm just dragging down the checkbox. Okay, now here's what's really cool. And I think this is on the handout. It's the next slide here. I've gone back to the handout. Here we go. Yeah. So let me back out so I can see the whole thing. A custom rule that you can add is that if the, if the checkbox is checked, if there's a checkbox is checked, you have to click in the cell so that there is a square. Click in the cell, and then there's a square. Okay. A custom rule. If the column is true, if the checkbox is true, right, then the entire row becomes a color. We have actually done this on a worksheet that I have put together for all of these webinars. Our staff secretary is going in and she's marking attendance. There's a checkbox for that. Then she marks that the certificates were sent. There's a checkbox for that. And then she sends the evaluations to the presenters. There's a checkbox for that. So every time she hits a checkbox, there's a new color introduced into the sheet. Okay, now yours might not get this complicated. I don't recommend you get this complicated. Just try it out for one or two. Right. Start simple. So this I'm going to go back to the sheet tips. Here are my checkboxes. Okay, I'm going to select a couple of them. So as we're creating this, you get the idea of how it actually works. Now, I'm going to select my range. I selected a couple of checkboxes. I selected the range. We've got March through June. I'm going to go to format conditional formatting. This is where you and again Google thinks this knows what I want. It doesn't. What we're going to do is we're going to go, we're going to click on where it said is empty and we're going to go all the way down to custom formula. Okay, now we've got that the range selected is a 12 through C 31. That's what this rule is applying itself to. Okay. If here we go. Now, I need to explain something. When you put a dollar sign in front of a row or a column. It was it's gluing itself. So a dollar sign is glue. So I'm going to put a dollar sign. And I'm going to put C. Because I want the glue to be stuck on the C column because I want the sheet to understand that the C column has the checkbox. This is the if. Okay, so if C. 12 equals. True. Is it true or true? Yeah, I'd look at something first. Okay, so if it is true. Then it's going to be orange. Now. Look what happened. All of the ones that were checked, followed the rule. Okay, all of the ones that were checked follow the rule so it's equals. Dollar sign is the glue. Because my column C has my checkboxes. So dollar signs C 12 equals true. You have to have those equal signs in the in the exact right position equals question or equals dollar sign to keep wanting to say question mark equals dollar sign C 12 equals true. Done. By the way, you also have the option to make the. Bold. Okay, or make the font a different color so it stands out more maybe, or maybe it's grayed out because it's already done. Right. To test it you actually absolutely want to go through and click a couple of those checkboxes to make sure they follow the rule that you just set. And again, if you add more than one rule. Then just make sure that they are in the right order, whatever's on the top leads the pack. That's number one. Okay. Why C 12 in particular because that's where my first checkboxes Amy. I added a bunch of different tutorials on the same thing on the same tab I should say so C 12 is actually where this tutorial as far as conditional formatting on a checkbox started. Okay. If I wanted to, I can, well let's do that. If you followed along, let's double click. Or, let me start over because I know some of you clicked off of it. All right, so I'm going to click in a cell that has the conditional formatting set. Okay, I'm going to go to format conditional formatting right here's my rule for a 12 through C 31. Okay, I'm going to click that open. And then I'm going to change the range because maybe you're right. Hey, maybe I didn't want 12 to be my start maybe I wanted 20 to be my start a 20 through C 31. So I'm going to do a 20 through C 31 and say done. And now you see that these that are checked are not part of the range and remember I selected the range. Right, I selected the range. And then the C 12 is the first checkbox in the range that I selected. Right, for the first formula right now I see 20 is so I could go here and I could change the C 12 the C 20. The results will be a little different. Yeah. And as I checked anything within the C 20 range, you'll see the conditional formatting change that probably confuse some of you. All right, so the formula is just a cut it's a custom formula Maria. So you don't have to stick with is empty is not empty text contains text because not contain. What if you want something that's more of an if, like if this is checked, then it becomes this, or if that is this date. It's this, and then I add another rule if that is that date. Then it is this. So just think if then if then, and if your if thens in your head don't match one of these if in rules that Google is already set for you, then customize it. Create your own if then. Okay, that's why I did that. Let's go back to charts I'm going I'm just going to click on the charts tab I'm not even going to go back to the sheets. I'm going to get rid of this because that was just a test. All right, now we had someone ask about math. Right. So, here is just a formula to x plus three equals why if y equals six then here's the answer. Right now what if I wanted to chart that out. What if I wanted to graph that out wouldn't that be very cool. You can do that. So I'm going to select the range, which is the y coordinates along with the x coordinates. Right. I'm going to go to insert. And before I hit chart, I need to explain something. Google is looking at your information, your range, your cell ranges right now, and it's going out. I know what she wants. Boom. Here you go. When Google does that, don't get angry at it if it got the wrong chart for you. Okay, you can change the chart. Google is trying to be helpful. All right, and another way it can be helpful after you select your range. I'm not even going to go to insert. I'm going to go way down at the bottom of my screen. And you're going to see some things. One of them for me says men equals negative six. Click on that. Google is giving me some options for formulas right now. I don't want any of those. It's also giving me an explore option. So this little tool looks like a little plus sign kind of in a comment box is giving me some options as far as formulas are concerned, not charts but formulas. And look at this. And then it's because it's looked at the data and I gave it a little time. My Wi-Fi is a little slow. Here we go. Look at this. It's giving me some chart information now. It's also plotting points. Yeah, that's cool. I didn't have to think about anything. Google did all the thinking for me. All right, so it's giving me a bunch of different ideas here that maybe I didn't even think about. If this is the one I want, I click on it. I drag it over and there it is. There's my chart. If you do that using the explore tool, you always have the option to change. You always, whether you use explore tool or not, as soon as you hit an insert chart and it becomes this or anything, you can double click on the chart and then you have all of the chart options on the right hand side. You can get lost in this. And Ms. Trish, I know you're out there. I know you're watching because I helped you do this yesterday and I bet you spent at least an hour playing with your chart yesterday. So if you did, chat in the chat. So you've got all kinds of really cool things that you can do here. You can manipulate the series. So right here, if I don't like the color blue, I wanted red. I can make it red. Okay, I can do all kinds of something. Like I said, you can get lost in here. You can spend days on some of these things, especially if you have something like a pie chart. So let's do that. So I'm just going to add one, three, five, and then two, four, six. And then I'm going to see if Google sees a pattern because I'm just playing right now. Let's see what it does. Oh, look at that. It does see a pattern. All right. So I'm going to select these numbers. And if you, hey, I want to do that. I just typed in 135 and then 246. So 135 and then 246. Can the chart be changed to make X on the horizontal? Absolutely. You have to go to the chart. That's what I was showing you that you click double click on the chart. And then you would shoot, you would customize it. So we've got chart access or axes, vertical axes, horizontal axes, you control your own chart. Back to this other one. Oh, by the way, the chart, if you don't like it that big, you click on it, grab a handle, make a smaller. Okay, lots of stuff you can do. Back to the numbers 135, 246. I just selected those and then I dragged it down and it saw a pattern. So it did it for me. All right. I'm going to select these numbers. I'm going to actually use the insert tool this time instead of explore. I'm going to go to chart. And oh, that's a nice chart, but I don't want that one. I don't want this. I don't want anything different. Okay. So it's going to keep you or it should open on the setup tab. If it doesn't click set up. Go to the arrow tool next door. Right now it's selected a line chart. I don't want a line chart. I don't like the line chart. Okay, fine. We're going to select a pie. Boom. And there we have a pie chart. Woohoo. I'm going to move this down just a little bit so I work with it. At this point and look folks, you control this. All right, if the data range that you selected was incorrect, you can change it right now using this. Or you can start back from the beginning if you want. I'm going to go to the customize and notice my customization options have changed a bit. Okay, here's the chart style. Here's my chart border. If I want to make it different, I can. It's 3D right now. I don't have to have it 3D. I can make it flat. Okay. I can click the arrow tool on chart style. I'm going to go to pie chart. Donut whole option. So I'm going to select that. Go to 25. Look at the middle. Isn't that nice? If I don't like 25% if that's a little too much for me, I can actually make it 12. Okay, so it's up to you. You control this. You don't have to use these pre-selected percentages that they have decided for you. The slice labels. I could put that in if I wanted. You don't, you know, it's up to you, your chart. The different pie slices. If right now it's got the one is blue. Okay, if I click here, right, I'm clicking on the pie. And then the colors are changing. If I don't like this blue. I can change it to anything I want. And I can also make it pop out. Look at that. So if I'm doing, if I'm doing some data in my, my, what, my administrator wants to know, okay, how's the GED going, how's the GED testing going or how is that testing going or their citizenship test, whatever. And you want something to pop out at them, do a pie chart, take that chunk out. Really cool. Also on this sheet, because we're running out of time folks, we have filter and pivot. So I'm going to show you how to do a filter really quick. Lookup filter on the Google help. Okay, so let's say we have a bunch of scores. Okay, and I just, I could sort this. And it's already sorted by Andrew. So I've got Andrews, but I want to see what people are doing per test, maybe. Okay, so I'm going to click in the D column. Okay, and then I'm going to go over here to this, what it looks like a little funnel. It's actually a filter tool. So I'm going to click the arrow next to it, and I'm going to create a new filter. And because I selected the D column that says test title is allowing me to filter this column. Right next to test title, I do see that little funnel thing again, I'm going to click on it. And I want to know, I'm going to select, deselect all of this because right now it's finding everything within that column. Right. And I just want to know how things are going on the language arts. So I select that. And I hit OK. And here are the people that took the language arts quiz. Okay, it's a filter. I didn't have to do any sorting. And if I wanted to, I could actually put a total over here, doing the points, getting an average or some of the points. So let me go over that really quickly. Again, I'm going to turn this off. I went to any one of these columns you can, you can filter. I click in the column. I go to the filter tool. I create a new filter view. And then right now it's finding everything that's in that column. So everything in the language arts, mathematical reasoning, science, social studies, right? If I just wanted to see one, or maybe even two, I want to see science and social studies. I want to say OK, because those two things are selected. And there we have all the science and the social studies. I can sort from here. Oops, no, I can't. What happened? Oh, you made a liar over me. So we don't want the blanks. We just want science and social studies will say OK. There we go. It blipped on me. Okay. From here you can also right now this above the filter in the black bar. Yes, you can save. Yes, Jacqueline, that's what I'm covering now. So this is called filter three. So I'm going to call this test type filter. Okay. And then that way, because I do, I have several other filters here. Here's filter one. This is on student name. So right now Howard was it was the last time I filtered. I can go in and select Andrews and say, okay, so now I just see that test. So if I wanted to name filter one, and I should say by our student filter filter, not filler. Okay. There's also a really cool thing that does even more called the pivot. I am not going to show that because we don't have the time import range though is important. So on the pivot, just look at pivot tables. Those of you that know what they are, you rock. I haven't quite fully grasped it myself, but I know you need a lot of data and it does a lot of stuff. Okay. So right here. Let's say you have a form, and you have a live form, and data is coming into it daily. You can have, you can sort it, but as soon as someone submit something it blows your sword, right. So what you do is you have the data from the form. Are you actually create another sheet. You create another sheet in the worksheet because your form is going into a sheet right. So let's pretend that where were we at the four. Here we go filter. So I'm going to turn this filter off. Let's pretend that this was a form. All right, all the data is coming in this form. All right, I want to be able to sort this and I want to be able to do other things with it as it's live. I'm not going to touch the form. I'm going to add another sheet. Just like that. Okay. And then I'm going to figure out, okay, what do you want from the sheet. I want this row of data. I want a to through a to. Okay. So what you need to do is you need to know this sheet's name. This sheet's name is called filter slash pivot. All right. Now I'm going to go back to that blank sheet that I just created. Right. I'm going to click in the first cell a one, and I'm going to type equals. Here we go. This is the magic equals filter slash pivot. Oh, I should have capitalized it filter slash pivot exclamation point. A to column. Or colon e to it doesn't look like it's doing it. Why isn't it doing it. I need to look at my cheat sheet. Hang on. Here it is. Equal sheet name. Yeah, so what's going on. I knew I did it right. Okay, so the name. Don't put mathematical expressions in your name for your sheet. So I'm going to rename the sheet. I should have known better. So we're just going to call it filter pivot. Okay, I'm going to go back to sheet eight. Sorry about that. Learning moment for all of us. So here we go equals filter pivot exclamation point. That's very important. The equal sign filter pivot is the name of the sheet. And then the cell range a two to e two. Okay. I'm going to hit enter. And there we go. And that should only be a two shouldn't be a range. There's a to now crosshairs dragging it over. Boom. And as I look at the data that's coming in, it's coming in from B to C to D to an e two. I didn't have to type the formula in again. So we've got equals filter pivot. That's the name of the sheet exclamation point a two. Right. Now I'm going to drag down from that because I can get B to C two three two way down. I can drag down from the B column. There we go. It's coming in. This will match filter pivot. And if I don't want the Monday, Wednesday, Friday, if I don't want the class time or class name or whatever, I can take that column out. All I want maybe is the name of the student, the name of the test and how many points it was. If that's all I want, then I can get rid. That's all I bring in. Right. So I can start my sheet with just equals filter pivot C to D to an e two. If I want C to this is really gonna blow your mind out of sync. If I want to start it with D to and then you to and see that you can rearrange this any way you want. You're bringing the data in from another sheet. You're not messing with the sheet. This isn't being changed at all. This sheet sheet eight right now is being messed with. Okay, now that might have just gone blown your heads off the top of your heads off. So those of you that are a little more advanced, you're going to understand this. You're going to have to practice, folks. That's what it takes. You need to practice. So just have a sheet with a bunch of junk in it, numbers, letters, whatever you want. If you've copied that sheet that I had, I've kind of messed it up. So wait a little bit. I'll get it back to where it was when we first started. Okay. And then make a copy of it. And then you've got some data there that you can play with. All right. This import range, you can actually bring data in from another another sheet. So what you need to do is have the URL of the sheet. So on this sheet right here, here is the URL. That's the URL of the sheet sheets is really cool. Work your sheets.