Master Excel Basics in NO TIME

hi I'm Jamie and welcome to teachers Tech and  welcome to my beginnner class on Microsoft Excel   the reason I'm creating this class is because I  want you to feel more confident using Microsoft   Excel if you have a job interview coming up and  you want to be prepared when they ask you those   Excel questions maybe this is part of your job  requirement and you haven't looked at Excel in   a while and you need a refresher on it taking a  class or a course and the instructor is asking   you to do something with Microsoft Excel and  you need to know how to do that or maybe you   just want to make yourself much more marketable  with this valuable skill so in today's class I'm   going to show you how to use Microsoft Excel  it's aimed at beginners but we're going to   level all the way up so you're going to feel very  confident with Microsoft Excel when you're done it let's go ahead and open up Microsoft Excel  now I have it on my taskbar down below because

I use it a lot and I like that quick access if you  don't see it there you can go to your search and   just start typing it in and it should pop open  right away if you want it on your taskbar just   right click on it you should have some options to  pin it to start or your taskbar I'm going to go   ahead and open it at this point right here and  when it pops up we're going to do a quick walk   around this screen we are going to be working from  a blank workbook today but I just want to point   out some things that you're seeing now here are  previous uh workbooks Microsoft work books that   I've worked on and I can just open them up again  I want to point out notice this one says one drive   and this one says desktop I can save my Excel  workbooks to the cloud to one drive and I can   be sharing them with other people and working with  other people at the same time or I could be just   saving them to my computer the other thing I want  to point out are these templates if you're seeing   these ones these are tutorial templates which are  great stepbystep ones that they have the data in   you just followed along just to let you know I do  have a lot of other tutorials on Microsoft Excel   and I'll put links to the description uh in the  description down below and up and above in the   card and make sure you hit that subscribe button  so when I do release a new video uh that you're   going to get notified when those come out so the  other thing here is more templates now these can   save you a ton of time if you know if you're  looking for to create something like a budget   or a calendar or an invoice all these different  ones after you're done with this Microsoft Excel   beginners class you'll feel pretty confident uh  manipulating these ones with the data that you   want to put in uh I'm not going to be covering  them directly in this class today so let's go   ahead we're going to create a blank workbook and  notice if I navigate on the side here from home

I can go to blank workbook here so I'm going to  go ahead and just open this up and we're greeted

with the typical Microsoft Excel sheet here let's  start with some basic terminology and a little bit   of a walk around the layout in Microsoft Excel the  workbook that we just created when we created that   workbook we get one sheet because it's a blank  workbook if we take a look at the bottom it says   sheet one we can create more sheets we can rename  these sheets and I'll go over that later but when   you first start you just have the one sheet inside  that one sheet you're going to have columns you're   going to have rows you're going to have cells in  ranges that you're going to be adding uh data to   so we can select these columns so if I go up to C  if I just select C I've selected the entire column   now so if I on my mouse just scroll down you can  see the numbers increasing as I go down and that   entire column is selected I can do the same thing  for rows so if I select this row right here now I   have the entire row of three selected and I could  go across and see the letters increase as I went   across that way where the two intersect where C  and three intersect right here that's a cell so   when I just select one spot like that that's the  cell in this cell here is C3 if I take a look up   at the name box up here whatever cell I click in  I'll see that B3 D4 it changes so if you need to   quickly just see what cell you're in take a look  at the name box another important thing to know   is what a range is when you have a  bunch of cells selected so here's an example if   I select B2 and I'm going to click on my mouse and  drag and have a selection area down to here this   is a range right here it's just not one cell  it's a group of cells to know what this cell   this range is named it's going to be from this  right here so this is B2 and then you'd have a   colon and you go all the way to E6 so that would  be the name of that range so that's some basic   terminology some important basic terminology to  know when working with uh your worksheet on the   sheet here when we first get started let's move  to the top of the workbook here I want to talk

