Beginners Google Sheets Tutorial - Lesson 2

hi everybody my name is Jamie and welcome to  teachers Tech and welcome to my second lesson   on Google Sheets for beginners this is going to  cover a lot of important information for Google   Sheets to make sure you get effective when using  it I have the complete practice guide Down Below   in the link it will automatically create a copy  for you and you can follow along step by step   in this beginner's tutorial for Google sheets  I'm going to be continuing on with more Google   sheet tutorials so after this let me know in the  comments what else are you looking to learn look   at the timestamps Down Below in the descriptions  you can jump around this at different points if   you know exactly what you want to learn I  want to start by showing you two different ways to

autocomplete or autofill data inside Google Sheets  and I want to make sure that under Tools autocom   complete that you have these checked on by default  they should be on so we're going to go over two   different methods we're going to look at the fill  handle and Smart Fill to speed up your data entry   let's start with speeding up your data entry by  making sure that you're capitalizing on AutoFill   in Google Sheets so we're going to be using the  fill handle which is right here this blue circle   that I can drag in different directions when  I do this on certain things this is already   built into Google Sheets let's say January and  I drag this down it already knows that there's   a pattern there and it keep continuing on with  it now the other thing you can go let's say is   days so it recognizes the days the week and we'll  fill it in and even if they're abbreviated it will   know to follow that pattern with whether it be  the months or even the days now if we have let's   say the number one I try to copy this down notice  it doesn't go through and start adding up because   it doesn't recognize the pattern or what I want  it to do yet so I'm just going to go contrl Z now   if I put the number two in here and then highlight  these two I can go and drag down and then it knows   the pattern and it's going to continue on I can  create a pattern here let's say if I wanted it   to count by 10 or sorry fives if I put uh 10 in  here and then I highlight both and drag it down it   knows to continue the pattern in that format you  can even do this with dates so if I have drag the   dates down it's just going to continue on uh going  each one thinking of how I'd want it so if I had a   pattern in it would recognize the pattern now  I've been doing this vertically but I also want   to show you can do this uh across horizontally  so if I drag January this way it will continue or   Monday this way are the abbreviations and the same  thing with the counting on it remember to add your   second number and go through the other thing  I wanted to point out you can go in the other   direction so whether I was doing vertically or now  horizontally if I go through and click on this one   and drag it this way notice it starts to fill it  in from December November so this will turn to   Sunday this way when I would pull it to the left  same thing with the abbreviations or make sure   with the numbers drag it this way I'll go into  the negatives and with dates I can drag it this   way and notice it's going to be in the previous  year as went before January so I just want to make   sure to start with that you recognize the power of  autofill and just using the fill handle and Google   Sheets smartfill is another important feature  inside Google Sheets to take advantage of let   me show you how this works I'm going to want to  break this name right here Emma Johnson into   two now that doesn't take long to do one but I  want to do this entire list smartfill can help me   with this so let's go ahead and click in this cell  here if I start typing Emma here and then I go to   Noah and usually when I get to my third one so if  I have a long list you can see how this will be   very beneficial it offers me a formula suggestion  now this is done by creating a formula I could go   ahead and show the formula and they're using the  left function and then you can see how the formula   is built if this is what I want I can go ahead and  approve it here accept it and then it's all filled   out so I can also do this with the last name so if  I start typing Johnson and remember I can't have   any typos or it's not going to work and then we'll  type Smith and better type that correctly and then   I go to the next one and usually as soon as I get  to the third one it gives me that suggestion I can   take a look at the formula being used go ahead and  approve it so you can see how this can save you a   lot of time when you're uh con of try to separate  to different cells but you can also use it to   combine cells and in this example I made three  different columns here I could have two different   columns it's just going to be picking up the  pattern on the data that's there so I want to have   all the names in inside one cell so it's going  to combine these three cells so I already put   two into just started here but I'm going to go and  start typing uh Ella again can't have any typos in   here uh so I type Ella and then Smith and let's go  to the next one and when I usually start typing uh   there's the list right here and it's going to  autocomplete this with the initial in it if I   go to show formula it's using the concatenate  to combine different cells and I you could do this   by yourself with just typing this formula but the  autofill creates the formula for you so if I click   on any of these cells you can check up in the  formula up here now if you're used to Microsoft   Excel with their flash F The Flash Fill that's a  lot more powerful than this one it can separate   and combine things at a lot higher rate I do  want to point out something that's coming through   Google that was just uh shown as an example a  couple months ago so here is how they're going

