How to use Power Pivot - Microsoft Excel Tutorial

Hii, I'm Jamie welcome to Teachers Tech  and it's great to have you here today   I want to show you how to use  powerpivot in Microsoft Excel this is the third lesson in my intermediate  Microsoft Excel tutorials so if you want to learn   about power query in Microsoft Excel or maybe more  about pivot tables functions like vlookup take a   look at my lessons one and two and I'll link those  in the description and up above in the card and   I'll have more future intermediate tutorials so  if you want to stay in touch make sure you hit   that subscribe button to get notified when I put  those out but today is all about power pivot in   Microsoft Excel and powerpivot the main thing I  want to tell you about what I like about it first   before I get to it is that you can take multiple  tables for multiple sources and bring them into   a pivot table or pivot chart so if you've ever  wondered how you do that because usually if you   start go ahead and start a pivot table all you  can do is bring in one table but when you use   powerpivot you can create a data model by making  relationships between the different tables and   then they all show up in your pivot table or  pivot chart and then you can really dig deep   in analyzing the data and that's what makes power  pivots so great you have all these different ways   to bring in data from all these different sources  you can bring in millions of rows of data and then   you can perform calculations on those rows add  measures key performance indicators and today   on teachers Tech on powerpivot I'm going to go  through all these so you get started on how to   use powerpivot in Microsoft Excel so first of all  I want to show you how you can add power pivot to

your Microsoft Excel and this is free to do and  it's very quick because right now if you look   across my tabs there is no power pivot there it's  an add-in so what I'm going to do is go to file   and check Take a Look Down Below at options here  so I'm just going to click on options and then I   get the Excel options we have add-ins right here  and now powerpivot as you can see right here power   Microsoft powerpivot for Excel is a com add-in and  to go there all I have to do is drop down and go   to com add-ins and hit go at this point I just  need to check what I want and at the very bottom   here I have Microsoft powerpivot for Excel I'm  going to go ahead and just place the check mark   on that one and hit OK and as I do this take a  look at the tab my tabs up above when I hit OK and   you can see it was installed added and when I go  to powerpivot I have my new ribbon here that I'm   going to be walking through all these different  features for you today I do have some practice

files for you to follow along with me today and  if you take a look in the description you'll see a   couple different links and they are to these files  right here you're going to see student in school   and tuition fees so I just want to show you real  quickly what's in these I'm not going to dive into   them in depth but let's pretend we are a school  here we have student information all of this   is just fiction here just made up names we have  some courses all the different courses that our   school has here so there's a number of different  courses there's grades that students received   through different semesters in here so you can see  there's a GPA here on the side and we have all the   different semesters listed here that go back a few  different years and we also do have in our other   sheet this is a I'm just showing how many courses  they're enrolled in and how much it costs per   course so just one more Excel practice sheet there  so I just wanted to point those out I'm going to   go ahead and actually just minimize this one but  I am going to close this one right here so this is   the student in schools because when I bring the  data into powerpivot I can't have it open here   so I'm going to be bringing this in first so I'm  just going to close this down on this one I don't   think I made any changes but I'll go ahead and hit  save so now I'm just on a blank Microsoft Excel   worksheet here and I'm going to bring in that  data so to do that I'm in powerpivot I've selected   the tab here and we need to build a data model  so what a data model is it allows me to bring in   all these tables and build relationships between  them so first of all I got to go get the data then   we'll build the relationships so I'm going to go  ahead and hit manage now at this point I get you   can see Power pivot for Excel open up and take  a look at all the different external data these   are the different ways I can bring data in so we  can bring it in from a database and you can see   the different servers available we can bring it in  from a service and we have other sources here too   so if you take a look connect to a data source we  have all these different ones you can connect to   in today's example we're just going to bring in  this Excel file right here we're going to bring   in from here and then we go find the PATH so I'm  going to go ahead hit next and now a friendly   connection name that's fine with me Excel I'm  going to leave it as that I need to browse to   where those files are so I'm going to hit browse  and I have them right here so I'm going to bring   in student and school remember it has to be  closed for you to bring it in and hit open and   does it have headers yes this does have headers  on it so first row as headers I'm gonna I'm not   going to bother testing this I know this will  work here and I'm not going to go to Advanced   but I'm going to hit next here now at this point  you see all the different tables that are in here   so what I'm going to do right now is just go  ahead and select the top one because I want to   bring them all in I could select individual ones  if I wanted to or what I could do is if you wanted   a preview so if I wanted to preview student  information I could select that one and go to   preview and filter and I could go do some filters  but I can preview to make sure I have the correct   data coming in I'm just going to hit cancel I'm  selecting all my source data and I'm going to   hit finish and you can see it goes through with  success we like the green check marks here and   it shows me all the information brought in  so I'm going to go ahead and hit close now   so if you take a look at the bottom or the tabs  are you can see all the tabs are there just the   same information that we brought in from Excel  now into Power pivot but let's say if that file   updated so you have a connection now to that Excel  file and if you were putting more information   maybe more students went into it what you would  need to do is go up to and refresh and then this   data would update in here as well okay now the  next thing what I want to do we're not quite   done we have to bring in one more spreadsheet so I  could go back and show you the way I did it before   with bringing in sources bringing that file but  what I want to do is first of all I want to close   out of here so I'm just going to go up and hit the  X and you notice it goes right back to the sheet   1 that I was on with nothing on it but if I click  manage again here it just opens back up again and   then I'm back in with my power pivot so you can go  back and forth by just clicking that you do have   to save your file so if you're going to save you  could save you know this whole book here and then   that will everything will be remembered with your  power pivot as well okay so we have one more sheet   we want to bring in here so I'm just going to go  ahead and open this up so this one I want uh open   and I want to point out I could have went to um I  could have selected the table so I'm in this table   let's say and then I what I could do I could have  done to each one is just add data model from that   file and that would work what I'm going to do here  I'm going to show you that I can go ahead I'm just   going to go Ctrl C here so I'm copying with Ctrl  C and I'm going to go back to that other worksheet   and this is where I was working in powerpivot  I'm just going to paste that information control   V into here and I'll just go ahead and size it up  here so you can see and now if I go ahead and just   select this I'm going to go add to data model and  this also will add this to the data model so you   you can see now I have TBL tuition here and plus  all the other tabs so I could I know this is the   table here but I'm going to go ahead and just call  this tuition fees to label it like this and now   I have all the information the data that I want  and what we're practicing on today in here so I'm   going to go ahead and go to diagram View and start  setting up the relationships between these tables