about uh the different things between tabs ribbons  groups and how to navigate everything here if we   go up you can see I'm under the Home tab so what  we see here are the different tabs as I click on   them if I click on the file right here it brings  me back to that original page when I just started   a blank one and it has all those options on it  now I can hit this Arrow to bring me back to the   workbook and continue working on it so these  are the tabs across the top underneath every   tab we have the ribbon so the ribbon is this area  right through here and this is all customizable   too I can change the ribbon and the tabs to add  more mine might even look different than yours   and I'll show you later on how you can customize  that but inside the ribbon so if we take a look   at this font right here where it says font this  is a group so this right here is a group inside   the ribbon and we can go one more step after  this because not everything is listed in this   group and whenever you see this right here I can  click on it and it gives me more functionality   so under the font I can see all these different  things through here that I can apply so this is   just a little walk around of what we're seeing  we have our tab across the top inside the tab we   have a ribbon inside the ribbon we have groups  and then we can expand for more functionality   whenever you see this now uh the thing I want you  to do before we move on is actually to save our

page before we start entering the data so let's  do it this way we could go from save up here but   for this first time I just want to go back to  file and at this point I'm going to go save as   I could go save as because I haven't saved  saved this workbook yet but if I go save as it   brings me to a few different places I could save  it this cloud is for one drive so I could save it   into my one Drive account if I wanted to do that I  could even save it into SharePoint sites here and   I have other accounts connected to this as well if  you want to save it to your computer you could go   this PC or browse so if I go browse here and just  go to my desktop I have a folder beginners class   here I'm going to go ahead and open that up what  do I want to call this book so maybe this would   be I'm just going to call this class one just  like this you can call it what you want and I'm   going to hit save now as soon as I hit save we're  back on the page that we've been working on I I   want to show you right up here so this is called  class one it's an Excel file and it's saved to   this PC so then I can drop down and get some uh  more information about this but remember you can   also save it to one drive and then you can access  it through the cloud let's move on now and let's   start inserting some data into this workbook so  the data that we're going to be entering in today

is going to be the top grossing movies of all time  if you took my previous Microsoft Excel tutorial   beginners tutorial you know that I use that too  but I have a feeling that the uh amounts in the   data has changed since then now I'm going to click  in A1 and I'm going to just type the First Column   heading that I want and it's going to be rank so  go ahead click in A1 and type rank I am going to   say I'll have uh all these workbooks that I show  you today I'll put the link Down Below in the   description so you can download it and open it up  in Microsoft Excel and you can follow along with   the data that I provide you so we have rank  here and then I can go over to B2 so if I click   in B2 I can write the next one which is going to  be title so this is going to be title of the movie   so I'm just going to put title just like that now  I've been clicking with my mouse to go to the next   one you might want to use tab on your keyboard so  if I hit tab that moves it over I could use the   arrow keys to go around and to navigate so there's  different ways you can do this now in this column   I want to put worldwide gross so this is going to  be what the movie brought in uh with all you know   whether be domestic or uh foreign everything like  that so this is going to be worldwide gross and

notice right away if you're new to excel it looks  like that I typed it in C and you can see in the   formula bar up here that it's there but it looks  like it's in D if I go to D and I'm going to put   my next one in it's going to be de domestic  gross so if I type in domestic gross right   here and I better spell that correctly and if I  click off of it did I delete anything from here   no I didn't because the cells are separate so if I  click in C3 uh sorry C1 I can see worldwide gross   and domestic gross I can see it there now we can  change the width of our columns by going up and as   soon as we get this symbol I can click and hold  and stretch the column so notice I can make it   as wide or narrow I just like that a quick way to  do it though is to go up and between and then if   I doubleclick it automatically adjusts to what's  written in there right now so if a title becomes   longer still and I do that it will adjust to the  widest part so I can see everything and I'll show   you what I mean as I move forward uh so if we go  to the next one domestic gross I could do that and   adjust so we have domestic gross and then I'm  going to put year now I'll be probably adding   more columns later and I'll show you how to do  that but that's what we're going to start with   right here I want to show you a quick way you can  adjust everything I'm going to make these smaller   I can select everything on the worksheet here by  just selecting this up here so if I click this   button everything on the worksheet is selected  so if I was applying a format everything would   be changed so if I said bold everything becomes  bold even these cell so if I enter something and   later it's still going to be bold if I turn it off  but I can adjust if I have everything selected and   I double click between any of these notice how it  adjusts everything to fit now again I might have   to adjust that later because as I start typing  in different amounts or uh titles that's going   to be much wider so now that we've got some uh  titles in let's go to our next step if you're