to uh put AI inside the Smart Fill they're going  to call it enhanced Smart Fill and these are just   I'll put the link to this uh page here Down Below  in the link so you can check it out but they're   giving examples here where it's autofilling based  on the reviews that are there using AI so there's   a few different examples uh that they're showing  that it can read through this and then know what   to put so you can see how this will speed up your  data entry even more when this AI is built through   Google Sheets when using the enhanced Smart Fill  let's move on to other ways we can combine cells

in Google Sheets I just showed you smartfill and  that way worked great it recognized a pattern and   created a formula using a function to combine  them now we're going to kind of dive into   those different functions and formulas creating  them on your own so you just understand what's   happening let's start with this one right here  concat uh and then we're going to work our way   through these different methods and I kind of like  text join the best for what I want to do in this I   want to combine these different ones with spaces  into one cell so let's go over to this cell right   here and I'm going to start when we start with  our uh formula we need to start with an equal   sign so we put our equal sign in and I'm going to  just start typing the function's name and it is   concat here it is right here so concatenation of  two values notice there's concatenate which we'll   cover in a little bit too so I'm going to select  this one as soon as you select it remember when   you're using uh creating these formulas you can  get some help so if I click on it kind of shows   you how this is set up notice that there's value  one a comma then value two all you can do   is two different values with concat and I wanted  three so I could go ahead and select uh this cell   right here A2 put my comma in and then select my  second cell and just hit enter and that's pretty   much all I can do I can't go back and put a space  in this one I can do the autocomplete now so if I   go and drag down just like I showed you before  it will copy that formula all the way down but   it's not a great examp example because I can't go  ahead and put these spaces in here and I can't get   that third column as part of it using the Amper  sand sign is a great easy way to combine cells   so let's Show an example in this cell right here  I'm going to start again my formula with an equal   sign and I don't go to any function because all  I'm using is the symbol what's my first cell it's   going to be A2 this one and now I can go ahead and  place the Amper sense sign so that's my shift F7   and then I can go back and just click on this one  B2 and it's already showing me what it looks like   I can go put my another emper and sign in and  then click my last one and it shows me what it   looks like I could hit enter and this allows me  to use the autocomplete uh with the fill handle   and copy it down but you can add spaces to it and  it's quite easy to do this so I'm just going to go   contrl Z to undo that last step and rather than  do this all over again I'm just going to double   click in here because I can format it so what I  want to have happen is after that first uh ersan   sign all I'm going to do is add a quotation  mark here and then put a space in and then   add another quotation mark and then add another  Amper s sign it's showing me now there's a space   between Jon and snow so if I hit enter there it  is now I'm going to go back to this one again   I'll just double click on this one I could format  it over here in the function uh line up here but   I'm going to go after this one here and I'm going  to put my quotation mark in but this time I don't   want to have a space let's say I want a hyphen  so I'm going to give it a space on each side   close my quotation mark and put another Ampersand  sign in and it shows me what I want so it has The   Hyphen in it so I'll go ahead hit enter and if  I copy this down this time this kind of gets to   where I wanted it was able to combine those cells  I was able to have the spaces put in a different   delimination where I want it and copy it down  now let's look at the concatenate function inside   Google Sheets this is what smartfill created when  it went through and suggested how to do it on the   previous exercise I'm going to click in this cell  start with my equal sign start typing concatenate   here it is right here so it pin strings to one  another I'm going to select this one and this   is how quickly we can combine using concatenate  if I just go ahead and select these three could   be more I hit enter and it went through and put  those all together not with it doesn't have the   spaces and I want the spaces there is a way we  can do this the other thing I want to show you   with concat Nate and I'm just going to delete  that and start typing it again I can pick more   than just the three across look at this so if I  highlight this right here so here's an array I   could go ahead and hit enter and what it did  it took all of those right here and put them   into one cell so not that I want that but I want  to show you the capabilities of it so to get the   spaces what I need to do with this concat Nate  is actually go cell by cell uh similar to concat   I'll go and type concatenate again and this time  I'll select on the first cell here add a comma   this allows me to enter my delimination which is  the space so I can go ahead and put my ex my uh   quotation mark put the space in it add another  one put another comma click on the second cell   add a comma and then what do I want in the next  one well this is going to be a space well maybe   I'll do what I did before and I'll add the hyphen  in another space and put another quotation mark   add a comma click on the last one here and hit  enter so now I have Jon Snow the wall very similar   to what was created here and I can drag this down  grab the fill handle drag it down and autocom   complete these now let's go to this next one text  joint and I really like the way this one let's go   ahead and start this formula so we'll put our  equal sign and start typing text join here it   is here so I'm going to hit the question mark so  you can see what we're going to be doing the first   one is going to be putting in the delimeter so a  delimeter is like this is like the space or hyphen   or what we want in those spots then the next one  is going to be a true or false so this will look   if there's going to be an empty cell if it's true  it will ignore it and I'm going to leave it to   true and then we make our selection of the cells  that we want so let's go ahead and do this so the   delimiter in this case is going to be uh just the  space so I'll put the space in just like I usually   do and then we'll add a comma after this and  what's going to be the next part well I'm going   to call this true in case it's an empty cell and  would be false again the other way so I'll put my   comma and what do I want now well I'm just going  to highlight these right here and I can hit enter   so look at this it went through put the spaces  in makes it easy to copy down and this is text   joint so that's another option to combine cells in  Google Sheets now I have some quick data cleanup

