Microsoft Excel Tutorial - Beginners Level 1

hi there Jamie ke here today at teachers  Tech hope you're having a great day today   we're going to look at a beginners tutorial  on Microsoft Excel so I'm going to go through   this tutorial and show you uh just some basic  layout some terminology how to input your data   how to format your data how to uh work with  functions how to work with formulas how to   work with charts uh and how to do some printing  at the end so there's lots packed in here I'm   going to throw in some tips for you too so that  when you're done this that you feel comfortable   maybe advancing your levels to the next one I'll  put out some other videos uh about Microsoft   Excel to uh help with that process too but uh  if you're looking for any parts of this video   just look down below in the description and  I'm going to Tim stamp everything so you can   just jump to that part if there's something  specifically you're looking up remember I do   these weekly Tech tips and if you're looking  for other Microsoft products or any other Tech   products just hit that subscribe button uh and hit  that little notification so when U my new videos   come out you'll get notified right away so today  let's start on this Microsoft Excel beginners tutorial I'm just going to go ahead and open up my  Microsoft Excel here I just have it on my taskbar

so when I open this up uh just something to know  I am using Windows 10 and Microsoft 2016 but if   you're using other versions this uh beginner  tutorial will match uh quite closely to a large   percentage of it so just some first things as you  open up your Microsoft Excel you can see I might

have on the you might have some recent files if  you have opened up things before uh these are just   going to go in order of how old they are uh from  top to bottom but if there's something important   that you want or there's a worksheet that you  can that you want all the time and to stay on   the top just notice this little pin here and if  you click the pin it just will be at the PIN to   the top uh so you can quickly find what you're  looking for or you can unpin it and put it back   uh in the order so another thing is we have uh  all these great templates here I'm a big fan of

templates once you know kind of what you're doing  in this uh in this tutorial that I'm doing today   will help you uh maybe get to that step where you  can save a lot of time making some professional   looking uh workbook uh workbooks just from using  the templates and modifying them somewhat but   there's lots of templates uh to choose from uh  you know for hom work or school use uh right   through here or you can even search online here  uh but the best way to learn uh first is starting   from a blank uh blank workbook what I'm going to  open up and just understanding the basics of it   so I'm going to go ahead and open up a blank  workbook here and when it opens up uh you should

get a view similar to this or maybe if you're in  a little different version it might be slightly   different uh and if you look around uh and now  this is similar to other Microsoft products uh   too but across the top we have all these tabs  and so whether you're on word uh or Excel or   PowerPoint we have tabs across the top that you  can click on to see something underneath them   and that thing underneath them is called the  ribbon so if I go to my home one which tends   to be kind of one of the ones that you're on Lots  you can see this is the ribbon through here so uh   in the ribbon you have groups you can see here  so this group right here would be my font group   uh this is my alignment group through here the  different groups are names so we go from our tab   to our ribbon to our group and sometimes uh what  shows up here there's not enough room so you can   see that there's this little button here to push  if I click this you'll even get some more options   on this so that's just kind of your basic uh walk  through if you use other Microsoft products uh   this will be familiar but those are just some  of the terminologies to start with we have our   tabs and then a ribbon and then our groups so  Microsoft Excel uh you can see so what we have

in Microsoft Excel we have uh if I just click  on a on the letter c this is a column and then   if I click here on the number four this is a row  now there's you're not going to run out of   these columns or rows there's uh so many I can't  remember the exact number uh but uh if you can   keep scrolling and put a tremendous amount of data  into this here now an individual spot is called a   cell so where the two uh places meet so where this  Row three and C meet right here this is called a   sell whatever sell I click on notice it will show  up here in the top leftand corner here so as I   click on different ones uh we have F6 you can see  and I click on and C7 if I grab a bunch of cells   that's called AR range on it so AR range is going  to be a group of cells all together and that's   these all these things you're going to be using  as you learn more Microsoft Excel because you're   going to be taking the data and from a whether  it be a cell or uh a range and then trying to uh   apply formulas and functions to it so in this one  uh range would go from in this case you can see   the top leftand Corner which would be C4 all the  way down to K7 and that would represent that range   from there now when I click on each cell uh right  now all these cells are empty so if I click on a   cell whatever you see in a cell is going to be  right up top here so you can see it's empty here   so if I write something right here so if I just  write something up here it will go into that cell   and if I click on the cell will show me exactly  what's in there so you can always check to see   what's in the cell you can write up when you're  on a something up here or you   can write in cell here and if I wrate something  else you can see it just goes right in here so a   couple other things uh to talk about just before  we get starting uh started inputting our data is