finding the font a little bit small and you want  to adjust your view without Chang changing any   of the font size or anything you can do this in a  few different ways uh down the bottom right hand   corner we have the zoom so I can click up to get a  different view I can slide that and Under The View   tab up top check in the ribbon we have different  Zoom tools here as well to get it just the way   you want to make everything comfortable now let's  talk a little bit about formatting I'm going to   go back to the Home tab and different ways that we  can change the look here so if I click into a one   so I want to show you the difference between one  a single click to a double click if I click this   cell A1 and I start typing something notice that  it just defaults over top it just deletes what uh   what was there before uh here's a tip you can use  contrl Z or the back arrow up here to undo your uh   last step so I'm just going to go contrl Z and if  I wanted to just uh modify what's in there already   I can do this in a couple different ways I could  doubleclick and go in here and type ranking notice   it didn't delete anything the other way I'm going  to just go contrl Z again the other way I could do   this I can go right up into the formula bar and  click in here and then add there and now I've   changed it from there so I would have to adjust  this just like that like I've showed you before   so I can also go back and delete things so just  some ways to you know to make some modifications   to what you've already added now let's talk about  changing uh you know things from maybe you want a   different font to start with I can select one cell  at a time or a range of cell to apply those so I   could select one cell like this I could make  the change to uh a font to a different one but   probably in this if I knew that I wanted to be  all the same I could select and I'm just using   my uh Mouse to drag across and I could go ahead  and then select on the drop-down of my font and   choose the same one and make the adjustments that  I showed you before if I select everything and   then just adjust for everything to fit I could  make some changes to color so if I was going to   go and choose maybe a red if I want it red so the  font becomes a red I can change the background of   the cell so if I drop down is there a color that  you would like I I'll say green and then I've   made some adjustments we can do the same thing  with borders around these so I need to select   the area that I want to apply the borders I have  some right here they give you some quick ones so   if you want all borders do you want it just thick  outside you know thick outside around I can choose   I can even draw the border around so if I click  it uh these don't show up that well it wasn't   that thick for what I have but it's around the  outside now if I don't want them right now I could   go back and drop down and then all I have to do  is look for no borders and it's there now I want   to point out if you do change I kind of mentioned  this before if you select everything and then you   apply let's say a color to it so if I was going  to say uh we're going to make sure everything is   going to be this color here if I type anything  at this point and if I just type hello notice   that the color is applied to everywhere even if  I go over here since I had the whole sheet   selected it's going to it's changed everywhere  so that's uh make be careful if you're going to   change everything that way I'm just undoing with  a couple control Z's uh to get back to my previous   step now how I like to add titles and this makes  it an easy way is to be using cell Styles so if   I go and just highlight this again I'm under the  home here Home tab if I look in the ribbon look   for Styles and some of these other things are very  important like conditional formatting and format

as a table and we'll get that to the later on but  if I go to cell Styles look at the different ones   I can quickly pick so if I hover over you can see  an idea of what I have so if I if you just hover   over and if I find something that I like I'm going  to go with the blue right here and now I quickly   adjusted the style just by using this one cell  Styles so we have some information in here I'm   going to go collect the data and put it in here so  we can move on from there remember just download   the sheet down below uh in the description and  then you'll be able to have all the data that I'm   showing you here today so if you've downloaded  the Excel workbook this is what you should be