tips for you so here's the first one and I'm under  the split text tab down below what I want you to   do is take a look at this so if I click in A1 you  can see all this information is in A1 it's from   their name address and email and then so on to A2  I want to split this into separate columns so if   I go ahead and then just select this information  go to data up here and I can go to split text to   columns as soon as I clicked that notice it took  those right through here so the separator detect   automatically you can see the different options  that you can pick uh from these different ways I'm   just going to leave detect automatically and then  just like that I took those that were all in one   cell and put them in different columns let's try  something else to clean up your data and I'm going

to go to the next tab data cleanup you could have  maybe blank rows or you could have duplicates get   so I'm going to go ahead and select what I want  to clean up I'm going to just select uh the area   through here like this and I'm going to go back  to data and we're going to go to data cleanup you   could try cleanup suggestion I give that a try I'm  just going to show uh remove duplicates and when   I select this does this have a header row well I  didn't have the header selected so I don't need to   turn this on I'm going to go select all and I know  there's a few uh duplicates in here so I'm going   to go ahead and hit remove and look how so it  found five duplicate RADS found and remove seven   unique rows remain hit Okay the reason it didn't  delete this one uh is because it took the two   duplicates that were uh that were blank rows and  now I could just go ahead and clean up this last   one too but if you use the uh suggestion uh on the  data cleanup it will actually uh go through and   will even suggesting deleting the blank rows as  as well cell referencing is an extremely important

concept to understand when working in spreadsheets  and formulas and copying and we're going to be   talking about two different things of relative and  absolute cell referencing now let's start with a   little example I'm on the cell referencing tab  I'm going to just do a little formula here this   is week one total so here's my price per unit and  it's going to be week one sales so I just need to   multiply those two and I'm going to use the cell  so I'm going to hit equals to start my formula   and click in this cell and use my multiply symbol  here and go ahead and click on week one hit enter   autofill looks all right and these numbers are  correct uh so I can it just copied the formula   down it moved down as needed the issue is going  to happen is I want to be able to just copy it   over one uh for I could create a brand new formula  in here but to speed things up it'd be nice if I   could just copy this over just this way but when  I do you can see already this number isn't right   I don't have the formatting of the dollar sign  on here but 7 780 is not even close to what the   amount should be what's happening so if I go to  view I can show my formulas here if I click on   it so C4 * D4 this is C4 time D4 that was correct  but when I copied it over the other way now it's   D4 * E4 so in D4 here so if I click in here it  multiply Week 1 Sales time week 2 sales well I   needed to stay in here when I copy to the right  I need to lock it in to column C I don't want it   to move relative so I need to add an absolute uh  to this so make it absolute relative so I'm going   to go ahead and just delete this here uh and I'm  going to go and just show my uh normal view here   so under view I'm just going to turn off formulas  so let's go ahead and delete everything and start   over again now if I go and start my formula this  time and when I click on this one I need it to   stay in column C when I copy it over to the right  and so I need to make that uh absolute so we have   two different things we have columns and rows I  need to make the column so which is C absolute I   need to put a dollar sign in front of it so quick  ways to it I could type the dollar signs in but   I like to use my F4 key so or function F4 if I  press it once it put a dollar sign around the C   in front of the C and the four that means absolute  absolute that's not what I want I need it to move   when I drag it down but not drag it to the right  I'm going to press F4 again so now this time it's   in front of the four which is the row that's  not quite right I need it in front of the C so   I'm going to press it just one more time so now I  have absolute and relative so when I drag it down   it will change but when I drag it to the right  it's going to stay in column in that column C so   now I'm just going to finish my formula here I'm  going to H go and multiply this here and hit enter   autofill yes the numbers stay the same uh I'm  not going to show the formula well even if I just   click in here you can see equals C6 there's the  absolute and it doesn't change this way because   this way was working before but where it works now  if I drag this over this way look what happened   $15 well this looks correct so if I click on this  spot right here I'm just going to double click in   here C4 * E4 it's holding the column so I made  this absolute that dollar sign kept it in this   but when I uh brought it over it was E4 it dragged  over to relative here so the nice thing is I can   drag this all the way down now and everything is  going to be working correctly on this so that's   the first step of having it absolute relative now  I'm going to throw in a tip here and I'm going to   show you uh if we were copying it down and we'll  do an example of relative absolute I'm going to

