Get Ahead FAST! Excel Express Tutorial for BEGINNERS!

are you in a hurry to learn Microsoft  Excel well you're in the right place hi I'm Jamie and welcome to teachers Tech  and welcome to my Microsoft Excel Express tutorial   we're going to cover a lot of information in a  very short amount of time we're going to start   at the basics but level all the way up so that  you're feeling confident by the time you leave   today let's get started in today's Microsoft Excel  tutorial I'm going to be working on Excel from my

Microsoft 36 65 subscription it's something I pay  for gives me access to all the Microsoft different   apps I need but if you don't have access to this  let me show you how you can get Excel for free go   ahead and open a browser like Microsoft Edge or  Google Chrome and type excel. new go ahead hit   enter now this brings me to excel online I already  have a Microsoft account so it went right into it   but if you don't it's going to ask you to go ahead  and create one and you can do this all for free   and then you're going to be able to follow  along with me today when you launch Microsoft   Excel you're greeted with this page you can go  ahead and create a brand new blank workbook from   clicking here or if you want to jump start take a  look and explore through the different templates   down below you'll see that you can open your most  recent workbooks for quick access or you can have   them pinned or you'll have access to the shared  with me if you go to new you're going to see a   different way you can open the workbook from  blank or explore the different templates open   will allow you to explore things like your  PC or your one drive to find the file that   you need to open I'm going to go back to home and  create a brand new blank workbook when I created

this blank workbook it was created with one sheet  what you're seeing with all these rectangles here   is the first sheet Take a Look Down Below at the  bottom it says sheet one I can create more than   one sheet in this workbook if I hit the little  plus here it would become another one sheet too   you can rename these as well so if I double click  on sheet one I could call this demo and now I've   renamed it I can jump back and forth on each of  these sheets you're going to see a bunch of these   rectangles now they're going to be inside the  columns which are shown by the letters up top   and the rows which are the numbers on the side  if I click in any spot where the row in the uh   column intersect that is going to be the cell so  and right now I'm in C4 and you can see that up   here in the name box uh whatever one I click on  it changes to that name you can actually rename   it from here right now this sheet is quite tiny  and I don't like to work when it's that small if   I want to zoom up take a look at the bottom right  hand corner right now I'm at 100% I can increase   this and you can see how the cells increase which  may make it easier to work for you let's go ahead   and start entering in some data but first of all  I want to have a header row I'm going to go and

click in A1 and type in employee name I want a  capital here so I'm going to go back if I hit   enter notice that the it drops to the cell below  it but you can also use tab and that will go to   the right and you could also use the arrow keys or  click on whatever cell you want after you type in   now if I click on B1 here you can see I'm in B1 I  could type my next one if type region this didn't   delete what was in A1 if I click on A1 notice  it still says employee name in the formula bar   if I click on B1 it says region it's because this  column isn't wide enough now if I just hover in   between here I can drag the column wider notice  that how it's getting wider or if I doubleclick   on it automatically adjust to what it needs to  I'm going to show you a little later how we can   do all the columns at once so I'm going to click  in C1 and type in month hit Tab and we'll go with   sales and I want one more it's going to be bonus  I went through and entered a bunch of Records here   if you want to follow along now I have this down  below in the description this workbook where you   can click on it and download it so you don't have  to type this all out and practice with what I show   you notice right away that this is all squishy and  I did this on purpose so that you can adjust this   if I go ahead head and click on this will  select the entire sheet all I have to do is go   in between any of the columns and double click  and it will adjust all the different columns   with to fit at once the next thing quickly if you  want to adjust any of the formatting let's say if   you want to have across the top it being bolded  I could click on a single cell or go across and   select multiple cells to get a range and apply  formatting let's say bold or italic or I could   change the font or the font size change the color  of the font or even the background through here   remember you do have the undo or contrl Z as  the shortcut which is a lot more efficient if I   click on it a few different times it goes back to  remove them now this is still selected I could go   to sell Styles and apply a style quickly so as I  hover over it shows what it looks like if I choose   this that style is applied to that region that I  had if you've decided you need to add another row