so this whole thing is called a workbook uh that  you're going to be working in here though so when   I open it up I open up a workbook but within the  workbook you have worksheets and you can see down   at the very bottom here we we're on sheet one you  can add more sheets here you can see I can just   click new sheet uh and as I click new sheets now I  have sheet two I can click again sheet three and I   can rename these sheets just by double clicking  on them and calling them something else so if I   just wanted uh if this was going to be an example  of I'll just write data and you can see I can   name each of these and I actually can drag these  around in different orders if I wanted to change   them around too so that's just some terminology to  start off uh it's important to know that just as   you read through and add more things here you're  going to see uh when they talk about cells or   ranges uh in the worksheets uh when we talk start  talking about different things with formulas and   functions later on this video so let's get started  with entering in some data and then we can get   going on formatting that too okay so it's time to  start entering some data now uh the one thing I'm

going to do before uh is make it larger so I can  see things a little bit better and then you'll be   able to see things a little bit better uh so how  I'm going to do this you can go to view up top   uh right here and when you click on it you can  see you have zoom options where you can zoom up   and when I hit okay it gets larger the other thing  you can do at the bottom right hand corner there's   this uh little slider with a zoom you can see how  I can adjust it very quickly uh too like that so   I'm going to go back to my home and now this  will just make it a little easier to work with   so I'm going to be entering the data I'm going  to be uh using and manipulating today is going to

be the top 10 grossing movies of all time so I'm  just going to enter some titles and then just do   some formatting show you some basic formattings  on text so I'm going to write this in so we're   going to start with Rank and then we're going to  have our title to have our   studio name who made it and then we'll have our  uh worldwide uh grossing income and then we'll   have our domestic and then we're going to have our  overseas and one more we're going to have year so   I just quickly uh typed in and what I was doing  was tabing over each time too when I was done a   certain cell so here's how you move around you  can click I can click in any cell to move around   but what I tend to do when I'm typing I'll Tab and  if I hit tab it moves to the right if I hold shift   down uh when I tab it moves to the left if I  ever hit enter it will move down if I hold shift   down and hit enter it will uh move back up you  can also use the arrows sometimes I'll use the   arrows and you can uh just Arrow your way around  your worksheet too so I have these titles here uh   and you can see everything kind of fit in across  the top uh here because the words weren't too long   worldwide is getting a little squishy in here at  any time if you do need some extra room if you   hover uh right uh around round that you can see  right in the middle when you get this handle you   can stretch out your uh stretch out your different  columns or you can stretch out different rows   but the one thing is not to worry about if it's  overlapping it's not really messing up anything so   for instance if I was I'm just going to write some  uh I'll say studios in the united uh I'll say in   the US so notice that right now it looks like it's  going into D so if I click out of it uh it stops   right here and if I click into it didn't mess  up this cell at all you even though you can't see   it at all uh that doesn't mean it's messed  up so what you can do is this is where you can   stretch out your cell like this if you ever want  to make a change remember just use the back arrow   or contrl Z and you'll go back the other thing  you can do if you just double click in between   those you'll instantly it will just uh fix it for  you too even without dragging so those are just   couple options uh that you can do uh to quickly  uh make that those adjustments and remember on   the side you can get that handle on the same thing  so you can adjust those too so uh if we formatting   maybe you want to make it uh look nicer uh you can  quickly uh change if I click on a single cell and   if I was going to write something now so maybe I  wanted to add something to the rank and I click   on it once it will just disappear now the reason  if you want to a format inside that cell uh and   maybe I want it ranking you have to doubleclick  in it and then I could add it that would be one   way another way is if I click once I can just go  up top here and type it in up in this spot too so   just know that if you click on it once and try to  write something in it it's going to delete it on   it you need to double click on it or go right up  top here so I'll just undo those ones and uh so   the next thing uh what we're going to do is just  some basic formatting you can see this works like   Microsoft Word uh if you've used that before so if  I click on it you can see I can quickly change my