take this same table here and I'm going to just  go contrl C for copy and I'm going to put it   down here but watch this when I rightclick and I'm  going to paste special I'm going to transpose this   so if you didn't know about this will switch  my table notice uh that I have my days across the   top in instead of going across uh on the side here  so you can quickly change your uh your information   around this way I'm going to go ahead and delete  this here and let's do this example again so our   total so if we're doing our formula this time and  I want this right here so now I I want the uh   letter to change as I drag it to the right so it's  going to be the 15 that I need to lock in place so   I'm going to go ahead and use my F4 and I'm going  to hit it a couple times there that's what I want   I want to Absolute that uh 15 in place there and  I can go ahead now and just do my multiplication   hit my week one sales hit enter and there it is  $13 uh they've already started filling this in so   I don't want that built in for this I can just  drag it down like this so I'm getting the same   numbers from up top so this all looks good so now  I can go ahead and drag this all this way and if   I click in any of these here see D15 it's locking  it into that 15 spot so if I copy either of these   over I this is all working the same here but I had  to change where the absolute is so in this case   right here this is going to be relative because  the dollar sign isn't in here and absolute here   so there's one more example that I want to show  you and that's absolute with this cell   referencing I need it to be locked in place when  I copy my formulas around let's go ahead and just   do a function here totaling up our two weeks I'm  going to put in a equal sign and type the word   sum we're going to choose this one here and select  the information that I want to sum and this looks   correct with the autofill I'll just hit yes now I  want to apply a discount and the discount is this   point 2 up here if I was going to say let's say  equals and I'm going to multiply this spot and   it's just going to be multiplied by this spot  right here if I just hit enter yes this is the   discount that works correct that's awesome but  the issue is when I try to copy this down well   you can see there's some issues here so what's  happening when I brought it down if I go ahead   and let's click in this spot right here actually  we'll click in this one so you can see so H7 * B4   it was clicking here H7 that was correct but then  times B4 that's mult trying to multiply it by   apples well that's why it's not understanding  a formula there you can't multiply 0 2 or the   total time apples that won't make any sense so  let's go ahead and make some changes to this I'm   just going to go ahead and delete all of this here  let's try this again absolute so hit the   equal sign and we're going to say this and when  we copy this down this is going to stay the same   we're just going to leave this relative and I'm  going to multiply this by this spot but this time   I'm going to use I'm going to go to my F4 here so  I'm going to hit it once that is absolute absolute   this will lock it into place so watch this  if I hit enter now look at all the numbers those   all look correct the suggested autofill I'll hit  check mark yes so anytime I try to click in any   of these it's always going to stay as B1 so when I  drag them it's going to lock those in place that's   absolute so this is an important concept  to understand and this will save you a lot of time   when you create your formulas and start copying  them over to different places let's get into how