you can go ahead and do this quickly to wherever  you need it if I click on number one and notice   the whole row is selected I can right click on  the number one and click insert this inserts   a row above here now I can go and put some more  information if I wanted to be titled I can also   if I select multiple rows and do the insert that's  how many rows will get inserted and I can do the   delete also if you need to delete any rows you  can select and you can rightclick and delete this   works the same with columns so if I highlight two  columns and go insert it inserts the two columns   as needed now another thing you can do in this  case if you wanted to merge and center across the   top here what I can do is if I highlight through  here from a to E notice that we have this is   merge and center yeah if I drop down you can see  how you have a few different options you can even   unmerge the cells after to split the cells but if  I just go merge and center it will take that text   I have from A1 it merged those cells together and  placed it on top in Microsoft Excel there's many   ways to do the same thing so I've showed you  to delete or insert columns or rows by right   clicking but we can also take a look in the ribbon  the ribbon is this area up top these are the tabs   as I click on each of the tabs the ribbon changes  so if I go to the Home tab and look in the ribbon   over here notice that in cells I have delete  so I could go ahead and click on delete sheet   rows now that row is deleted just like I showed  you before at the other method and I'm going to   leave that deleted because I don't want it in my  as I move forward now another thing if I want it   to form format row height or column width you can  see I can do it from here as well let's go and do   some formatting to the numbers here if I go and  highlight these take a look

in the ribbon under the number category here I can  apply let's say a thousand separator so if I click   this it quickly adds the com add adds the comma  to show the Thousand separator notice it has the   two decimals if you want to increase or decrease  decimals you can just click on these if you want   to decrease or increase you can make those quick  changes we can quickly change it to perc format   or the dollar so if I click on dollar it changes  it over to the dollar here if I drop down you can   look at certain countes dollars if you need to  use that I do want to point out if you ever see   this so these hashtags are number sence in here  all that means is that there's not enough room   and you have to make the adjustment on the column  width because as soon as I uh set make sure that   it's enough room you'll see that they all go  away so a lot of people do ask where did that   where does that come from it's just formatting  the width of the cell so it fits in another thing

you might want to do is change the location of  a column or row so if I go ahead and highlight   this sales here I can move it to a different place  so I have it highlighted I'm going to hold shift   down on my keyboard and as I bring my mouse notice  how it Chang changes to the Crosshair has changed   it now I can click and left click on my mouse and  hold and drag it over I've just moved sales over   here so I can adjust it uh just like I showed you  before to make sure it fits I'm going to go contrl   Z just to move it back you can also do this with  Bros so if I select this where it says Dwight Sho   and hold shift down and as I go in between notice  how it changes I can drag this down in a different   location I'm going to go contrl Z just to put  it back again so take advantage of that little   tip to quickly change rows and columns locations a  powerful feature of Microsoft Excel is the ability

to be able to sort and filter your data so if I  go up to the data tab right here and looking in   the ribbon and you can see that there sort and  filter if I click on sort and I'm clicked inside   this range here but if I now choose let's say  if I want to have employee name and I'm going   to leave this the same I'm just going to leave  it as cell values here and I'm going to leave   the order A to Z if I hit okay now it took all the  different names and sorted all their information   based on alphabetical here so it's a quick way to  uh just get things organized in your data what I   like are filters if I click on filter up top and  I'm collect in this top uh row over here with the   headers it quickly gives me these dropdowns so  if I was going to go let's say to region and   I don't want all of them selected if I just if I  click on this again nothing selected I want to see   North and if I click okay now it's only showing  me the North if I go up top notice that there's   clear and I click clear and will put it back but  maybe I wanted to see the month and I could go   select all it's all clear but I want to see March  and February and hit okay so now it goes through   and puts it through here and then I could go  and sort this as well if I go and clear this   and I click on filter again you're going to notice  that this is gone those little drop downs are gone   from the headers another way to visualize data  is through conditional formatting so let's use

these numbers again here so if I highlight this  range and I'm under the Home tab in the ribbon   conditional formatting conditional formatting  allows me to apply a color or F formatting to   based on what I tell it so if I go to color scales  and I just hover over uh you'll see it shows me   what it would be the Green in this case being the  lowest and this one the Red's the lowest and the   Green's the highest so it will scale these up but  I could also go and give it rules and if I pick I   want it to be greater than and we'll say I want  let's say 7,000 and what   do I want to have happen I wanted a green fill  with dark text so as soon as I apply this I can   hit okay so now anything above 7,000 has that  color applied to it so conditional formatting is a   great way to really just uh take your data so you  can quickly look at it and read what it's telling   you let's move over to formulas and functions but  let's first clear this conditional formatting if   I go up to conditional formatting again and clear  rules I'm going to go from entire sheet and it's