text on it I can change the size notice how it's  disappearing right away so maybe a double double   click here and it instantly changes to this double  fixes it for me too if I wanted   to change the whole row at once I can click on it  and now I can go back and adjust maybe I wanted   that smaller if I wanted uh it bold and maybe I  wanted a different color like blue on it you can   see now that I've made it bigger things aren't  quite fitting in the right places so then I need   to adjust those columns and remember it doesn't  it won't affect the formulas or anything this is   just how it looks uh so we can fix it so again  if I double click on it you can see how I can   instantly fix these uh very quickly on it  so those are just some formatting uh things to   make it look nice it doesn't change or doesn't  wreck anything to have them overlapping but to   visually uh look at it uh it's just a quick thing  to do so I'm just going to hit bold let's bold all   these I'm going to double click on here and just  get I'm just going to call this uh studio and I   don't want it that large I'll just double click on  it so now we have our titles the other thing you   can do is you can add so you can just uh you can  select by dragging across you can add borders to   different things too so you can see through here I  could add borders between each of them if I wanted   to border around it uh just click in here and you  can kind of go through and you can draw borders   and you have different options on the Styles uh  through it so you can then you change how thick   and everything you want on your border too so if  I click off it too now you can kind of see that   that line that goes around it and a lot of this  is for uh visual maybe helping as you're working   through it or when you're printing it off because  if you print it off these cells don't show off   show up these are blank you need to add borders  and everything if you're printing it off and you   want it the outline around certain things make  sure you add your borders uh and then your colors   and then it's just easier to look at a spreadsheet  especially when printing off and finding different   areas the other thing you can do uh if you notice  the Styles right over here so if I click on this   and I want this whole row uh in a certain way so  if I click down maybe I want a certain heading on   this and you can see right here it will add the  heading to it and then it's all it's adjust in   a hurry so you can use these styles to quickly  adjust on these two all right so we have some   titles here I'm just going to take a moment and  enter in some data so uh rather than watching   I'll just stop and we get back when I enter out  in a bunch more so I've entered in some of my data   from a website that I have on the top 10 grossing  movies of all time you can see there's a little

bit more formatting to do now uh a different way  to format and I've already showed you the changing   the width of this here but what you could do is  another way and I'm going to make sure this whole   column is a selected so I apply this notice that  we have WRA text when I click on wrap text what it   does is it wraps the text in that uh in that cell  so it goes to a new uh line within it so I can   read everything without changing that uh the width  to it so if you just wanted to kind of it creates   you can see it did widen everything through  here but this just makes it so if you don't   want a super wide cell you could just wrap the  text instead so the next thing I want to do with   this I kind of want to add a main title here and  I can insert rows so I can insert more rows even

after I have something all set up like this so I'm  just going to rightclick on this and I'm going to   go to insert here so I selected the whole row and  then I'm going to hit insert notice now everything   kind of moved down and I have a brand new row uh  to it so I'm going to write down uh give me give a   title here and I'll say top grossing movies of all  time here okay so I have a title of this but this   title would be nice if it was kind of centered uh  on top of this here but I have all these cells so   this is an A1 and this stretches all the way over  over to G1 so what I can do with this now is if I   select the cells all the way to G here and then  I go and hit merge and center notice now it took   that it took all those cells and made it one cell  kind of merged them all together and then centered   that title uh for me so and again I can go through  here and I can uh maybe I'll add another I'll just   add a style to this I'll call it heading one and  now I have a title to it like so I made a a   little bit of more formatting so I've wrapped  my text I've added a title and merged it now uh   what I'm going to do is these are in dollars right  through here so these are in billions of dollars   I just used the abbreviated uh part just like I  took off the internet but these are in billions

of dollars now I could highlight multiple rows and  apply something but in this case because I'm not   sure what I'm going to do down here yet I'm just  going to select the area with the money in it and   notice right here we have a dollar symbol and if  I click it automatically puts it into a dollar   format here and gives me the decimals just like  the currency now I can pick different currencies   here also so you can see I could switch from US  Canada United Kingdom and so on and it'll make   the adjustments uh to those dollars on it so how  does this look if I was printing it a couple uh

