 Hello everyone, my name is Michael and I work for the San Francisco Public Library and today we're gonna go over Google Sheets. So the agenda for today is I'm gonna go over what is Google Sheets, how to access Google Sheets or where to access Google Sheets, storage limits of Google Sheets, how to navigate the Google Sheets of web portal, how to create, save and share a spreadsheet, how to enter data into your spreadsheet, how to insert, delete, rows and columns in your spreadsheet, how to use basic formulas, how to create a chart, and how are Google Sheets and Microsoft similar and different. So Google Sheets, what is it? Google Sheets, it is a spreadsheet program developed by Google. So you could create spreadsheets within this platform. It is very similar to Microsoft Excel. So if you've ever used Microsoft Excel before, there are a lot of similarities and there are some differences and I'll go over that later on today. So Google Sheets, it is cloud-based. So all your spreadsheets are stored on your Google Drive account and you have 15 gigabyte limits in your Google Drive account. And also, since it is stored in your Google Drive account, all of the various platforms in Google, they share that. So if you use Google Docs, Google Slides, Google Photos, all of those share your storage limits as well. So all of those count towards your 15 gigabyte limit. And you would have to have a Google account to use Google Sheets. So if you do not have one, you could sign up for one. You could always sign up for a free Gmail account if you prefer. If not, you could always sign up for a Google account using your existing email address somewhere else. And that will give you access to the Google platform and Google Sheets. And Google Sheets can be accessed through the web browser or on an app on your smartphone or tablet. So if you have an iPhone or an iPad, you could go to the Apple App Store and download Google Sheets. If you have an Android device, you could go to the Google Play Store and download Google Sheets. And then you could view Google Sheets, you could kind of make minor edits in Google Sheets, but then you might lose some features on there versus like the web browser version. And I will go over how to access Google Sheets on the web browser today. So there are a couple of ways of accessing Google Sheets in your web browser. As you can see on the screen right here, there are two addresses. So you could type these addresses into your browser and they will bring you to the Google Sheets homepage. If you're on the Google homepage, you will kind of see kind of like the search bar right here in the middle. And on a far right-hand corner near the top, there are kind of nine dots or squares. It depends on how you view it. So this gives you the access to Google Apps. So if you hover over it, you can see it says Google Apps and you click on it. A dropdown menu should kind of show up and it will list all the available Google Apps. As you can see, there's Google Photos, Google Shopping, Google Docs, and Google Sheets right here. So you can access Google Sheets through this way as well or through the addresses I gave you earlier into your address bar in your browser. So I'm gonna click on Google Sheets and it's gonna bring you to Google Sheets. Give me a second. Okay, so right now you should be seeing kind of like the very beginnings of the Google Sheets. So on the screen right here, there are a couple of things you should pay attention to. The first thing is the template gallery. So for instance, if you're in a rush or you want like a pre-made spreadsheet for your work or your job or your daily life, then the template gallery would be the best thing because these spreadsheets are already made for you. So all you have to do is kind of make edits, add your data into it, then you can have a very nice looking spreadsheet. And I'm gonna click on the template gallery option right here, it's gonna expand it. And as you can see, there's a lot here. So there's some for personal, let's say to-do list and your monthly budget. There's a calendar as well. If you scroll down, there's some stuff for work. So if you wanna create like an invoice, time sheet, let's say expense report, and if you scroll down, there's more like project management and at the very end, there's some for education. So if you're a teacher, you could use this pre-made as a spreadsheet for attendance, for grade book or if you're a student, assignment tracker. So it depends on your needs. So these are all pre-made and you just all you have to do is just click on it and it'll open up into your browser and you can add your data into it. But for today, I'm gonna create a brand new spreadsheet. So I'm gonna go back, give me a second. Okay, so right now, as you can see, near the bottom half of the page right here, it says today and these kind of are, they are your previous spreadsheets. So if you've created any spreadsheets in the past, they will live here as well. And if anyone has shared a spreadsheet with you, they will live here as well too. So it's mostly, you can kind of arrange the order of it. So if you go here, this is owned by anyone. So these spreadsheets are owned by me or anyone that shared with me or I could select owned by me or not owned by me. And you can kind of view like, what are the spreadsheets they're shared with you that were created by someone else? And it will let you know when was this spreadsheet last opened? So like this one, I just opened it at 1244 p.m. And you can sort it as well too. Sort options last opened by me, that's modified. So it depends on how you wanna view this list. So I'm gonna create a brand new spreadsheet today. So I'm gonna hit on the blank option near the left-hand side right here. It's kind of like an icon with like a plus symbol and says blank on the bottom. So I'm gonna click on that. And right now you should be seeing a brand new empty spreadsheet on your screen right now. So this is gonna be your work plane. So everything you do in a spreadsheet is gonna be here. So the first thing I'm gonna go over is you should name your spreadsheet. So if you go to near the top, top left-hand corner, you should say untitled spreadsheet and you should say renamed. So if you use your mouse, you click on it, you'll highlight it and you erase the name and you give it your own name. So I'm gonna say budget. So today I'm gonna try to create like a quick spreadsheet for your daily budgets. So and I will show you how that kind of works with the available features as well too and how to kind of navigate the platform. So my name is changed already. So this spreadsheet is called budget and that's the first step. So next, like I went over earlier, this is an online platform. So all your spreadsheets are saved to your Google Drive account. So you would have to have active internet connection. And for you to see if it's already saved, there is this icon near the top left-hand corner right here. Let me see if I can make it bigger. Okay. So as you can see right here, I'm hovering over it. It is kind of like a cloud icon and there is like a check mark in the middle. So this will tell you that if you're a document saved or not, and if you click on it, does all changes saved to Google Drive account? Or you your Google Drive. So that's a good sign. So next, I'm gonna go over this feature right here. So it says last edit was a second ago. So every time you make a change in your Google Sheets, a spreadsheet, then it will tell you when was this last updated. So I'm gonna type in something here. Hello. So it's gonna change right here. And if you click on it, it says open version history. So this will be helpful if you wanna save like certain versions of this. And if you wanna go back to it later on or if you wanna revert back to it, then it will be very helpful. And I'll go over this later today. So next, I'm gonna go over the file option right here near top left-hand corner. So if you click on it, there are a lot of options on here. So for instance, I went over how to create a new spreadsheet in your Google Sheets account, but then let's say you already have a Microsoft Excel spreadsheet on your computer on a flash drive somewhere and there's data in there already and you wanna work on it, but you don't have Microsoft Excel, which is kind of like a very similar version to Google Sheets. So you can always click open right here. And then once it says open, a screen should pop up. It's gonna ask you, where is this spreadsheet that you wanna open? So you could select one of these options or you select upload, then you could select file from your device and then you would choose where would this Microsoft Excel file live and you would load it onto your account. So once you load it onto your account, it will be in your Google Drive account and it will be accessible through Google Sheets and you can make your edits like that or you can change this edits, yeah. Okay, so that's kind of how you would kind of load your existing spreadsheets, but then if you don't have that and you just wanna work in the platform, this spreadsheet is already automatically saved so you don't have to worry about that. Okay, so next I'm gonna go over, so let's say you wanna make a copy of this. So if you, so since this is already saved to your Google Drive account, but you wanna make a copy for offline use or send it to someone, then there are a couple options right here. There is a download option. So if you go to file and go to download, then these are your options of downloading, you're especially into various formats. So you could download as a PDF or you could download it as a Microsoft Excel file. Then you could open this file on a Microsoft Excel device or anywhere with Microsoft Excel as well. And if you prefer, you could email this file to someone as well too. And the other option is make a copy. So if you want two copies of this, the exact same copy, you could select make copy and this will make an exact duplicate of this and it will live in your Google Drive account. Okay, so now I'm gonna begin creating a very quickly made spreadsheet. So I'm gonna create a spreadsheet for like budgets. So I'm gonna go over how to enter your data into here as well. So each of these square boxes, it is a cell. So your data lives in a cell. So as you can see, I typed in budget, this is one cell. So this is my data here. And you could type in all different kinds of data in each of these cells as well. And on the left-hand side right here, you see numbers of one, two, three, four, five, six, seven, eight. So these are your rows. So if you click on it, it'll select row one, row two, row three, row four. And if you look at the top, you can see A, B, C, D, E, F. So these are your columns. So if you click on it, it will select the column. So sometimes you might hear your coworker or someone tell you there's information in a specific cell. So they would refer to the cell using these kind of rows and columns. So right now I've selected a cell. So it is in row six and then column C. So this is six C. So right now you could kind of refer to how to kind of enter in your data. So next I'm gonna enter in my data. So let's say food, gas, utilities. And let's see, internet and total. Okay, so I've entered these kind of categories on the left-hand side. Then I'm gonna go to here and let's say January, February, March. Okay, so now I kind of have like the basics of like my spreadsheet. So I'm gonna enter in my data into here. So food, let's say I want, let's say 100, 200, 300, 400. 200, 300, 400, or well, that's not very realistic. So I'm gonna enter more data right here. So 300, 200, 140. Okay, so now I've entered in my data right here. So let's say, so now you might wanna know the total of the amounts that I've entered. So there are a couple of ways of doing that. So one way is right here, I've entered like a section where it says total and you can enter in like a function or formula to kind of calculate your total for you. So give me a second, okay. So now you would kind of want to enter in like a formula. So how would you do that? You would select the cell right here and you would go to the more option right here. So this bar right here near top is kind of like the commonly used functions that you might use it on in your spreadsheet. So I'll go to the three dots right here. Then I'll look for this symbol right here. It kind of looks, it kind of, it should say function if you hover over it. So if you click on that. So these are all like the commonly used formulas that you might use in Google Sheets to help you calculate your numbers. So the top right here, these are like the more commonly used the bottom right here. These are, let's say the Leslie use but then if it depends on your needs. So if you're an engineer, you might use this but today I'm gonna go over the basics right here. So there's some, there's average, there's count, max and minimum. So for example here, I won't want to know like the total of my amount for January. So I'll click on some and make sure to select the cell that you want the information in first. So I've selected the cell right here, B7. Then I'll click on some and notice that there is a sum entered into the cell right here. So right now this is kind of like my formula and in the middle is empty. So I will have to select what I want the sum of. So I'll select the first cell right here or for 100, then notice that it changed. So there is a B2 entered next to the sum and I want to know the total of the entire column. So I'll use my mouse and I'll scroll all the way down. I'm selecting multiple cells. And if you could see right here, it says sum B2 to B5. So it's gonna give you the total of these cells right here. So now the total of these is 650. So right now this is like a money amount. So it doesn't look very obvious. So I might want to change this or change all of it. So I'll use my mouse, I'll click on the cell right here. I'll highlight all the cells right here and I'll change it to kind of like a money format. And there is option right here, format as a currency. It's like a dollar sign. So if you click on it, it'll change all the amounts to like the currency format. So now it's kind of more obvious that it is like a money amount. So it is 650 for my January budget. So if you click on it, it says 650, but if you go up top near here, you could see the formula behind that calculation and you can always change it in the future as well too. So now I have this, but let's say I want the total for February and March as well too. I could go the same route again. I could go to select the function here and select sum and that might work, but let's say I want it quickly. So if I click on the cell that I did use before and it has the function formula in here already, notice that there is a small square box in your bottom right hand corner. So if I click on that, I'll drag it over to the second cell and third cell. It will copy the formula to those cells as well too. So it will do the calculation as well for the next column and the next column. So now the next column total is 640 and the next column is 499. So now this is kind of like a shortcut of you can copying the formulas. So if you have like a lot, then that works as well too. Okay, so now you've kind of know how to use formulas. So this is the very first formula, but if you wanna know something different, then you go back to the formulas section right here, go back to the three dots, go to more and go to functions and click on that and these are all the different ones. So I'll go over one more as well too. So let's say I wanna know the average of my amount. So I'll type in average right here. So you can know the average and I'll click on the cell right here and I wanna know the average of January, February and March. So I've selected the cell right here. So I'll go back to the three dots right here and I'll look for functions right here. And I'll click on that and these are my options and I wanna know the average. So if I click on average, it entered in the average formula and now I can select what do I want the average of and I'll go here, I'll select the cells and it's kind of similar to what I did before for the sum. So average between B2 and B5 and if I'm done, I hit enter. So now the average of January is 162 and 50 cents. And I wanna do the same like before. I wanna know February or March. Then I'll select the cell right here, the first cell with the formula. I'll see that there's a square box near the bottom right-hand corner. I'll click on that and I won't release my finger from the mouse and I'll drag it over. So now it copied that formula to the two cells next to it and now I have the average of these two columns as well too. So that's kind of how you would use like a formula in a spreadsheet. So what I did was I set the cell and I went to the more option right here and I selected the functions and I selected one of these options. But once you get familiar with the, how to enter in functions, then you don't have to do that. You could just do it manually. So I'll set the cell right here and I'll double click and my cursor is right here and how you enter in like a formula, you enter in the equals sign then after that you type in your formula. So I'll type in sum and it will kind of pre-probably like a list right here and you can see there's a lot of sums but I want the first sum. I'll click on that and it will kind of give me more information. I'll select the sum from the cells here as well too. So that's pretty much how you would use a formula. Okay, so next I'm gonna go over how to kind of freeze certain parts of your spreadsheet. So pretend that this is a long spreadsheet and you have to scroll down. So if you scroll down the very top part, the first row, it doesn't stick there. So you won't know like what's the information down here. So you might wanna freeze the first row and that would be very helpful if you have like a lot of information. So if you go ahead, select the first row and you go to one of these right here, you go to view, then there's freeze and it's gonna ask you which rows you wanna freeze. So I wanna freeze the first row. I'll click on one row. So now the first row right here is frozen. So if I scroll down, notice that everything else is moving but then the first row is not moving. So if you have like a lot of information on here, then you can still kind of see like what information is in that column. And the same goes for columns as well too. If you wanna freeze the first column, you could do that as well using the same method. Freeze and then one column. Okay, so that's pretty much how you would freeze the first row of your spreadsheet. So next I'm gonna go over, let's say this doesn't look very good, right? So it looks all the same. I wanna change the coloring of the first row. So let's say I wanna change the bold. So I'll select multiple cells. Go to bold. I'll change the background color. Okay, so now it's kind of bright. So I'll select, I'll enter more information. So April right here. So let's say I want this formatting in April, but then I don't wanna re-select it from here. So there is option of kind of copying like of the format. So it is called paint format and is available here on the left-hand side. It looks kind of like a paint roller and if you hover over it says paint format. So if you click on that, it's gonna copy whatever cell I've selected and it'll copy that format. So I didn't select the cell I wanted yet. So I'll go to here. It's a first cell. It is bolded. There's a red background to it. I'll click on paint format. So now it copied this format and if I click on the cell right here, notice that there is no red background. It is not bold. So once I click on it now, it copied the format from the first cell to the very last cell. And this is especially helpful if you do like a lot of formatting in the beginning and you change your spreadsheets and you don't wanna do the formatting again in the future. So that's pretty much how you do that. So next I'm gonna go over how to kind of create a different sheet in your spreadsheet. So you have one sheet right here right now but you have multiple spreadsheets in your kind of like your workbook. So if you go to the bottom right here, there are a couple of options on the bottom. So the plus sign right here is add sheet. So if you click on that, notice it added a second sheet right now. And if you click on that again, you can add more sheets. So you have one sheet for a different category if you would like. So I'll go back to the first sheet. So if you click on here, it kind of looks like a hamburger. This is all sheets. So if you click on that, it'll let you see all the sheets available. So I don't have three right now. So if you have like a lot, then it'll be more obvious here as well too. So now if you go to one of these sheets right here, if you click on the downward pointing triangle right here, if you click on that, it'll give you more options of what you could do with your sheet. So if you decide you don't want it, you click delete. If you like it, you wanna duplicate it. You click duplicate, it'll make a copy of it. You copy this spreadsheet to a new spreadsheet or existing spreadsheet, rename it, change the color. You could protect the sheet. So if you don't want anyone to kind of delete it, then you could protect the sheet. And since you could share this with someone else, you protect it and other people can't make changes to it. And I'll go over how to share the sheet later on today as well. And if you have like a lot of sheets here, you could click hide sheets. So it'll still be here, but it just won't show up. So you won't have to go through a whole bunch of sheets. So let's say if you have 10 or 20 and you only use like five of them, you could hide the rest. So that's pretty much how you add like another sheet to your spreadsheet. Okay, so next, so I'm gonna go over how to delete rows and columns. So right now I have April right here, but let's say I don't want it. So if I go here, I'll select E. And if you right click, you could delete this column. So delete column. So now that column's gone. So if I don't want a row, I'll select the appropriate rows that I don't want. Let's say I don't want row eight. So I'll right click and I will delete row. Or if you prefer not to delete it and you will just want to hide it because you might need it in the future, you could click hide row. So now that row is gone it says one, two, three, four, five, six, seven, and nine. So the row's still there, but it's just hidden. So if you want to back, just click on it, the arrow pointing up and it'll give you that row back. Okay, so that's pretty much how you delete and add like a row. So if you want to add more rows to, if you click here, say I'll select C, I'll right click, insert one left, one right. So let's say, I'll do that. You insert that and you do the same for rows as well too. Okay, so now I'm going to go over how to sort your information. So this is a small set of data, but let's say you have like a lot of information up here and you want to sort it out. So if you go ahead, select the first cell up here, one A, and you go to right here, see, you click on the three dots for more and it should give you the options right here. There is a create a filter option. So go ahead and click on that. It's kind of shown by like a glass, so click on that. So now I've created kind of like the sorting option for these two columns right here, but let's say I want all of them. So let me go back, undo first. Okay, and also I'd like to mention the undo option. So if you want to go to edit and undo, this will be very helpful if you make a mistake and just go ahead and undo whatever you did or you could do like a shortcut on your keyboard control Z. So now I want to sort all of these. So I'll go ahead, select the first cell and I'll select all of these cells right here. Now I'll go back to the three dots right here, more, then I'll select create a filter. So now it kind of gave me the option right here of sorting my information. It's kind of obvious from these three lines right here, near the top. So I'll click on that and I could do sort. Sort A to Z, sort Z to A, sort by color. So let's say sort A to Z. Then now I'll sort Z to A. So now it's going to sort my data here and it might be helpful if you have a lot of information you want to see your information in alphabetical order. So it depends on your needs. That's pretty much how you would sort your information. So next I'm going to go over how to create a chart from your information. So there are a couple of ways of creating a chart. So the easiest way would be to look for the chart option right here, near the top. If you go through the bar right here, look for the chart option. So it's kind of obvious by like a square box and there's like a couple of lines through it. So insert chart. So go ahead and click that. So it's going to pop up some information. So there should be like a blank chart right here and there should be a chart editor option on the right hand side right here. And it's going to default to a column chart under chart type. So it depends on what chart you want. If you click on the downward pointing triangle right here you can select the appropriate chart and you can scroll through it. So let's say I want, let's see. So let's say, I like a column chart. So I'll select column chart. So now if I scroll down, it's going to ask you your data. So right now it is blank. So it doesn't know where to get your data from to create the chart. So I'm going to go ahead, select the box with the plus sign right here, select data range and a popup should show up and it's going to ask me where it's by data. So I'm going to erase that and I'm going to select my data. So I want to create a chart of all of, let's see, one of this. Then notice it changed. So select data range A1 to B5. And I'll select okay. So now it changed. So the screen before it was empty. Now I have a chart right here. So the chart is from my utilities, internet, gas and food for January. So right here, this is my chart. And there's not much information on here. So you might want to add more to it. So if you go to customize right here, near the right hand side, you can add chart access title, series, legends. So go click on that chart title. So enter in monthly budget and that's going to change on my chart. So say I want bold and that's I want it in different color and that's pretty much how you create chart and kind of customize it to your needs. And there's more options on the bottom right here, horizontal axis, vertical axis. If you have time, you can take a look and you could do like a little modifying and changing yourself. So that's pretty much how you could create like a basic chart of your data. I'm going to click X and now I'll move this chart over. So now this chart is connected to the data set that I've selected earlier. So what if I want to change it? So if I click on any of these cells right here with the data, I say I change food to 200. So that's going to change on my chart as well too. So let's say 1000. So that's going to change. So it is connected. So another way of creating a chart is the explore option. So there is explore option near the bottom right hand corner right now. Let me make it bigger. So it's kind of obvious by kind of like a box with like a star in it. This explore option, if I click on it, a screen should pop up and it'll give you some kind of suggestions of what you might do with your data in your spreadsheet. So you could change the formatting, you could ask information about the data and it will kind of give you like an answer as well too. So it would give you kind of like a preview of what kind of charts you might want to do. So like this pie chart right here, this column chart right here. Or this chart right here as well. So this is very helpful if you're on the go or you just want like a quick chart of your data. So let's say I want a this chart right here. So all I have to do is click on it somewhere in the middle, I'll drag it over. Then that's going to create this new chart for me in my spreadsheet right now. I could do the same for the others as well too. So let's say I have this chart and I like it. So I hit X. So now I have two charts on my spreadsheet right now. But let's say I have a lot of data on here and I don't like that. So I want to move it to like a different spreadsheet. So if you click anywhere inside in your chart, there's a three dots near the top right hand corner. Click on that. It'll give you more options. So you edit your chart, delete your chart, download your chart, copy your chart or move to own sheet. So I'm going to select move to own sheet. So now notice that it's a lot bigger. It's in its own sheet. And if it go to the bottom left hand corner, there's chart one right here. And my original sheet is sheet one. So it's no longer in sheet one. It's in a different, in its own kind of space. Okay, that's pretty much how you would create a chart using the explore option. But the explore option is not just creating charts. There's more options in here as well too. Okay, so next I'm going to go over kind of how to get like quick information about your data. So if you have a lot of information on here and you just want like a total or average of certain amounts, then you could do like what I did before using a formula to calculate it or you could just highlight it. So if you, if I want to know the information from these three cells right here, I will highlight it. And if you look on the bottom right hand corner of your screen, let's see, I'll make it bigger. So right here, there is kind of like a total of it. So this sum, 340. So it kind of totaled up these three cells right here. If you click, if I click on the downward point triangle right here, it'll give me kind of like the basic information about what my information is. So sum, average, minimum, maximum. So this is very helpful if you want to know certain amounts in your spreadsheet, but you don't want to do the calculations because maybe your boss is asking you how much is this for this time period, you can do that. You don't have to do the calculations. And all you have to do is select the cells in your spreadsheet and look to the bottom right hand corner and it'll give you all of these basic information, okay? So that's pretty much how you would kind of get quick information about your spreadsheet. So next I'm going to go over what you would do with your data. So for instance, so let's say you have a list of names in your spreadsheet all in one cell, but then you don't want to kind of separate them manually. You want to separate them automatically. So I'm going to type in some names right here. So on the left side of the screen right here, I have two names and they're a first name and last name in one cell. But let's say I want them in two cells because that might be easier for you to sort through. So you might want to sort it by last name instead of first name. So if I select it right here and I go to one of these options right here, give me a second, I'll go to data. Then pretty much these are the options that you might want to choose to help you with editing your data. So there's this option right here. So split text to columns. So if I click on it, this screen should pop up, it says detect automatically and I'll click on it and I'll select space. So now it separated my information in one cell to two cells. So now if I have a long list, I could sort it by first name or last name. And I'll do that again one more time. I'll select the second cell, I'll go to data and I'll go to split text to column and I'll click on this and space. So now it split my information to two cells. So that's pretty much how you would split your information. So what if you have like spacing in your cells that you don't want? So let's say, so I'm gonna leave like some spacing in the front and I want to leave some spacing in the back. So now there's a lot of spacing in the front and the back and I don't want that. So I'll select the cell, I'll go back to data. I'll go to trim white space. So I'll click on that. So now it says trim white space from one selected cell. Click okay and it removed all the spacing in front and in back. So next I'm gonna go over how to remove duplicates. So you might have a long spreadsheet of information and there might be names, there might be phone numbers, there might be duplicates and you don't want to look through them all because there might be a lot. So I'll select the information first. So I have a small set right here. I'll go back to data and I'll go back to see go to remove duplicates. So I'll click on that and I'll click on remove duplicates. So I had one duplicate in there and so it told me that it removed one duplicate rule found and removed. So this is very helpful if you have like a long list, you have a long list of maybe similar people, same address, same phone number. So you can kind of clear off your data like that as well. Okay, so that's pretty much how you do that. So next I'm gonna go over sharing. So since this is a web-based platform you could share your spreadsheet with someone else or a group of people and the easiest way is to go to the share option right here near the top right-hand corner. So you click on that share and a pop-up screen should show up and you could do, you could share a couple of ways. So you could add people to share with, you could enter in their email address here and then once you're done, you're done and this spreadsheet will be shared with that person or group or if you prefer, you could get a link and you could go here. So change to anyone with a link. So now it created a link for this spreadsheet and you copy the link and you email the link to your friends, family members, your coworkers and they will have access to this spreadsheet. And there are a couple of restrictions where you could put on for sharing. So right now it says anyone with this link can view this spreadsheet. So if I click on the downward pointing triangle right here I can change viewer to commenter. So the people you share with, they could kind of view your data, they could leave comments or they could be an editor and they could change information in your spreadsheet as well too. So let's say I want editor. So once I've done that, I have a link, I hit copy link, I hit done. So now I can email this link to anyone I want and they have the option of editing my spreadsheet. And since this is an online platform, they can edit and you can be in the spreadsheet as well too. So you guys could both be editing, you could have like 10 people, they could all be changing information on here alive as well. And that's pretty much how you would share your spreadsheet. So next I'm gonna go over how to comment on your spreadsheet. Since you're sharing it with a couple of people or one person, you might leave comments. So some people might like what you've done here, some people might have questions on there. So let's say I'll select one of these cells right here. I'll select food, I'll select January and this is 1000. So let's say I think this is very unrealistic. So I wanna make a comment. So I, there's a couple of options. So let's say I right click and I will select comment right here. So now this is your name and you can add a comment to it. Let's say I don't think this is real. I'll hit comment. So now this comment is associated with that one cell right here. So anyone that has access to this spreadsheet will take a look at it and they could see the comment and they could reply back or they could just dismiss it. So there's a checkbox right here, mark as resolved. So once you think anything's resolved, you hit that and that comment will be gone. And you could check the comment history of your spreadsheet as well too. So if you click on the kind of like the comment icon right here near the top right hand corner, it kind of looks like a bubble with some lines in it. If you click on that, it'll give you like a pop-up screen and you can see the comments. I don't have one comment today. So it's showing right here and it'll show you like what has been done to the comment. So mark that as resolved, okay? So that's pretty much how you would comment on your spreadsheet, okay? So that's pretty much my presentation on Google Sheets. I know there's a lot of information and there's a lot more to learn about Google Sheets as well too. So the library does have a couple of resources available for you. So I will go over that briefly. So if you go to our homepage, which is sfpo.org, you'll have access to some of the available resources. So right now on the homepage, if you click on the research and learn icon right here, a pop-up screen should show up and there should be e-learning right here. So if you click on that, you'll bring it to the e-learning page. And these are the available platforms that are available to you if you have an SF Public Library card. If you do not, you can always sign up for one from our website sfpo.org if you are a San Francisco resident.