so I just want to point out before I go and start  these relationships so if I'm on student info you   can see that there's like student ID here if I go  over to let's say grades I have student ID also   there well click on grade student ID here as well  so you can see there's connections between these   different tables if I go to courses we have a  class ID over here and if I go to let's say grades   we have a class ID over here so there's some  connections made you can see by just the labeling   but Excel doesn't know that powerpivot doesn't  know that by itself so we have to create those   connections between those tables I'm going to  go if you look we're just under the Home tab and   we're going to go all the way over and we're going  to go to diagram view here so I'm going to select   diagram view now there's five tables we only see  four at the very bottom I can change the display   here I'm going to drag this out so we could drag  this smaller so we can see things a little bit   better so now these are the five different tables  I have these right here you can see I can change   the size these this has four in here I think this  one should be fine you just click and drag so I   want to be able to show you all the different  columns in each of these tables here and I can   size them so I can see everything I just makes it  easier when you're making your relationships like   this and if I add more columns they'll show up in  here and I'll show you that in a moment when I do   some calculations after I have my relationships  so I'm going to move some things around just so   I can visualize what I want a little bit more  when I set up these relationships and I'm going   to be moving this grades right over to the middle  more and I'm going to move the students info over   here so I also like to kind of move mine around  to kind of help visualize this a little bit I'm   going to move this down as well so I'm going to  move my courses down here and I'm going to need   a little bit more room so I'm just I don't know  why I have to size that up I just like the way it   bucks so I'm going to give myself a little bit  more room in the display and I'm going to move   semesters down here as well okay so I'm going to  keep grades here and I'm going to keep tuition   fees over here so the reason I did this is  the way I like to do it to help me visualize what   I'm setting up so I know each student here could  have many grades in each course many grades and   each semester has many grades and I can see that  there's a relationship if I look student ID here   I see student ID here class ID to class ID and  semester ID to semester ID names The Columns don't   have to be named the same I did them so I can  easily find them when I'm making the connections   so to make the connection so if I look at student  ID here and all I have to do is click and hold on   my mouse and I'm going to drag it to student ID  here and it's going to make a relationship between   these here so what I and if I take this wherever  I put this that relationship stays there I could   break the relationship with this line if I go  ahead and right click on it you can see I can   make it inactive I could edit it or I could  delete it as well so if I made the wrong you   know relationship between two different columns  I go ahead and delete it then create another one   or just edit from here okay so I want to point  out here too we have this star and we have the   number one over here and like I mentioned before  I said well one student could have many grades so   that's this stands for many and this is one and  that's what it means so one student could have   many grades if I go over to my class ID I'm going  to drag it over to class ID so each course could   have many great so you can see the one into here  and same thing I'll go to my semester ID and just   drag it over here to semester ID like I said I do  don't have to have them labeled the same but the   value has to be the same in between those two  different columns I couldn't have one integers   and one being letters or anything like that they'd  have to be the same on it now so I have those you   can see these are all the one and these are it's  many when it comes to grades here and when I do   the pivot table and pivot chart these are the  relationships that I'm going to be working on   when I display I do have this one more table here  and I'm just going to make one connection here and   you can see I have student ID to student ID and  this is just um this is I'm going to be showing   some calculations with the columns and I need this  relationship to connect and I'll show you when I   create the calculations having that relationship  here allows me to go over to this table   from here I can go to this table go grab something  and be working over here on this table here so uh   these are just some steps what I like to do I  like to kind of organize visually my tables   and how I'm seeing things I don't have to do  that directly because those relationships when   I drag them around you see how they How They  still hang on I just like to visualize it this   way so we have our relationship set up now I  want to show you with some calculations first   that we can do with the columns to kind of really  show you how powerful this is with powerpivot to   add these calculations to this so I would need  to go back to data view here so I'm just going   to select data View and we're going to go over to  the tuition fees here and we're going to perform   our first calculation and this won't be through  a relation it'll just be on this table alone