working with and this is where we're going to  continue from I have 15 so the top 15 here so   there is some formatting to do here that I'm going  to make some changes to uh the first thing uh what   I want to point out is notice that the title like  I mentioned before you're not seeing uh the words   the titles come up so I could make this larger  so if I click in between the two double click   and it stretches it this way so that's one way I  could do it if you didn't want it to stretch out   like that let's say you wanted it uh just to be  differently we could wrap text in a Cell so if I   go and highlight the information that I want to  wrap the text notice under home under alignment   we have wrap text so if I hit wrap text what  it does it took the it didn't expand the cell   longer wider it just wrap the text onto into that  one cell so it's wider the row height is higher   here so wrapping text might be an option if you  want it that way I'm going to just uh go contrl   Z and I'm going to go with this method here just  to uh stretch it out because I should have the   room but I'm going to show you why I might want to  change this in a moment now the other thing what   I want to do is I want to add a title to this so  something above the top here and I   can insert more rows I can insert more columns  or rows what I'm going to do is just uh on top   of the number one when I hover over it I'm going  to rightclick and notice I have insert so I can   go insert and I just inserted another row and I  want to be able to call this the top 15 movies   of all time and I could write it in A1 but what  I want to show you is you can merge cells too so   there's all these cells right through here if I  go ahead and select this right through here and   click merge and notice there's more options here  merge and center merge and across so depending   and I can even unmerge if I don't want the merge  so if I say merge and center if I go ahead and   just double click in here the cursor is in the  middle then I could say top grossing movies of   of all time just like that so and I have this  title here that's centered across all the top   and I can go ahead and make the uh changes to like  I showed you before with the cell style so maybe   if I go and highlight both I could go back to cell  Styles and you can pick what you would like U as   one through here so whether it be one at a time or  uh is it just going to be that one and you get an   idea of what it would look like do you want it to  be the same so I'm going to choose this one right   here so you pick what you want so we've inserted  another row I do want to point out anything you if   I click on a cell right click on C here there is  the insert uh here as well let's do a little bit

more formatting with our dollar symbols now so we  have all our worldwide gross here in our domestic   and I want to format this with dollars I could  select one and format anything if I go up top   I can select my dollar and notice right away uh  it puts these number signs in like that   if you ever see that what's happening is there's  not enough room in that cell so for example if I   stretch this out now it comes out so if you ever  see that the number signs across like that uh then   that's what's happening and you can just format  the column width and then it's going to fit and   see so I'm just going to undo because normally  what I would do is uh change maybe everything   at once rather than one at a time so I know these  are all dollar amounts and then I can go back and   click up here I still have the same issue I can  double click in between and it will stretch out   to remove that now I want to point out you can  choose different countries whether it be Canada   US UK all these different options and then we  have you know right now under accounting we   have the commas in there so if it was just number  it goes back to this one and currency you can see   kind of the different formats of each one as  we go through uh the different ones so I'll   just leave it like this and then the next thing  I just want to show you is what this would look

like if you try to print this and I want to point  out this line there's a perforated line between C   and D this shows me in the current way that is  printing in a portrait that this is where the   cut off would be so if I go over to file and I'm  going to go to print here and then take a look so   this is where this was that the perforated line  was this is actually two pages so this wouldn't   work very well to print it like that one thing  you could do you could change the landscape or   to landscape orientation and then it's going to  fit across so you can make that quick adjustment   if you wanted to keep it in portrait you'd have to  make some changes to this to fit so if I was going   to go back you could try making this column not as  wide but you're going to lose some of this so this   is where Maybe you want to try the wrapping so if  I click it once and twice and then I can make it   a little bit smaller in here and at this point I  notice the line is right here after E I could try   some other things like changing font size if I go  back to file and print now you notice everything's   fitting on that one page now there's lots of other  things under page layout under here so to set up   brakes and everything I have a different video  all about printing in Microsoft Excel so I'll   make sure I'll link that as well now I want to go  over basic Excel formulas I'm going to do this on

another sheet so let's first of all let's rename  this sheet rather than the sheet one I'm going to   call this top movie so I'm just going to go ahead  type that in like that if I rightclick on this too   I just want to point out you can rename and delete  sheets and you have different options even a tab   color so I could go ahead and change it I'm going  to go ahead add a new sheet and this is just going   to be a practice ice formulas so I'm just going  to type well I typed that in the wrong cell I got   to go be down here so formulas just down here and  I could make it a different color if I wanted to   as well so I could toggle be between both back and  forth okay so formulas inside Microsoft Excel the