and I'm going to show you right here and something  I want you to point out notice that this dotted   line that goes through right here uh that is the  print line of the page that the current settings   and everything so everything within if it's within  this dotted perforated line right here should be   fine to print I just noticed uh this ranking uh  I don't need this whole thing this wide for those   small numbers so I'm just going to change it you  can see now I would have a little bit more room   if I go over to my file here and I'm just going  to click on print it gives me a preview here what   it would look like when I print it notti the  notice the cells don't come up the style that   I picked did come up through here so it's nice  to have that style to break things up if

I wanted everything in more of a cell format if I  was highlighting everything through here so I just   dragged my mouse down I could go up and choose  maybe I want those borders around everything I   could pick and choose I'm just going to go to all  borders to make this quick and now if I go back to   my file and my print you can see how it's adjusted  so if I was just printing uh now to my printer I   can adjust this and this goes the same thing of  if you wanted color in certain parts so maybe I   wanted uh this ranking colored here I could pick  a certain cell uh maybe if I wanted this Orange   right here and I could bold my numbers on this  one and remember you can Center just like in   word and everything I could if I wanted everything  centered in here I could highlight everything and   Center to adjust to that way so those are some  more just basic formatting here and getting and   if you wanted to print what you had so far uh  you can always check to see under the print what   things would look like now to get everything kind  of looking very well because it just makes things   so much easier to analyze the the data when  you're if you're printing it and showing it to   somebody they'll be able to find things very very  quickly okay so let's start now with what makes

Excel powerful and that's formulas so formulas  are uh of course an equation but it's when you're   taking a cell uh because you want if the cell  Chang the formula will change so let's go ahead   here's an example if I was just clicking here and  you always need to start a formula with an equal   sign so if I hit equals and I'm going to choose  a cell so actually I could use a number here so   if I go equals to uh and I'll say times two and  I'm just going to hit enter and I get four so I   could use Excel like a calculator you may see four  here but that's actually not what's in this cell   now look at the four and now look up top here you  can see what actually is in this one so there's   a formula here equals 2 * 2 even though there's  four over here so if you wanted to solve something   really quickly in Excel just put the equal sign  in and then write the formula after that now if   I click on these cells you can see it's just a  number but this is a Formula here so sometimes   you might need to look in this spot right up here  to see the formula inside this is the formula bar   so I'm just going to go ahead and delete this so  let's apply a formula now to our uh spreadsheet   that we have over here so let's say I wanted to  know the percentage of domestic versus worldwide   so I want to put it right after domestic here  so what I'm going to do is I'm going to click   on this F row right click and hit insert now this  is going to give me I said row I meant column this   is going to insert another column right here uh  right beside here so now I'm going to enter in   the uh information here but I want an equation  so the first thing I said you always start uh   with in an equation I just double clicked in  here I could write it in the formula bar too   I give it a uh a an equal sign so I start with  an equal and now this is the powerful part so if   I click on domestic I want to take whatever's in  E3 and then the Divide sign is uh so I'm going to   put the Divide sign is this one right here through  here so I want to divide E3 by D3 I'm going to hit   enter and notice that it went to 27 cents but  that's because I formatted it earlier uh with   dollar signs and I don't want dollar signs on this  one I want a percent so if I go click on this one   notice I have a percent symbol right up here and  I can click it and it's 27% maybe you want uh more   accurate at different percentages notice that I  talked about this little button before I could add   I'll go to two decimal places and I can adjust it  a little bit more if you want that little bit more   exactness now here's the great part with Excel so  if I click in this cell so I could go through and   go down and do every single one and it would work  out fine but the formula that I gave E3 divide you   can see if I click on this cell here's the formula  it's saying divide E3 by D3 now if I click on this