to sort and F filter data in Google Sheets but  you notice right now I have no data to sort or   filter I want to bring some in so I have a little  bit of a tip for you I'm going to import data from   the web so that it comes into here so I can sort  and filter it and the page that I'm going to take   it from is this so I'm just going to have some uh  top movies here right here and I want this table   to be imported into Google Sheets so just before  I do this and I'll put the link down below so you   can cop go to this page and copy it too I'm just  going to go ahead and copy this one right here   and I'm going to move this out of the way so I'm  going to go to A1 and I'm going to put an equal   sign in here and I'm going to start typing import  HTML right here so I'm going to click HTML now   the first thing I need to do is start it with a  quotation mark and then paste what I just copied   that URL just like that and then I have to put  another quotation mark and then place a comma   so now notice I'm at the query stage and this  is just do I want it as a list or a table I'm   going to say table we need to use our quotation  marks around this and then type table so on each   side the quotation mark and then uh put a comma  and the index well there was only the one table   on that page so I'm just put going to be putting  the number one and I'm going to go ahead and end   the bracket and just hit enter it's loading  and this will happen quite quickly you're going   to see all that information boom right into this  so it took that entire list and brought it into   here so I could do some formatting if I select  everything by clicking up here and I'll just   click in between a everything gets sized there  all right now we have some data let's go ahead   and do some sorting and filtering now that  I've imported this from the web I'm actually

going to copy these rows over to a brand new  sheet so I've already made the sheet for you   you're going to see it's going to be to sort and  filter so just go ahead you can go contrl C or   you can rightclick and copy and I'm going to move  over to this blank sheet here and I'm just going   to contrl V and paste this in so now this part's  not connected pulling it from the web anymore now   the next thing what I want to do is I'm going to  freeze this top row here because when I do my   first sorting and I'll show you what I mean here  if I do a sort uh Google sheet makes this really   easy if I just say I'm going to you know sort by  the year here so I'll go drop down and we can go   A to Z or Z to A so we're talking you know if I  go to a to z uh you can see it went from the uh   the furthest of way 1963 and it went all in order  from all the time you can see how I did that but   notice that the header went away I'm going to go  undo so contrl Z undoes and I'm going to go and   freeze this top row right here so I'm going to go  and just go to view freeze and I'm just going to   freeze this one row so now if I go ahead and do  a sort and this time let's say I do Z to A you   can see that this is staying in place this isn't  getting into the sort we're going to keep this in   place here so as I move forward that's what it's  going to be so that's going to be the first sort   now I could do this to other columns as well so  if I was going to go drop down and then sort A   to Z you can see now how it goes through versus  if I so we can see where the a is starting where   the numbers are this has a symbol here versus  the Z to A and everything adapts so some quick   easy sorting that way another way you can sort is  go up to the data here and then you can see sort

sheet notice sort range isn't uh I can't select  it because I have to select the range so let's go   here now I could select just one column here and  go up to here and notice I can select this now but   what I want to do is actually select two of these  because now when I go up to my data and sort the   range see I can sort range by column C A to Z or  Z to A I'm going to go to Advanced range sorting   when I do this I'm going to say that data has  header row so when I select this notice now I can   uh choose between the two different ones so the  first one I'm going to say distributor and then   I can add another sort column so if I add another  sort column and say by genre and I'll just keep   them the same but you can see how you can switch  them back and forth depending which way you want   to sort it and you can delete it here or I could  even add more but I'm going to go sort now take   a look at this so it went through and sorted  the distributor but within the distributor   it sorted the genre next so notice that the all  the Adventure ones are put together here actions   out here so if I scroll down uh it went to a24 but  then it put all the dramas together so there's two   different sorts using the advanced sort now I want  to show you how filtering Works in Google Sheets

if we go up to the data tab here notice that we  have create a filter and filter views these both   allow you to examine your data to dig down and  look to see what really it means now when you   create a filter what I'm going to be doing right  now I want to be clicked inside the table here   inside the data somewhere and then if I go up and  I create a filter as soon as I KN do that notice   the filter symbol under each of these here now I  want to point out as we filter this will become   the view that if you share this with other people  this is what they're going to see as well if we   do a filter view people can individually do this  but let me finish with the filter here so if I   wanted to filter by uh distributor here and I just  click on the filter and notice I have if there was   conditional formatting I could go through here  and pick all these different ones or conditions   or values I'm just going to go ahead and hit clear  all and let's say I only wanted to check on a few   different one of these so if I wanted to say you  know what I want to see uh what's happening with   Walt Disney and Warner Brothers as soon as I hit  okay notice everything gets uh updated on my data   only those two Distributors but I can still keep  filtering so if I go to oh you know what I want   to see by genre and I'm going to hit clear all  and I want to see it by adventure action and I'll   say drama and then I can just hit the okay down  below so now I have it filtered by Walt Disney   and Warner Brothers and inside this you can see  also that there's Adventure there's action and   drama between the three different ones so filters  are very powerful to really sort your data but   remember when you apply these filters like this  this becomes the view for everybody if you're