most important thing to remember is when you're  starting a formula you need to start this with an   equal sign so what I mean is if I go to uh this  cell and I want a formula I could use this as a   calculator but I have to put the equal sign in and  then I could say two and I let's say plus 3 equals   2 + three hit enter it's five but five isn't in  this cell if I click in the cell and look in the   formula bar this is what's in the cell equals 2 +  3 if I don't put the equals in it will not work so   just so you know that you always have to start  a formula with an equals now what makes Excel   powerful is cell referencing so what I mean by  that is so I'm going to go ahead and put a number   up here so this is going to be five and we'll put  six here and I'm going to start another uh formula   remember with the equal sign with Rell referencing  so this time if I put equals and click on C3 and   then say well let's go ahead and multiply so the  multiply is going to be the above the eight the   star here multiply what well I could put a number  in or I could click on another cell so this is   going to be C3 * D3 which should be 30 5 * 6 hit  enter and I have 30 if I click on the cell look   at the formula bar here and there it is so this  is what makes C makes Microsoft Excel powerful if   one of these numbers change so if this changes to  10 I type 10 hit enter this automatically adjusts   because it's cell referenced and if the cell Chang  es then the formula will adapt with the new cell   reference it's not really a number the number  10 isn't in this formula it's the cell that's   in this formula so that's just a little bit to  know about kind of the walkth through of working   with basic formulas so let's go back over to top  movies and add a formula now what we're going to   want to add is going to be the worldwide gross  minus the domestic gross and that will give us a   foreign gross so to do this though we need another  column well we could add the column here and but   I kind of want it right after so to do this I'm  going to insert first so I'm going to just select   this column e and I'm going to rightclick and I'm  just going to hit insert and notice to the left it   inserted this and this adjusted up top everything  stayed Center as well now this is where I'm going   to place my formula inside this so uh what do I  want to call this well this I said was going to   be for and so I'm just double clicking in there so  that this is foreign gross just like this so I'm   going to go and label it now inside of this I'm  going to also go to the uh Center just so it's all   the same and I'm going to go and start my formula  first thing you have to do is start with an equal   sign and we're going to be cell referencing  so if we go equals what's the first cell well   it's going to be worldwide gross minus so then we  just go ahead and select our subtract key is going   to be domestic grow and just like that we can hit  enter and we have an amount here now this is where   uh Microsoft Excel again is powerful we created  this cell uh formula so if we look up here we can   see C3 minus D3 I can copy this all the way down  without having to do that to each cell you could   do this in a few different ways you can drag down  like this what I tend to do is just double click   I hover over onto this green little square and I  double click and it automatically fills down it   knows where to place it so it made that formula  in every one so for example if I click on this   cell notice it's C4 minus D4 it changed this was  C3 minus D3 because it knows when I copied it down   that I needed to adjust which row I was talking  about so it always adjust so I didn't have to go   through to each one to create it now there is  something called absolute cell reference and I   will talk about that a little bit later because  sometimes you don't want it to automatically uh   copy down you might have a cell in one place and  you need it to stay frozen to that and I will   show you an example of that in ad just a moment  let's go back over to our formulas page practice

page here and talk about uh just absolute cell  referencing and this is just going to be a little   example on it to help you get your mind around  it but I have a different video on formulas and   absolute cell referencing and I'll make sure I'll  link those as well so we have some numbers these   are just numbers no formulas or anything in them  and I'm going to create a formula right here I'm   going to say equals it's going to be this uh A7  multiplied by B7 just like that but I'm also going   to connect it to a different cell I'm going to say  uh subtract this cell right up here so let's hit   enter so 5 * 3 is 15 takeway 6 is 9 if this number  changed this would automatically change as well so   now the problem is if I go ahead and copy this  down so if I just go and double click or pull it   down whatever way you want uh let's check if these  are right 4 * 2 is 8 subtract 4 should be four and   3 * 1 uh is 3 take minus 4 should be negative 1  so some something's wrong here so if I click into   the cells so as I copied it down notice this is  D3 this is D3 I need to make sure this is always   pulling from D3 it can't move so when I go down  to this next one it's pulling from D4 this is D4   right here so it's pulling zero and that's why 4  * 2 is 8 minus 0 is 8 3 * 1 if we go down now it's   moved down to D5 because when you copy it down  like that it will keep moving like I showed you   when we did top movies what I need to do though is  turn this into an absolute cell reference so if I   go back to D3 here I'm just going to click in here  and I need to put dollar signs around this so what   I mean is the way I do this is just to use my F4  key or function F4 you can put your dollar signs   in front of each of these in front of the D and  the three and if I hit enter looks like nothing   changed but watch when I copy this down now if I  copy that down four And1 if I look at each cell   it's pulling from D3 it's staying connected to  here so that's an absolute cell reference again   check the other videos that I have about that  that I list in the playlist and down below in   the description now it's really important that  you understand the formulas and functions are a