so I'm going to go ahead and perform a calculation  on this one so I will need to use a formula what   I want to have happen is just very simple you can  see there's enrolled courses over here and there's   tuition per course I want to know how much this  is going to be in total so what I'm going to do   first of all let's go ahead and change our column  name I like to change that first before I do my   calculation so I'm just going to click up in here  and change this here so this is going to be called   total tuition uh here okay so I'm just going to go  ahead and then just click off of this and if you   look the whole column is selected now and where  I'm going to put my equation is right up here so   you can already see that the equal sign is already  to go here so I'm just going to click up here and   what is it that I want to perform so I need to go  5 times 3750 but I don't want to times those uh   from cell to cell it's this is going to be based  on the columns so all I actually have to start   doing is typing the column name so this is called  enrolled courses so if I start typing enrolled   courses you can see I get a couple different  options now the tuition fees is the name of the   table and the enrolled courses is the column so  if you see kind of these this double step here's   just the name of the column and this will work for  me here so I'm just going to go enrolled courses   and I'm going to multiply so I'm just going to  use the multiplication here multiply what well   it's tuition per course if I start typing tuition  per course it's this one I'm going to use you can   see there was the other one here but I'm going to  go tuition per course right here and I'm going to   hit enter and then watch what happens to the  column total tuition so I'm going to hit enter   and now I have total and I can format this  information too as well uh so you can see up   in formatting we do have our dollar signs here  where we can add this uh to any of these so we   have our formatting that you can do uh inside  this now what I want to show you now is I'm   going to go back to my diagram view here just  select this and you can see everything's set up   but take a look at tuition fees now I have a new  column called total tuition here so I just wanted   to point that out as we add the columns uh you  these get updated here in the relationships and   the views here so I'll go back to data view  now and what I want to do is perform another   calculation though I don't want to perform it  on this one here I'm going to go to student info now you can look at the bottom I'm on student  info tab here and I'm just going to scroll over to   the very end and you see that there is a payment  received column here so I know I just calculated   total tuition uh but I have payment received  so what I want to know is the amount owing so   I'd have to minus that total tuition minus the  payment received so I'm going to add a column   at this point uh you notice you can't just go to  any column and start typing something in right   so these are going to be made to perform those  calculations on it if we're adding more of the   data that's where we can go from our original  Excel file and like I mentioned before we can   refresh it and then everything we're creating in  here and the calculations will still work with the   new data that comes in so again we're going to  create a new column it's going to be right here   and it was going to be called amount owing so I'm  going to just type the amount owing right here and   that that's good I'm just going to hit enter and  you're going to see the equal sign come up here   so what is it that I want to calculate so I know  it's on the other table and so that's going to be   the first number right the amount owing minus the  payment received so if I go ahead and start typing   related Rel like this you get related  so this function allows me to find related tables   and so I've made that relationship to the tuition  fees here so if I go to relate it shows me here   all the different columns from that one that  I have the relationship to so I what do I   want I want to know total tuition it's right here  so this is the column I just created so I'm going   to go ahead and select this just like that I'm  going to add a bracket here to close this so I'm   just adding the bracket to close this up so what's  the next one well this is a simple operation it's   just subtraction here so what I'm might subtract  them well it's going to be payment received so   if I start typing payment received it's right  here so I'm going to select it and go ahead   and hit enter now and watch this get populated  here so now I was able to make this calculation   on student info since I have a relationship  with tuition fees over here I was able to pull   that column and use it in a calculation over  here so that goes I wanted to point out that's   the importance of the relationship if I go to  diagram view between here so this allowed me to   see here when I went from this one it allowed  me to see all of these different columns that   I could perform the calculation in so that's  just a couple steps to the calculation I'm not   diving deeper into any of the other calculations  but I want to show you what's possible once you   had the operations but there's a different type  of calculations you can do it doesn't have to to   be just with the columns you can use measures  as well so what's a measure well to get to the   measures there's a couple different ways that we  can do it and we'll start from being inside power   pivot but then we're going to move out and I'll  show you the other way that you can do it too