right here in the bottom right hand corner notice  I get if I hover over in this I have this little   Square this is kind of a copy the cell down I'm  going to drag it down and I want to copy it all   the way down look what I just did for me it did  the form so now as I click on each one now it's E4   / by D4 E5 divided by D5 it copies  all the way down I didn't have to spend time uh I   just made that one cell and the way I wanted it it  knows when I dragged that down and copied   everything to adjust it to the side so let's  do this again with the overse so I'm going to   click on this one I'm going to rightclick insert  another column it goes to the left here I'm going   to get make a formula here so I'm going to hit  my equals I'm going to click on my overseas and   then I'm going to hit my divide sign here and then  I'm going to click on my worldwide hit enter again   didn't want money I'm going to hit my percentage  make an adjustment here back to my two percentages   grab this little handle get that little black  cross right here and drag it down and I get   all these percentages that fill in automatically  so that is a power of a formula and copying it   through uh using a present symbol you can do  it in so many uh you know once you have your   uh your numbers in uh you can just set up  these formulas and it make it so easy now why   are they so great too let's say there was an  error in something or this changes or you were   updating it the next year so if this domestic  number changed now let's say if I changed it   to uh 900 I 900 so I'll make it larger notice  that this number changed automatically because   it's connected to the cell and so it knows how  to adjust automatically to it and now this is   the power of spreadsheets and how it works so  well in Excel so you can play around with some   this is just the beginnner one so there's so much  more you can do with formulas and there's more   adjustments but that's for a different tutorial  but try some basic uh basic formulas in your   spreadsheet to see how it works and how it can  save you some time now but let's go look at some   of the functions that even can save you some even  more time here's a tip before I get into some more   formulas and functions here and I'm going to zoom  up to show you this tip here so I'm going to try

to zoom up and I'm going to move over all the  way to the left notice now uh we have a little   bit of the actually I'm going to zoom up a little  bit more here and notice now we have some of the   last few cells we can see so a handy feature if I  look under the view here is freeze pane so let's   say if I wanted to uh be all the way uh I wanted  to be able to kind of look at the rank and then   look at the numbers over here but I just want to  make sure that I'm looking at the right spot if   I go ahead and click on freeze pane here uh you  can see I can freeze panes top row First Column   well I want to freeze this column here now you  might have a different spreadsheet set up for   a different purpose but if I click on it now if  I was going over notice it stays in that ranking   uh so I can compare things all the time to that  Rank and so it just makes it really visually easy   to kind of scroll through to where if it whether  it be rows or columns and you can compare it to   that first thing you can turn it off very quickly  like so I'll just go back out a bit so you can see   everything all right so let's talk about some uh  more formulas and functions here to kind of save

you some time and I'll uh actually I'll zoom out  uh just a little touch more here so I'm going to   write the word uh total right here so total and  uh so I just showed you a formula with like using   it like a calculator where you hit the equal sign  and then you could just select the cells that you   want so I could do the same thing if I wanted to  add up all these different ones in the worldwide   to get a total amount I could hit the equal sign  and then click on a certain one hit the hit the   plus go to the next one hit the plus uh hit hit  that go on to the next one and hit enter when I   be all done it would give me mount it would work  fine now here's a quicker way to do it here uh I'm   just going to go over to formulas here and what  you can see is auto sum uh another way you can   do it if you're on your home uh notice all the way  over to your right you get Auto sum right up here   but I'm going to just be in formulas right here  and I'm going to click on auto sum and it just   instantly highlighted all this I don't really need  this cell it gave me a range and I talked about   ranges earlier on I'm just going to highlight  the exact range I need here so it says equals sum   everything uh between D3 and D12 so in this case  and you could just write if you know the different   functions I could hit equal then write the word  sum and then the range and it's going to take care   of the job for me so if I hit enter it gives me a  sum of everything here and same thing as I showed   you before you can copy over you drag that little  handle grab that little square drag it over and it   just does it for you here the other thing you can  do I could copy so if I go right click copy and   then maybe I want it over here and right click  and paste it will do the same thing for me so I   can uh put it to a specific spot and notice when  I this one is selected right now it shows me sum   G3 to g12 and it uh did G3 here to all the way to  g12 so here's another one so if I wanted uh to uh   uh right uh average so if I was uh typing average  I want to know the average uh amount so let's look   under recently used here and usually this one is  going to be right uh up top so you can see I just   did sum and now I'm going to click on average what  do I want to average it's asking for a range oops   I better click on here just one sec here I'll go  back I'm going to uh click it's going to ask for   a range here and what's my range it's going to  be this one right here and I'm going to hit enter   and now I have average of all these and the same  thing I can copy it over I could copy it all the   way over now it even averaged this but let's say  I didn't want that and I could change that to a a   percentage if I go back to my home hit percent  and you gives you total amounts right through   here so you can see how quickly and again if any  of these change so if this was uh changing to a   bigger a larger number and hit enter Everything  Changes because it's connecting uh to it so I'm   going to hit undo because that wasn't accurate  so if I go back you can see under formulas there   are so many in here now each of these can  be a video by themsel explaining how these all   work and this shows the power of Microsoft Excel  here uh as you go through you can look at all the   different ones and it's about understanding how  to set your worksheet up and once everything is   set up and as you understand Microsoft Excel  more it just makes your life a lot easier when   you're kind of processing all this uh all  this data together uh and but then as one   thing changes it just will fix your percentages  or amounts very quickly for you so that's   just kind of an introduction to your formulas and  functions uh if you're starting off basic uh with   some of your spreadsheets you can use these basic  ones and as you learn more start uh start looking   at some of the other ones so the last thing  I wanted to show you today in this beginners   Microsoft uh Microsoft Excel tutorial is uh how  to create a great chart to kind of display your