working with other people and you don't want to  disturb as people are working with by putting   these filters in this is where we want to go to a  filter view so I'm going to go to data and filter   View and I'm going to create a new filter view so  when I do this now notice how it looks a little   bit different around this is filter one I can name  this so maybe I'm going to say uh this is going   to be by distributor and I'll just go through and  call it that and now I can do my sort so if I was   going to sort by uh certain ones so I'll this  pick clear and I'm just going to go ahead and   pick just a couple random ones right here and  let's do the same thing and we'll do a couple   genres here we'll clear and we'll see if any of  the filters come up on these ones so if I get a   few of these I hit okay so there we got our Warner  Brothers Universal 20th century Studios and then   we also have it uh broken down into the different  ones so if I go up to data again what I want to   point out is under filter views notice I have one  called distributor the neat thing about this so   if I have this document shared with other people  they're going to be able to see this view here as   well so they'll have the original document that  they can be working on creating their own views   and sharing it with other people to point out how  they're examining the data but you just have to go   right here and we can also close out uh we also we  have a settings here where we can update the range   rename delete or duplicate or close out uh from  here as well so those are different ways that you   can filter data inside Google Sheets now I want  to introduce you to how to use the if statement in

Google Sheets so this is a very popular function  that's important that people start to understand   and we're just going to go with a couple basic  if statements to start with okay so we're going   to place our if statement right here we need  to have our equal sign just like before and   we're going to type just if and here it is right  here so when we do an if statement what's going   to happen is we're going to say if this happens  then do this otherwise do this so that's kind of   the structure of an if statement so let's go ahead  and select this so what's the logical expression   so I'm going to say if this right here so I'm  going to click in this spot C7 is greater than   and we'll just make up a number let's say if it's  greater than uh 600 we'll just put 600 in there   for now then we're going to go comma so we have  our logical uh expression then what happens   if it's true well I want it to be saying doing  good and when we want it to say something this   is where we need to have our quotation marks so  I'm going to put the quotation mark and say doing   good just like this and then comma if I don't want  it to say anything I'm going to just use a double   quotation mark uh just to say bring back an empty  spot so I'm going to go ahead and finish this and   hit enter now it looks like it's blank did it work  well we said if it was greater than 600 so we know   it's not greater than 600 let's see what happens  when we copy this down if I drag this down now   notice anything above 600 they it said was doing  good it was only this first one that uh said uh   if it was below 600 now what else can we do with  this well let's do this one more time here so if   I go and start my if statement again if I type if  and this time I'm going to use cell referencing   and some of the things that we've talked about  already with absolute values so I have my if   statement I'm going to select it again so I'll say  if this right here is greater we'll just use the   greater again and I'm going to click on this  cell right here so I can click on this cell and   remember talking about cell referencing when  I'm copying it down I need it to stay locked   in that so I need to go absolute so I'm  just going to go ahead and hit F4 and there's my absolute so this is now I can carry on I'm going  to put a comma in here so what's the value if true   well I can go ahead and click on this cell right  here doing good and again remember I need to make   this absolute because I'm going to be copying this  down so I put F4 just like that otherwise now I   could use my double quotation mark to put a blank  back or else maybe I wanted to say something else   bad month here and then I'll  do my uh function F4 and I'm going to go ahead and   close this So based on what this is it's going to  look at that $500 and if it's above 400 it should   come back with saying doing good if it was below  it should say bad month let's hit enter there we   go doing good so if I copy this down I can drag  this down here and they're all doing good because   there was nothing below that but let's take a  look now this will all change dynamically if   all of a sudden this turned to 300 here and I hit  enter it changed instantly over here now the thing   is why you want to be using cell referencing like  this because you can update these changes so what   I mean is what happens if doing good changes  if it's now uh going to be 800 so as soon as   I put 800 here this all updates down here and I  can write something different also so it doesn't   maybe have to be a bad uh bad month and I'll just  say so just like this and notice how that   updates so that's why you want to be using cell  referencing rather than just the individual cells   like this because then you can just make a couple  updates and it changes everything so that's just   the beginner step to the if statement in future uh  these Google Sheets tutorials I'm going to go dive   a little bit deeper and do nested if statements  with other functions inside of it that brings   us to the end of this Google Sheets beginners  tutorial lesson to I'm already starting to plan   lesson three so I'd like some feedback to know  what specific things you are looking for thanks   for watching this week on teachers Tech I'll see  you next time with more Tech tips and tutorials