so measures are more calculations and I'll give  you an example of one here let's do a really   simple one I want to Total all of this tuition  here so if I go to let's say this spot if I put my   equals so we're just like in Excel with a formula  and what do I want well I wanna well I want   actually a total here so I know this is going to  be some if I start typing in sum I get my function   I select function what is it that I want well that  was called total tuition on tuition fee so I can   go to my tuition fees total tuition and I'm going  to select this one and I can go ahead and close   this up hit return and I have a measure now you  can't see it very well I can stretch The Columns   here so you can see it I can format it here also  but measure one I don't want this to be called   measure one what is this is tuition total  of all right so if I go up here into where the   formula is and if I just highlight this and I'm  just going to say that this is tuition uh total   and I'm going to put all just like that so just  so I know you can call it what you like but then   if I go ahead and just click off of this it will  get updated here so that's how you would go and   change the name you can see now it's I can add  a little bit more room that's a measure there   so let's do another one here what I want to know  is the total amount of enrolled courses so I want   it right here I'm going to just I'll put my equals  in and I'm going to do my sum here of all courses   so some and this is enrolled courses here on the  total of here so here it is tuition our tuition   fees enrolled courses I'm going to go ahead and  select this one and I'm going to just hit enter   and you can see it just added the bracket at  the end too measure one well again I don't   want this called measure one what do I want this  called let's just call this total courses total   course amount just like that so we can change that  if we want but if I click off now I have a couple   measures and I can stretch this out and so we have  two different measures there that we created okay   I'm going to go back to my student info one here  and I'm going to show you how you can use these   measures across different places because these are  created now and if I go to let's say well first of   all I want to know how many students I have uh  if I would how would I do that I want to add up   I could try to add up in different ways but I'll  show you a formula that you could use here so if   I go in here and if I'm going to go to the equals  again and this time I'm going to start typing this   distinct count right here so I know these numbers  are all unique here and so what it's going to do   is Count through all the unique numbers because  each one has to be different for each student so   I'm going to go to this one well this is on the  student info What's this called this is this is   the student one right so I would go find that one  right there so let's go find student ID here and   that should do the trick right here student ID hit  enter and I get a count of here well I can't see   what's in there I'll just stretch this out again  so we can see 18 I don't want to call it measure   one I want it to be called a student amount of  students so I'll just say amount of students just   like that so amount of students now I can take  measures and use them with each other too so if   I want to find the average cost let's say of what  the amount of each student is paying on average   so I have a in tuition fees I did calculate uh the  what did I calculate the tuition total here total   tuition all and I have the amount of students here  which is 18. so I need to divide those two to find   the average amount of each student is paying so  if I go here and I'm going to do another formula   here so if I put equals this time and it's total  tuition all so I start typing total and look here   this is the one that I have tuition total  oh I have that other one but that's not the one   I want but it has this new symbol for measure  I'm going to choose this one and it's just a   division and what was the other one well it was  this one it was the amount so if I start typing   amount it was the amount of students right here  so I'll select it and I'm just going to hit enter   and I'll get a total here so you see another  measure I'm going to stretch this out so you can   see uh we can change your name so I'll just put  average uh oops not that I'll just type average   cost per student like so and I'll click off of it  and I can stretch this out so that measure if I   ever needed it again and I can go and format it  also up here so that's some ways that you could   use measures but another way that you could do  this is to go right from the ribbon in   Excel so if I go and close out of this what I can  do is add a measure right from here so under the   power pivot tab I'm going to go to new measure you  can see I can manage my measures too so all those   different measures that I've created but I'm going  to go to new measure I can pick my table uh from   here so if I was looking I can go all through  these ones so what is it that I want to find   I could go to grades what do I want to call this  let's say I'm doing the average of the GPA so I'll   just type average GPA I'm not going to bother  giving it a description here what is it that I   want to do here so I want to do an average  here so I'm going to start typing average of   something so what is it and I know in that uh in  that one I have grades and I have uh it should be   I should be the grade here so I have grades grade  I'm going to go ahead and select this one here   and I'm just going to hit close the bracket  here so it's just going to be average this   is a number and now it's going  to be two decimal places here that's fine I'm   good with that decimal number all this is good I  could go and check the formula it seems everything   is flying get the green check mark I'm going to  hit OK so where did this go it's not on this one   well this wasn't even the table that I told it to  put on if I go back to manage now and I put that   under grades so grades and I'll just stretch this  out here so we can see it average GPA 2. 49 so it   went through here and made the average of 2. 49 so  now I have this measured called average GPA and I   did that from just adding it that other way so  a couple different ways you can do calculations   from The Columns to the measures try playing  with different ones getting used to those once   you build them they can add a lot of power to your  power pivot so now we're at a point where I want