so I'm just going to show you how to graph or  chart your uh information really quickly I'm   going to do a different video uh on this uh  to kind of expand it but uh something before   we get to that and I hadn't pointed it out yet  and if you're used to Microsoft uh information   uh or the products the tell me up top here so  if you're ever looking for something in here if   you just click in here so for instance if I'm  looking for charts if I start typing anything   it's going to show me the information right up  top here so if you can't find something in the   tabs or in the ribbon uh just go ahead and start  typing what you're looking for and it's going to   find it for you here okay so that's just a handy  feature through all the Microsoft uh products   but so when we put a chart in that's going to be  under the insert here now I'm going to show you

one way here just a simple way here today for  this beginner tutorial and I'm going to just   want to chart the title and the worldwide gross  on it so what I'm going to do is I'm going to   highlight this right through here so I'm going to  highlight all these uh different uh titles here   I'm going to hold down control so what holding  down control allows me to do is it uh allows me   to select different parts um of it so I held down  control and I have two different areas highlighted   and that's what I want to chart in here so I'm  going to just go ahead and click on recommended   uh charts here so you can kind of see it gives  you some examples right away here uh you could   go to all charts if you wanted to look through  if I wanted a pie chart uh for this example   I'm just going to go to a normal bar graph like I  said I'll do a different video All About graphing   uh to show you more information on it but I'm just  going to go ahead and hit okay and so real quickly   what it did it took uh it took that information  uh that I selected and put it into a graph now   it might not be uh for me it's not finished yet  because maybe I want to add a title so if I just   double click in here and I can add a title so  if it was uh top grossing movies here and I'll   just leave it there and so I've added a title but  what you've noticed here on uh if you wanted more   things so if you wanted your aess if I click  on this for chart elements you can see I have   the maybe I want a title on the side so maybe  I wanted to uh I'll put uh in uh I'll just say   in billions here and I can just start adjusting  so make sure my charts um are coming out uh the   exact exactly the way I want to so you can look  at the different formatting options if I wanted   to change it uh you can hover over so maybe if I  like this one a little bit better I can click on   this one and then it's adjust adjusted so really  simple to start some basic charts on this one so   if I was putting it down below I can drag this  around and maybe I wanted to see what everything   was going to look like when I print it you can  see right now since I have the chart selected   that's what it's going to be printed right here  if I click off of it and go to back to my print   and now it's the whole page right here and now  notice that I might have to make some adjustments   because some of the uh some of the information  is off the page I'm missing some of the years   so maybe I want to make some adjustments to my  columns or choose a different type of page to   print on so this is just your kind of your general  overview of Microsoft Excel for beginner just if   you haven't used it before I'm showing you some  of the power behind it I'm G to have some other   uh some other videos about Microsoft Excel to uh  maybe help you increase how much you could use and   how effectively you could use it uh if you did  like itday hit that like uh button give me any   ideas what you might like to see in Microsoft  Excel tutorial just write it in the comments   down below thanks for watching this week uh  and I'll see you next time on teachers Tech