key again to make Microsoft Excel go to that next  level and we're going to do a few basic ones here   I'll show you how to access uh these but remember  I do have lots of different videos on different   functions inside Microsoft Excel so I do want  to put a function down here for build a formula   with a function in it to sum up our total amounts  and find average uh first thing though you notice   how I when I scroll down that this disappears all  the time you can freeze your row or whether it be   a column in place so you can always see what's  in it so maybe if it was names if it was a long   Callum colum over but in this case it's going to  be a row so if I select number three here just   this entire row I'm going to go in freeze so  anything above it will stay in place so I like   using this search too because if I go can't find  something under a tab I can just search for what   I'm looking for and let's say freeze pain and I'm  going to go freeze paines here so now what happens   is I can go and scroll down and this always stays  in place like that if you want it gone you can go   back and unfreeze it the same way just have it  selected and then go back and unfreeze it and it   will be gone okay let's move down to the bottom  let's try and insert just a quick uh formula in   here or sorry a function inside the formula  so we're going to go and we're going to go   to formulas right here look on the tab and we're  going to show a few different ways how we do this   and this is just going to be a quick one with  the auto sum so if I click on it well why do I   want to sum I could click sum and it went through  and chose uh everything from this down to here and   it's it looks like that's pretty much right it is  choosing this one right here uh so whether or not   I don't want c18 I could go through and just hit  17 and it adapted here there was nothing in that   cell so if I hit enter it's now it's added just  like that so it's that quick and I can copy these   over so if I was just dragging this over now it's  summed up domestic because it moved over notice   the columns D3 to d17 this is D so it's able to  copy those over if I go down here below I could   use these here is there an average that I want  I could hit average here well it's not of that   right here above it is going to be these ones so  I could go and select the uh range that I need   hit enter and now I have an average of everything  so that quick to use them now what I like is they   have the function Library here so you can they  break it into categories for you so you can see   whether it be Financial text date and time all  these different ways but we're not diving into   all those on this tutorial I want to show you a  couple different ways that you could enter your   formulas I'm going to delete these for now so  I just selected and hit delete on my keyboard   I tend to use a different method so you could go  from right here hit insert function and you're   going to you can search so if I was looking for  some I could go and there's some right there   could select it what's the range I want I could  put it in I see it's it has the right range that   I want I could adjust it or I could go ahead and  select my range just like I did before and then   hit okay after so that's another way you could  insert your function I'm going to delete this   what I tend to do if you know what you're looking  looking for I start my formula with that equal   sign and then I just start typing the function  that I need and it's goes through alphabetically   looks for it here it is Su I can double click on  this and I could put in my range I could type it   in what I want or I could select my range like  I've showed you every time before hit enter and   there it is so this is the way I tend to do it  but if you're just starting you probably want to   either try under the formulas tab or through here  uh but then after a while you'll probably notice   that once you know what you're looking for start  with the equals if I was looking for average I   could go ahead and then select average I could go  select what I need uh from there so I don't have   to select everything if it was averaging a couple  I could do that we can copy them over just like   that so we you see how you have a lot of these  different options with the functions and there's   so many and this is where it brings everything  to the next level using Microsoft Excel I want