to display this data and I want to use a pivot  table to do this and I'll also show you in a pivot   chart because this is what it's all about it's all  about taking all that data so like I said at the   beginning all those millions of rows going through  performing these calculations uh adding measures   and then you're able to really display what you  want to dig through that data okay so we can add   our pivot table in a couple different ways right  from power or pivot if we take a look up here we   have pivot table here and I'm just going to do the  drop down you can see our different options right   through here this tutorial I'm just clicking pivot  table and I'm just going to select it and where do   I want it well I want this to a new worksheet so  I could go existing if I want but I want a new one   and I hit OK and just like that if I take a look  over on the side now all of the different tables   are in here so remember usually you can only  bring one table in but now that I built that   data model built the relationships I'll be able  to pull information from different tables and it   will show up in the in the report that I'm  building now I'm just going to go ahead and just   delete this one really quickly here because I  do want to show you can insert it kind of the   normal way if I go insert and then pivot table  well we don't want to go from table range we   built a data model so we could go from this right  here and then we go new worksheet hit OK and it   brings us to the same place so I just wanted to  show you a couple different ways that you could   start your pivot table from and but you do need  to grab that data model in order to do it   so now on this step let's try picking some of the  fields to build a report so what I'm going to dig   down and find out here is I want to find out how  the different courses are going throughout time   to see if there's any fluctuations with different  semesters on this so what I'm going to do first is   I want to see the courses is show up so my courses  I'm going to go to this table just open it up and   I'm going to put a class name so I get class name  and it puts it into my pivot table here to begin   with you can see those are all the classes we  offer now I also want let's say a grade next to   this so if I go ahead now if I go grab a grade  and take a look notice that we created these   measures and everything they're also in where I  could be grabbing them in but in this case I want   to grade so I'm going to Select Grade now the  issue rate here is it just did a sum if I look   over here it did a sum of these well I don't want  to sum I want an average of the grades for here   so I can change this I'm going to just drop down  and I'm going to go to Value field settings and   I want this to be an average but I also want to  change my number format to number and two decimal   places like that so I hit okay and now  that's better so this makes more sense to me I   have an average I get to kind of see of all the  courses but let's dig a little further now let's   say well you know I want to know also by semester  so if I drop down I'm going to pick semester here   so now it's showing me fall there's this was the  average I can see the different years of it uh   audit and I could even go a step further and if I  was going to go and find let's say maybe a student   information I want the last name here I could put  a student ID but I'm going to go last name now it   even breaks it down so I can look at algebra by  default the different students in it what their   GPA and so as I go down I could go through this  way and remember with pivot tables I can drop   down and filter through it so if I wanted to see  a specific uh subject I could just go through   here I'm also going to show you how to do some  slicers when we put the pivot chart in I'll show   you how you can add some slicers to go through  this information as well so all these different   tables that we have connected I'm able to build a  pivot table from selecting different ones so you   can go ahead and try and see what you find through  here if you want to dig down and find different   data and see what works for you when you're  building a pivot table I want to add one more