gone formulas in its Simplicity let me give you  an example if I type 5 + 7 and hit enter nothing   happens 12 doesn't appear when you're entering  a formula in any cell you always need to use the   equal sign first to get it recognized as a formula  I'm just going to hit backspace or delete now I'm   going to put my equal sign in and do the same  thing let's go 5 + 7 and hit enter this time it   performed that operation so if I click on it if  I take a look this is where you're going to see   the formula up top here you can see equals 5 + 7  I could go up here if I wanted to make a change   if I put this to 10 it will reflect down here but  this isn't how we really want to use formulas I'm   going to delete this in Microsoft Excel a better  way would be to use cell referencing what I mean   by that is if I put the equals in and I click  on this cell so I'm referencing D3 and now I use   let's say we'll keep with just the addition and I  click on this cell and I'll do one more and we'll   click on this cell I could keep doing this more  and more and I could hit enter and it   added up all of those if I click on this it shows  me in the formula bar if I double click on this it   will show me the Formula right here so if I hit  enter it goes out of it but now take a look at   this if I go to D3 and watch how fast this number  drops I'm going to put 100 in here so as soon as   this gets entered in this changes so that's why  cell referencing is a much better way to do this   but an even better way is to use the functions  I'm just going to go contrl Z put this back and   hit delete so uh there's different ways we can get  to functions and I'm going to show you up top with   the tabs if we go to formulas and we have some  quick ones to use so I'm going to go and click   on the bottom here and take a look at this we have  Auto sum if I do a drop down we can go through and   find different ones here but if I just click  on sum it recognizes just based on these being   numbers it's saying sum D2 to D21 if I hit enter  it sums up everything here if something changes   here it automatically gets reflected down at the  bottom so a lot easier than saying This plus this   plus this so I can quickly change this  if I wanted to see even an average I can do that   if I wanted to see Min or Max there's lots of  different ones I can quickly do now there's   lots of different formulas here as well so if I  start dropping down if I was doing logical and   I'm going to show you how to do an if one a very  simple one in a moment here uh we can do things   like math or trig lookup and reference V lookup  is a very popular one I have lots of tutorials   on all these different things that I'll make sure  I put down below in the description and up above   in the C uh but if we want to now let's say I'm  going to go back and just delete this spot here   and we'll go back to this spot if I type equals  and I could just type start typing sum and this   is going to give me some way to get to it I could  select it and then select my range and hit enter   so that's another way you could do this I'm going  to hit delete on this another way you'll notice up   here insert function I could click on it I could  go search for something so if I was looking for   a sum I could hit go there's my sum I'll select it  I hit okay what do I want to sum this will walk me   through step by step the way to use that certain  function so this is a great way when I go okay

at the end it performs that now these are simple  ones so I mentioned the IF function if I wanted to   say uh yes or no on here when I apply a function  I want to say if this is above 5,000 give them   bonus and I just want this to say yes if not say  no let's go ahead and put our if formula function   inside this cell here I'm going to go and insert  it insert function the if is right here I could do   a search but I already see it hit okay The Logical  test I'm going to just click on this Arrow I'm   going to select the cell I'm going to say if D2  is greater so I'll put the greater than 5000 and   I'm going to hit enter and it goes back what do I  want to have happen if it is greater than 5,000 I   wanted to say yes what do I want to have happen if  it's the other so the other is going to be below   5,000 I wanted to say no so I hit okay this is  my formula up top here so if D2 is greater than   5,000 say yes otherwise say no and that's what  it's doing right now if I want to copy this down   I can drag this down so this is no I could drag  it down again notice it says yes and take a look   at this so as I tight Click on each one D3 D4 it's  all automatically copying down to the right cell I   can doubleclick on this green Square in the corner  and the autofill will go down if you want to save   yourself a lot of time get used to using autofill  and Flash Fill I got a whole video on that that   will make you look like a pro I'll put the link  down below now I want to show you the power of