to talk about sorting and filtering in Microsoft  Excel now and I just wrote some random stuff just   as an example before I show it on the uh the list  here that we've been working on but with sorting   and filtering I can sort based on numbers or I  could go alphabetically and I'll show you some   different ways we can do this but let's say in  this case right here if I highlight these things   you can see 8265 and if I go up to if I'm under  the Home tab and I go to sort under editing here   and I wanted to sort maybe the smallest to largest  so number two should become the first notice Mouse   is next to number two if I select it changed  it so now I have 2 5 6 8 but all of these change   they stayed with it now I could also do it a  different way if I was going to go and highlight   and go back to sorting and filtering maybe do a  custom sort and I could go sort hi based on the   cell values this time and it's going to be also  on A to Z so if I hit okay notice now that it's   cat Dogfish Mouse because that's the alphabetical  order and the numbers moved around to it so just a   little bit about sorting some D data that way I'm  going to go and delete this right now another way   what I like to do is add a filter to this so I'm  going to go and highlight my uh row here just of   the headings and I'm going to go back to sort and  filter I'm going to add a filter to this so if I   select filter I get all these dropdowns now on all  the ones that I chose I'm going to just show you   from year I could filter from smallest to largest  largest to smaller uh smallest so maybe I want to   see by 2023 coming out first so that would be this  one and they put 2023 and I can see right now it's   the Barbie movie for this one and it sorts them  all the way to Titanic in 19 1997 I could also   search for an individual year on this so if I  go back to my sort and right now everything is   selected I could hit select all and then look for  2015 and hit okay and now it gave me back all the   all the movies in the year 2015 that came out and  I can see uh the different ones through here so   it's not the complete list if I want to go back  and see everything again I could select all hit   okay and then I have so this really lets you drill  down on the data that you have I have a short list   here but imagine if you had hundreds or thousands  of entries and you wanted to start filtering it   for something specific in it this could save you  a lot of time now I want to show you how you can

chart inside Microsoft Excel uh this is just  touching the surface of it I have a different   video that I go through extended charting uh take  a look at that if you want to learn more about it   I'll put a link to the in the description down  below and up and above and in the card uh but   and the other thing is to uh change your rank if  you still have your filter on you can uh show your   rank to the uh smallest to largest so filter  this one so we're then we're back to our top   now we don't have to create a chart for the whole  thing we're going to start by just doing the top   five so what I want to do is actually I'm going to  highlight from title over here to worldwide growth   so I'm just going to do this uh selection here now  then if go up to insert and we look under charts   we have all these different charts here uh we can  go through these quick ones we knew if we wanted   to see the different types of bar charts in here  to the pi ones uh I'm going to go to recommended   charts so I'm going to select this and then it  gives you an idea if you go to all charts you   can see everything uh I'm just going to start  with this basic one right here and I'm going to   hit okay uh at this point the graph plops in here  into it I can move it around I can click and hold   uh when you click and hold it make sure you kind  of get into this area I'm just going to place it   right here now if I want to expand the data that's  going to be in the graph all I have to do is look   at this area and I can go and pull it over so if  I pull this over one more to domestic gross then   it's going to be added in here so it's an easy  comparison visually I can see uh which one has   done uh the best for domestic versus the other  ones I could even bring it over again to show   foreign grow and I can grow it the other way so  if I wanted it more than just the top five if I   wanted it to be maybe seven uh then I have even  more in here so I can make those adjustments very   quickly even after I started uh making the graph  so and now what I can do is even make some more   changes to this do I want some elements and you  can do it in a number of different ways uh right   now I don't have any chart title on and I can be  adding uh and I can make some quick style changes   up here so first of all let's try it Styles  change so if I go uh you know I like this one   with a contrast and I select it pops a little  bit more I can still adjust all this information   but this gives me a quick way uh just to kind of  get started with the Styles and I'm going to   leave it there but I want to add some more things  to this if I go over to add chart element uh what   do I want to add to it do I want an axis do I want  access titles on this do I want chart titles well   let's go with a chart title so if I click on this  now I have a chart title sometimes it defaults   with this depending on what you chose so I'm just  going to go I can click in here what's the chart   title I'll just say top grossing um movies here  and I'll just leave it just like that and I'll   click off so I've made that change notice when I  click on the chart I get all these different   options under chart design I get another tab that  comes up so if I click off of it it's gone click   on it it's there let's add something else and  I'm only going to add a couple things here but   if I drop down and then I go to let's say I want  a legend I could choose to have a legend on the   right hand side and then I choose it so right  there now I have my Legend here uh it's pulling   it from this different series names across  the top here so I'm quickly adjusting this as   I uh go through I can change colors at any time  through here and I have quick layouts too so if   I wanted to still make more changes you could try  uh hover over different ones if you wanted things   to be just differently presented uh you can see  what works and what doesn't work when you choose   uh different ones try that approach if you like  maybe I like it at the bottom uh right here and   I'll leave it then I've adjusted it like so if  any number changes in here it will dynamically   affect what the chart looks like so here's an  extreme example here so for Avatar if this was   going to uh 5,000 this won't even show up anymore  when I hit enter uh notice it's gone right through   here because uh it doesn't even register for the  other one so I'm going to go uh contrl Z put it   back undid that last one and then it's back so  everything Dynamic if this changes the chart   will change as well if you go through and double  click on the chart you do get formatting options   uh through here from The Fill to border I'm not  going to show you everything on here I just want   to show you where you can go through and play you  can change uh different areas so if it was things   like the legend uh what did you want to change in  it so I right now if it was no fill or automatic   you could choose maybe a solid fill and right  there the colors there but I could adjust it to   a different color just like that so I can make all  these changes uh to it and if you close out if you   rightclick on the chart you can see there's lots  more options that you can do uh you can change   the chart type from here uh save it as a template  move the chart you can save this as a picture as   well now I could go through if I was going to go  and check file and then print it gives me an idea   of what it's looking like right here cuz I had  the chart uh selected on it so since this was   selected that's what I chose to print if I click  off of it into here and I go file print now notice   that it's I would have to do some formatting on  the pages how it's going through and probably I'd   want to change it from landscape and I probably  change the size of the page and everything but   it gives you an idea of the different ways so if  you just wanted to graph the chart printed just   select that and then hit print so that's a little  bit about uh charting inside Microsoft Excel the