thing to this pivot table and that's going to  be a kpi a key performance indicator so how we   do this is I'm going to go back to pivot table  here and you can see we have kpis right here and   I haven't showed you how to use this yet but what  we're going to do is go to new kpi like so and we   get this here so remember I made a measure and we  have to base this on a measure I made a measure   average GPA so I'm going to use this I'm going  to select this one average GPA and it's going to   be an absolute value here and it's going to be  out of four I'm going to put down so I have to   change if I didn't change this then this would  all be skewed off so it's going to be four so   just like that so what's going to be the green so  what's the indicator that would be best for me   for green so I'm going to say actually don't mind  that so when I clicked in there it said 3. 2 1. 6   divided this up I could slide this if I wanted it  different on it I'm not too worried I just want to   demo this how this could work and we'll just leave  it uh we'll leave it right there so if they're 3. 2   and above it'll be green the target you can see  how we could divide this up into if you needed   more areas to divide up you can do that and  you can change your colors so I'm going to go and   just choose this one right here so and it will  look like these so I'm going to go ahead and hit   ok now what I want to show is on the side notice  this uh so I have a new column that went in here   right I have 0 1 minus one uh these don't show the  uh the lights that I picked they're showing   that one would be above average you can see it and  zero would be neutral and negative one would be uh   the color or the be red it'd be below but if I go  and open this up and turn off status and then just   turn on the goal you can see that comes up or this  you can see I have different ones so if I turn   back on status just like that after I click it  on click it off and then I have these indicators   right here so I just want to point out how you  can add these kpis to this so another quick visual   because this is where you have so much data little  visuals like this can really help you kind of   Target in and say oh what's up with this one why  is it that color so that's how you could use kpis

so now if I want to add a pivot chart to this I  can be under the insert and you can see there's   pivot chart right here I could also go back to  uh the other way when I showed you and I was in   powerpivot when they had the insert pivot chart  from there as well but I'm going to go ahead and   first of all before I do this I don't want to have  this in my Pivot chart at all so I'm going to just   turn this off and the other thing is I'm not going  to have names in my so I just want to see a pivot   chart this time and it's going to be just kind  of seeing the difference between each semester   and I want to be able to see it on each class  so right now I have a filter on and I can change   the filter here as well so if I didn't want it to  be algebra and I wanted to select all you can also   do this from uh beside here so if you go over  and find where it is and you drop down you can   see the filters come up here so if I select all  hit okay everything's there now I'm just going   to go back to what I was before on this because  I just want to start with we'll say one of   these just it'll make a little bit easier when we  visualize our graphing so now if I go and go up to   Pivot chart here and I'm going to go click this  pivot chart and I can pick kind of what I want   you can see how it has the column one if I hover  over it shows me each uh each semester how things   are going I could maybe do a line I'll maybe I'll  do a line here like this and hit okay so I could   hit okay and just like that now I have this one  here and I could filter through so just like I   showed you before if I wanted to pick a different  one maybe we'll go with American society hit okay   and you can see how it changes so we could go  through we get our pivot chart it allows us to   view our data what we exactly want to see I could  go through and edit this chart to make it look   nicer I'm not going to do this in this one I like  in my other tutorial I do get bit more into this   one but this is more just like what I want you  to show you the data that is being chose but   let's say I want to add a slicer to this I don't  want to drop down over here and picking each one   slicers are a great way to make a interactive  quickly change what you're looking for so if I   go up to slicer up here to see all the because  I have my relationship my data model I can pick   what I want and what was it well it was the class  name so if I go class name hit ok now I have this   slicer and I'm just going to go ahead and move it  down here just so it fits into the shot and so now   I could go through if I go back to Algebra I have  this slicer that allows me to go through and check   to see gives me that quick visual of what each  course is doing through the different semesters   to see if there's any uh fault any ones that fell  off all of a sudden some of them don't have every   semester that they're offered all the time but as  I go through it gives me that quick visual to see   if anything is standing out so I hope you like  this walkthrough of how to use power pivot in   Microsoft Excel we covered a lot of information  here today but I hopefully got through of how   great of a tool this is to bring in when you do  have so much data millions of rows where you can   perform those calculators calculations and then  you can dig down with the pivot tables or your   pivot charts and to really where you can share  that information with other people and really see   what's happening so thanks for watching this time  on teachers Tech let me know what you're looking   for Down Below in the comments if you're looking  for more intermediate Excel or what type of Excel   or other Tech thanks for watching this time see  you next week with more Tech tips and tutorials