using tables in Microsoft Excel first of all I'm  going to delete this function that I have down   here and now I'm going to apply a table if I go to  insert and take a look at the ribbon I have table   notice the shortcut control T I'm going to select  this it automatically detects where my range is   you can see A1 to E21 does my table has headers  yes I'm going to hit okay notice right away how it   just makes it easier to read I can quickly change  the formatting on it by clicking the table Styles   up top these it has the filters like I showed you  before how we added but this automatically comes   with it I won't go through and sort this way it  works the same if I'm at the very bottom and if   I'm adding let's say another row if I just hit  tab it automatically uh adjusts adds it with the   correct format adding and it even copied down that  uh the function that we had here automatically   so it makes it great to add more information in  another thing that I really like and notice when   we have the table created we have this new tab  called table design I can go ahead and click on   this and add total row banded total rows so this  gives me this at the very bottom if I click on   this right here let's go where the total is I have  this drop down if I select it I can choose what   I would like here so I the list is even longer at  the bottom so if I wanted to do my uh my let's say   my average there it goes here so if I want to do  my sum I can quickly add it so I don't even have   to go through and create my uh use my formulas and  functions like I showed you before if you want to   turned off the banded rows you can see how I can  just click them on and off but these tables make   it great because then when you use the tables  you can also see your charts and pivot tables   update automatically and I'm going to show you  how to do that in this tutorial let's visualize

data with a chart in Excel I could apply it to  this information but I think it'll work better   with this data here so if you click if you're in  the practice file just click chart at the bottom   and we have some information here first of all I  noticed that I don't have the months across with   autofill if I select this January and just drag  across it will automatically fill that in now I   want to chart this I'm going to select this area  and go to insert we have recommended charts we   do have the other charts we could pick but I like  starting from recommended it suggest charts that   I could use here uh if I go to all charts I could  switch on any of them as I go through uh I think a   bar one like this will work the best this one is  by the months and this is by the person here so   let's say I choose this one here and I hit okay it  quickly gets added in I can make some adjustments   to this maybe I want this to be a different title  and if I look up top when I click on this in the   uh up top under the chart design and we see in the  ribbon I can quickly format it so if I drop down   you see all the different options that I have if  I check this one so I can quickly add the chart   to visualize the data and I can go through and  customize it the way I'd like I've showed you

a number of different ways to visualize your data  and drill down to see what it means now I want to   show you how to use pivot tables in Excel this  is probably the most powerful way to really find   out what your data can tell you inside this table  that we've created I want to go to insert and we   can see pivot table right here I'm going to just  select from table or range so a range would have   been if we didn't have it in table but we have it  in table so I'm going to go ahead and just select   it the table name is table 4 that's what  I called it and it's going to be created on a new   worksheet you could go on existing worksheet if  you want I'm going to say new worksheet and I'm   going to hit okay I'm going to go ahead and get  zoomed up on this so we can see a bit better and   now if I look over here on the right to pivot  table Fields I'm going to click employee name   when I click on it gets added right up here so  we have the different names of the people on the   table now if I go ahead and click on region it  gets added also to the rows here if I don't want   the uh region to be in the rows I can just simply  drag it over to the columns I kind of like this   look I'm going to leave it here so I have East  Northwest and grand total now I want to have sales   so if I click sales it quickly gets added you can  see again how quickly you can analyze this data by   just selecting the fields that you want I could  also choose month so if I go ahead and click on   month now if I look at the data we can see it  broken down by person by month by region over   here I'm going to just unclick month here and  I'm going to add month to filters so with month   and filters it places it up top so I can go and  drop down and search for let's say February hit   okay so I'm looking through the different regions  of the different sales people for February I hope   this gives you an understanding of how pivot  tables work and how powerful they are make   sure you take a look at this other tutorial  I have where I dive much deeper into this I   hope this Microsoft Excel Express tutorial has  helped you out it's got you feeling confident   and good about learning Excel and you want  to learn even more make sure you check out   those other tutorials that I've mentioned  throughout this tutorial here today thanks   for watching this time on teachers Tech I'll see  you next time with more Tech tips and tutorials