last thing I just wanted to show you today and I  mentioned at the beginning was about customizing   your ribbon for Microsoft Excel I'm going to  go just up here and you can right click in a   few different places I could right click here like  this or up here you're going to get customized the   ribbon I'm going to select that I'm just going to  stretch this out so we can see everything and I'm   going to move this over so we can uh just compare  notice I'll shrink this we have home insert here's   the home here's the insert draw isn't selected  so it's not showing up page layout is there so   that's where uh these all these Tabs are showing  up now if I wanted to add a new tab I could go   ahead and click new tab and this top level one  maybe I wanted to rename it and I'll just call   this demo for today's purposes hit okay what do I  want to add to this well I have to add to the   group so if I wanted to add well I'm going to add  cut and I'm going to go through I'm going to add   a freeze pane to this and inserts uh picture so  kind of random but I added these things to this   when I hit okay look at that demo is there and  then I have my group that I created so you can   create your own ones if you just want that easy  access rename things the way you want I can go   back rightclick customize if you don't want this  anymore I could go back choose if I wanted to   delete maybe remove the group or remove the demo  I can just go through and do that the other thing   I wanted to point out we do have our quick access  toolbar at the very top above the tabs uh if you   this is all that's on it right now but if I wanted  to have maybe cut on it I can add it uh or maybe I   want to have we'll just add one more in here it's  going to be insert table add if I hit okay now   across the top you're this is how you customize  your quick access so you find those ones you just   want to go up and click on it will save you a bit  of time so I hope you like this walk through today   this beginners class on how to use Microsoft  Excel it just really touches the basis of it   but uh it sets you up ready to move on now let me  know what else you want to learn do take a look at   the other tutorials if you want to dig in deeper  I will have a another class coming out with be an   intermediate or beginner's Class 2 uh let me know  the things specifically you'd like to know thanks   for watching this time on teachers Tech I'll see  you next time with more Tech tips and tutorials