How to get meaningful results from your raw data using Excel Pivot Tables, Pivot Charts and Slicers | Thomas Fragale | Skillshare

How to get meaningful results from your raw data using Excel Pivot Tables, Pivot Charts and Slicers

Thomas Fragale, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Lessons (37m)
    • 1. Skillshare pivot tables

      1:01
    • 2. Pivot Tables Lesson 1 - Getting Started

      9:13
    • 3. Pivot Tables Lesson 2 - Getting a Drill Down

      1:02
    • 4. Pivot Table Lesson 3 - Changing the Calculation Type

      3:06
    • 5. Pivot Table Lesson 4 - Adding Levels of Detail

      3:36
    • 6. Pivot table lesson 5 - Creating a Monthly, Yearly, Quarterly, or Daily Report

      3:39
    • 7. Pivot Table lesson 6 - Sorting and Filtering the Pivot Table

      3:32
    • 8. Pivot Table Lesson 7 - Adding a Chart to the Pivot Table

      2:47
    • 9. Pivot Table lesson 8 - Adding Slicers and Timelines

      6:29
    • 10. Pivot Table lesson 9 - Creating many Summary Sheets

      2:24

About This Class

This video will show step-by-step how to take your raw data that you have in Microsoft Excel and get great results that can help you make better decisions using pivot table.This will make it super easy so anybody can get great results pretty quickly

You will learn the following topics:

  • How to make a basic pivot table
  • Generating a drill-down to show the detail breakdown of any number shown in the pivot table
  • How to change the type of calculation
  • How to add multiple calculations
  • Where to find even more calculation types, including % of total
  • How to add more summary levels
  • How to make the pivot table into a daily, monthly, quarterly, or yearly summary
  • Sorting and Filtering the pivot table
  • Adding a chart to your pivot table
  • Adding some more filters with the powerful new slicer and timeline features, which create an easy to use dashboard.
  • Creating multiple sheets from a pivot table

Transcripts

1. Skillshare pivot tables: how to get meaningful results from your role day that using Excel pivot tables, pivot charts and slicers presented by Tom for Galley Microsoft Certified Trainer This video is a step by step tutorial on how to use Excel pivot tables. It's going to cover how to make a basic pivot table, generating a drill down to show a detailed breakdown of an inversion in the pivot table. How to change the Tech of Calculation had multiple calculations. We're gonna find even more calculation. Types, including percent of total, have a more summary levels, having made the pivot table into a daily monthly quarterly or your news summary. Sorting and filtering the pivot table having a chart your pivot table adding somewhere filters with the powerful new slaves er and timeline futures, which created easy to use dashboard and credit multiple shoots from a pivot table. Thank you for watching my video. I appreciate it again. My name is Tom for Gallant, and I'm a market stall certified trainer 2. Pivot Tables Lesson 1 - Getting Started: in this video, I wanna shatter, Get started with Microsoft Excel pivot tables. A pivot table is a great way to summarize a large amount of data. You could make a lot. You can take a large amount of data and get all kinds of different some reports with a pivot table, so I'm gonna show you all about it now. First of all, let's take a look at what the data's should look like. Notice up here. The field names are on the first row. Each row after that is a different record or a transaction. Each column is a different field, and I want you to notice that when I scroll down, it's going to be one continuous block of data. So there's no blank rows until the very bottom. And there's no blank Hans until the right hand side. So you want this to be a continuous block of data all the way. Now this could be thousands and thousands of rose. You just want to make sure it's continuous, with no blank rows and no blank columns. And also there shouldn't be any emerged. Sells the murder sales really get in the way. All right, now, I'm gonna show you this in Excel 2013. But the same technique will also work in Excel 7 10 6013 and 2016. So you have this big block of data. The field names were on top, and it's one continuous pocket date all the way to the bottom. We're gonna click on one cell that's not blank, then will come up here and pick on the insert mint. You're on the top and start and a pick in the world pivot table. So I said that insert and then pivot table and we get this window. Let's take a close look at this window. So first of all, it usually has the proper data range right there. And in this case, it does. It goes from a one to J two or three. So basically it's gonna get onto the next blank row in the next buying column. If you want to pick a different range, you could do that. But usually that is the correct range. Now, the only time that you have to pick using external data source is if your data is not an excel, you did it might be in access or sequel, server or or like, or something like that. And then you would choose used in external data source. But most of time you did. It is already in excel. So you just use that top one. And typically it has the right day, their engine there. Now, you could pick a different data range if you want to, but usually that is the correct re entry from the beginning. Now, typically up with this on a new worksheet, you could put it onto an existing worksheet, but most of the time I put it on to a new worksheet, so I'm gonna zoom back out again. You're hardly ever have to change anything on that window. This is not the window where people get confused on on pivot tails. I'm gonna click. OK, now this is the sheet where people get confused on we pivot table. So let's see what's going on. We have a lot going on here. First of all, we're on a new shoot. My data is still on sheet one, as we can say, but we asked for a new sheet, so put the pivot table on sheet nine or the next available sheet, as we can say, knows how you have your field names over here. That's why I kept on saying that it's so important that have your field names in the top of your pivot table because the pivot table is gonna use this. So you're gonna move your field sees different sections when, if we want to have a cross reference for each office for each airline. By the way, if we go back to sheet one, these are airline transactions. So you TRO is a different flight. Maybe the office is where you bought your ticket or where you traveled from. And the airline, of course. And a destination takes associate it with flying. So I pick on sheet nine. What if I wanted to cross reference for each office for each airline? Well, that's going to give you some big clues. Now we're going to drag our fields, so I'm over here on the office field and I want to drag it from here down to the ruse right over here. Now notice what happened on the left hand side. Each row is a different office because I moved my office yield into the road section right over that. So the pivot table is over here on the left. We're just building the pivot table over here on the right. Now. I said I wanted to cross reference for each office for each airline. So therefore, I'll pick up the airline from the fields and drag that over to the columns. Right? Fair. And this will be have we have a grid that is showing the the office is down the sign and the airlines of top. Now that put some numbers in your pivot table, you move something into the value section over here. Now, typically, you use some kind of number field for the value section. You don't have Teoh. You can use different types of fields. But when you use a number field, you'll get more calculations available, and we'll see that in another lesson. So I pick up the total field and drag it over here into the value section. Now, in those three steps now, I have a cross reference for each office for each airline, as we can say. Now, we're going to go a lot further with this, of course, but we're already starting to get some great results from a pivot table. So you move. Send it to the road section, you move something to the column section, and then we moved into the value section and with industry steps. Now I have a cross reference for each row for each office for each airline. That's how each row gives me a road total. Each column gives me a column total, and I even have a grand total, so I think it gives you a lot of information. I have a cross reference for each row for each office for your airline. Each row gives me a road total. Each column gives me a column total, and I even have a grand total. So if you look over here in the right, any feel could be in the road section soon. We'll have more than one field there in another lesson, and we could have any field in the column section so you could do cross references on any of your fields. Eso where I just start to get some great results in the pivot table and we're just getting started. So let's say you show this to your boss. You're all proud of yourself, you made your first pivot table. Your boss says, OK, listen, I really wanted the airlines over here on the side. I went to the offices of top. Can we do that? And that's the kind of your boss asked for it. Five of five on a Friday afternoon. And you're like, you know, I really have to get out of here, you know? You know, the whole weekend thing that people talk about. I love the experience that So here's what we can dio. It's just a matter of flip in your fields. I'm gonna pick up the airline, feel from the columns, right, Fair, and drag it over to the rose. Now, this gave us a different report. Now it's looking down for each row for each office. For each airline is we can say so. Maybe you like it like that. It's just a different look at the report, but watch what I'll dio. I pick up the word office from the Rose and drag it over the columns. Right fat. Now you'll see that each offices up top and each airline is on this side, so it's just a matter of flipping your fields back and forth when you realize that the possibilities here are pretty big. So watch again. I'll come over here and I pick up the the office from the coms and move it to the Rays. And I pick up the airline from the rose and move into the columns. And now it's back the way it was before. So really, it's just a matter of Dragon. It feels back and forth now, notice to feel this is pretty important to have over there on the right hand side. If I click on a blank sell, it goes away. But if you pick one of your numbers over here, then usually it'll come back. Did you pick in a black sell? It goes away. If you pick one of your numbers, it comes back. In most cases, I say in most cases, because here's what could happen. Follow my mouse over here, and I'm gonna close that window on the right with the X ray. I'm gonna close that window. Now if I click on one, the numbers, it does not come back now when that should happen to you. I'm not saying if I'm saying when that will happen to you because it happens to everybody to stop is to May. Here's what we're gonna dio we're gonna right click on one The numbers, right click. Then I'll come down here and pick on Schofield best, and then it will come back. All right, So if I click on the black sell, it goes away. If I could pick up one of my numbers, it comes back. If it doesn't come back, That means you've closed this window over here on the right like I just did. At that point, you're right. Click on one of numbers, then you'll pick on Schofield list and then it will come back. Clearly, it's kind of important to happen around when you're building your pivot table. I've had people call me on my cell phone. I feel this isn't there. What am I gonna dio? First of all, calm down. Second of all this walking through. Okay, so I know it's gonna happen to everybody. It still happens to May. So, as you can see, we have a nice head start, are building our pivot 3. Pivot Tables Lesson 2 - Getting a Drill Down: in this lesson. I want to show you how to do a drill down in your pivot table. Here. We have a nice pivot table that were made in the previous lesson, and it's a cross reference by office by airline, because we moved the office over here into the Rose and we moved the airline over here into the columns to get a drill down. I'm gonna double click on one of the numbers DoubleClick, and that's going to get to a different sheet. That should do all the detail transactions for that number, and that's called a drill down. And that's Bill. Didn't when you're making your pivot table knows how that brought us into a different sheet . Now we're on shoot 10. Let's go back to sheet nine, and I want to double click on one of the numbers DoubleClick, that president to a different sheet that shares all of the detail transaction for that number, and that's called a drill down. I think that's a nice feature, knows how that made a new sheet she 11 hold back to shoot nine. So just remember, just have the double click on one of your numbers on your pivot table, and that's where you get to detail transactions or the drill down 4. Pivot Table Lesson 3 - Changing the Calculation Type: in this lesson. I want to show you how to change the type of calculation in your pivot table. So over here knows how it says some of total right there and, uh, follow my mouth's to the right side of the screen. And over here in the value section, it says some of total. So you're going to click on the pull down where it says some of total and then we'll pick on value Field settings is the important choice and knows how. I have some count average maximum minimum product, standard deviation and variance so you can choose any one of this and I'll pick on count and all clicking OK and those how they went from sums accounts. So you're going to click on this. Pull them right over here where it says Count of total in the value section, and then we go back to value field settings and then we'll pick on some, for example, and we'll click OK, and now they're sums again. Now what if you want to see the some and account at the same time? Well, we'll just move war the one field into the values section, so I'll pick up the total field again from the fields and dragon over here into the value section a second time. Now when we have it a second time, there's how I have two sums. Well, we don't need to some things that would be redundant, possibly repetitious. So I want to change that. So I'll click in the pull down with our where the second some pick on value field settings . And I make that one account and I'll click. OK, and now we have a some an account at the same time so you can move more than one field into the value section. Really, you can have as many as you want it, Teoh, and each one could have their own value for aesthetics. Now let me share with you more beyond some and count an average are cooking that pull them . Where's his count? And I'm picking the value field setting screen. Good. Now, if you notice where my mouse is on the first tab of the value field setting screen, you get things like some count an average. I'll pick on some again Now. Now I'm on the second tab of the value field setting screen and now I'll click on the podium and that we have even more calculations available. So we have percent of column total percent of road total a whole lot of different ones in there, so they could just some more possibilities. So this time a pecan percent of column total. So in the value field setting screen, if you pick on the first tab, you have some count, average and so on. And if you pick on the second tab and then pick on this, pull down, then you have a lot where calculations available, so show percent of column total and are clicking OK, and now we even have percent in our pivot table, as we can say so you could move as many fields as you wanted to in the value section, and then each one will have their own value field settings. That's how we could change the calculation. Type on the pivot table 5. Pivot Table Lesson 4 - Adding Levels of Detail: in this lesson. I want to show you how to make multiple levels of detail in your pivot table. In the previous lesson, I should You had to add more than one calculation by adding more than one field into the value section. Actually, I'm gonna pick up that second, someone just going pick it up and drag it back to the fields. And now we just have the first some, as you can see. All right? Now what we're gonna do is you move more than one field into the rose section, or you can move for the one field into the column section, and you could have as many fields as you wanted to in either section. And this is gonna add multiple levels of detail. So, for example, I'll pick up the word commission from the fields and dragged over here into the rose below the office. Now watch what happened. Each office is now broken down into the nurse, and yes, So now we have a new level of detail. So maybe in your case, you needed by state and then by county and then my township, I will move all three of those fields into the road section. Or maybe you, in your case you wanted by manufacturer and then product type and then product name. Again. I would move all three of those fields into the red section or even into the columns section, and you could have as many as you want to. Neither section now the order in which to feels appear. It really does. Matter knows how each office is broken down into the news. Yes, is because I have the office first and then the commission second. So it's going to take a top down. Let's see what happens if we flip this Ah, pick up office and drag it below. There were commission. Now those what happened, All the news are together and then you get you off. The yeses are together, so the order and wish those fields appear. It really does matter. It's going to take a top down, so I'll pick up commission and drag it down below the word office, but still state in the rose, and now it's flipped again. Now the offices are of top and then to break it down into the nos and yeses. Now let me show you some ashes that you have when you have more than one field. When you pick your pivot table, you get a couple of extra menus up here, you get, analyze, and you get designed Now. In previous versions of Excel, this used to be called options. Now it's called analysts put the choices are pretty much the same now from here. I'll pick on the design Minya right there, design, and I'm gonna come way over here and I'll pick on sub totals. And then I'll say, show all sub totals at the bottom of the group. Knows how I could even turn off the sub totals. Or it could say show So some was at the bottom of the group or it is a show Also put us at the top of the group, so I picked in the bottom and see how to get this way better Nurse had. The Blaine total is now below the plane section. So what I did was I put them to design menu and I picked up the word sub totals. And then I said, show all subtitles at the bottom of the group. That's the one I like, but you could try any one of these other ones as well. Now, also, there is how it says grand totals, and you can turn those owner off as well. So my point there is when you move more than one field into the rose section, or more than one field into the column section, that's going to give your multiple layers of detail, and it's going to take him in the top down order, and you could have as many white as you wanted to. Now I'm gonna remove the commission, field a pickup commission and drag it back to the fields. And now it's back to having just, you know, just a single rose. But that is how we could add more than one level of detail onto our pivot table. You move more than one field into the red section, where you can move from with one field into the column section 6. Pivot table lesson 5 - Creating a Monthly, Yearly, Quarterly, or Daily Report: in this lesson. I want to show you how to change your pivot table into a monthly, quarterly yearly or even daily report. So notice over here we have the office in the road section and we have the airline in the column section. Well, any field could be in the road section and the other field could be in a column section, and we saw how in a previous says and how you can have multiple fields in those different sessions. Well, here's what We're going to go. We're gonna pick up the airline field from the columns and drag it back to the fields. Now, if you notice now, it's just by office, like we had way on less than one. Well, then we're gonna move something into the columns section, and we're gonna move a deep field. So here I have a flight date, which is a deed field, and I'll pick it up and drag it over here into the columns section. Now knows what happened in this case. It made it by month or, um, aided by year. So let's see how we can then do it by month or quarter or day or year So the most important step right there was that removed the date field into the columns section. Now I'm gonna go ahead and right click on the the year or sometimes there's a month. There are. Sometimes there's the individual date. You would right click on that. And then the important choice is the word group, right? So So I pick on group. Now. I like this screen a lot because we can put a date range in there So we can say, you know, if we put a date rigid, it would limit their the records to only those that are between those dates. And then you can pick more than one here. So if this were a time field, I can summarize it by second, minute or hour. But since it's a date field, I'll pick on months and I'll click on OK, and this Now it's broken down by the muff, so watch how we did it again. We're gonna you move a deep field into the columns section over there, then you right click on either the day or the month or the year I'm going to right click in the month again and I pick on the word group. Now, in this window, you could do a date range right there, or you can pick more than one of these. You can pick one or more. So I pick on months and year at the same time, month and year clicking OK and notice. Now we even have the year number in there as well. When I have the year number, then I let to even get the sub total for each year. So all right, click on 2013 and I pick on sub total years. And now we even have a sub total for each year as well. So this is such a powerful future. You move a date field into the column section. Now you either right click on the on the individual date or in the month theme or in the your name. So I'll right click on Jan and I pick up. There were a group You can put a date region here, or you can, ah, pick more than one of these pick on month and year Now, at this point, I'm going to right click on 2014 and I'll pick on sub total years and now we even have a sub total for each year as well. I just want to say one thing here. When you're ready, click in that deed or on that month. If you pick on the world group and you get a message, then that means that it's not seeing one of the items in the other less in the original data as a deep, your data has to be fed a consistent and has to see them all as dates. And that's really how we could make a report into a monthly quarterly yearly, or even a daily report in your pivot table. 7. Pivot Table lesson 6 - Sorting and Filtering the Pivot Table: in this lesson, we'll talk about sorting and filtering the pivot table. So here we have a nice pivot table. You watch the previous s and to see how we got here. Now, if you follow my mouse than those how it's sorted by column a alphabetically by the office name. So let's say I want to see who had the best total in January. I'm gonna click on one number on the January column. Doesn't matter which one now. Your source could still be found under the data menu, so I'll come up here and pick on data and then those over here it says eight dizzy or Z to a the eight disease where we consort a sending and the Zita is where we could sort descending. So I want the higher totals up top. So I'll pick in the Z today right there. And notice now how the highest numbers for January are up top going down from there. So let's see who had the best total for April. A pick on one number on the April column. I pick on Z today on the data Minya and that we could see how Adina had the best total for April. Going down from there so we can sort on any column just is easily. Now let me show you how we consort across. So I'm gonna pick on one number on the Minneapolis row and then from here, I'll pick on the word sort and look what it says over here, left to right. So a pick worse is left to right, which means it's going to sort across. So it turns out that Minneapolis had their best must with February and their second best month with March and then January. So you pick a number, and if you pick on the eight dizzy or the Zito, that's going to sort that column up and down. However, if you picked on the words sore, then you pick on the world left to right, then that will suit that row going across Now the other way to soar is we can right click on a number and then we can pick up the words sort there and you get the same kind of choices. Now this talk about a filter, so I'm gonna click in the pulled down over here. Where's his role? Labels and column A. Now By the way, That gives you another way, this sort right over there. But I'm gonna uncheck it worse is select all. Then you can pick as many as you want it toe and are clicking. OK? And that's how it only showed the roads that you select it on that score bit filter, and it's gonna just the sub totals automatically as well. Based on what? Your chest watch again. Clicking the pull down. Where's his role? Labels and column? A. Then you can either pick and choose them, or you can pick on select all. So pick on slept all and are quicker. Okay? And now everything is back again. Now you can also do the same thing on the column. Labels are picking the pulling wears his column labels, and then we can ship, pick and choose those as well. So the normal still assorted you used to is built right and they could pick a number. You can pick up the data menu, and if you pick the eighties ear, there's either eight of that that will start that column upper dam, and it's been picking the word sore. Then we could sort left to right which was just going to sort that row going across, and the normal filter that you're used to is building as well. I can click in the poll numbers, his rare labels that I can pick and choose the Rose where I pick pick on the poor and wears his column labels. Then I can pick and choose the columns, so that is how we consort and filter are pivot table. 8. Pivot Table Lesson 7 - Adding a Chart to the Pivot Table: in this lesson. I want to show you how to add a chart to your pivot table, so we'll click on one of the numbers in the pivot table, and when you click on one of the numbers, you get two extra menus up here you get, analyze and you get designed and Excel 2010. Instead of the word allies there, it will say the word options, but the choices will be the same pick of the word analyze and those over here it says Pivot , trying right there. So pick on Pivot Sharp and then you have all your chart types. So, for example, I'll pick on a column chart type and I picked in the 1st 1 and very quickly we have a chart that comes from the pivot table. So it's called a pivot. Chart has features of the chart, and it has features of the pivoted about the same time. For example, if I click on this, Polar wears his office right on the chart, I can pick and choose the offices right from the chart. So that's what the filter except this building to the chart or I can come ever here and pick on the podium, wears his flight date, and I can pick and choose the months right from the chart. So it works a lot like a pivot table, and it works like a chart, so it's called a pivot chart. If you change the pivot chart, the pivot table will change. And if I change the pivot table, that chart will change their tied to each other. If you click on the chart, then you get all the normal menus of there that you would get for your truck like design and format. So, for example, I'll pick on the design. Then you Now come way over here and I'll say, Add chart element in a pick. And that's where we what we all call the Try the tri options. A long time ago, I pick on chart title and I picked above chart. Now you can see my chart does hit chart title, and I'll type in all typing right over that. I'll type in department Budget 2016 and now we have a nice chart title. So when you pick on the chart, you get the design menu and you get the format menu from what you could do further formatting on your chart. And I can also do the filter from the chart over here. A swell. And if you change the pivot table, the chart will change. And if you change the chart, the pivot table change. So was I really do this to meet the chart? Was I clicked on a number I picked from the pivot table, and I picked him yet the analyze menu and I said, Pivot, chart, and then you have your chart types. You can pick one of this, of course, and now we have a pivot, a chart that comes from a pivot table, so it's going to call a pivot chart. 9. Pivot Table lesson 8 - Adding Slicers and Timelines: in this lesson. I want to show you how to add some great slicers in timelines onto your pivot table had even more filters. So the slicers and the timelines are visual type of filters. Now, the slicer started in Excel 2010 and then they added something new and accept 2013. That's called a timeline. So the timeline will not be available in Excel 2010. I'm gonna go, then click on one of the numbers and the pivot table. Now I want to keep the chart here that we made in the previous lesson because I want to show that the slicer in the time that will change the chart as well I'll pick on one number on the pivot table, and then I'll pick on the Allies menu of top. And, alas, and over here also insert slicer. Now you're, um you'll see your fields here. You can choose as many as you want it to. The more feels that you choose the more combination if they will be able to dio. So I'll pick on destination tickets and commission. Now I could have chosen more than that, but this would make the point that I'm trying to make. So I'll click on. OK, now these air slicer windows. I want to move these over here. You can resize them. You can move the windows, move these over here. Good. But besides, that one for a second. Good mover. Right over here. And then I'll move this one over here. Good. Now pick on Chicago and knows how that cheese the pivot table that changed the chart. Of course, I probably Detroit over here somewhere. But you get the picture. Um, so it's only now going to show the ones whose destination is Chicago. So it's like a filter, except it's more visual. And by the way, the pivot table can only filter the fields that are on the pivot table with the slicer that you can add all these different combinations to get really any combination do that you wanted to. So when the ones from Chicago the head two tickets are picking to there, that changed the pivot table in the chart and then I pick on yes, over here, and that changed everything again. This is really amazing to may I could get the exact records that were looking for it because of the slicers. Now, to get everything back again, you'll pick on the funnel on the corner of the slicer windows. So I pick on this funnel and this one and this one. And now everything is back as we can sit. Now, the next person comes along and they want to shoot Chicago. But they also want to see some other ones. So I'm gonna hold on my control key. I just said that my control key on my keyboard. I'll pick on Dallas Duluth, Fargo, you can pick as many as you want it to. Now, when I lift my finger, it will show the records. Who has all of those different destinations? Then I'll pick on to ever hear and our pick on hold that control again. I pick on four and five and then I pick on yes, every year. Those are the charts changing the pivot tables changing. So when we get all of this working together, this is called a dashboard. So the slicer windows are a major component of the dashboard. Now I'm gonna get everything back again. So I pick on the sliced the little funnel on the corner of this place or Windows, and now everything is back. Now an Excel 2013. They added something new that's called a timeline, which is a slice of that basis that's based on a deep field so we could do a date range. So from here, I'll pick on the analyze menu and I'll pick on insert timeline Now the time that is based on a date field. So I pick on flight date and I'll click. OK, this is a time line, so I'm gonna move that right over here and watch how it works. I'll pick up the White Square and I'll drag it so that I can see January of 2014 Meritus and I'll pick on the blue space below January of 2014 right now and those how the records changed again because now so many genera of 2014 and that changed the chart. Now I'm gonna drive this over toe April. Then it will show everything for January April A pick in Duluth. I'll pick on four over here. Five. I mean, this is really amazing to May. I could get the exact Rikers I'm looking for with the slicer and the timeline. So imagine if we had 45 sites the windows open, or even more than you can get any combination of data that you wanted to that you combine that with the filters that are already there. And truly you get any combination of their that you wanted to with the slices and with the time line. You get that working with the chart, get all this working together, and this is what Microsoft is calling a dashboard. Now you can keep those there for the next time. It's saving your workbook, and that's what many people did. I set those up and they save them, or we can also delete the slicer windows. So I'm gonna pick in the funnels on the corner of your slicer window and I'll get everything back again, as you can say, so we can keep those there If you want to leave them, I'll pick on this slicer window, and I hit my delete key on my keyboard, picking your destination and to be fat, and I picked on the reflected and delete that with my leaky. Now I'm just gonna move this window to decide for a second. I'll close that window and then I pick up their tickets and to leave that. Now, if I want to get my feel this back again, I'm going to right click on one of the numbers and I pick on Schofield list. Good. Now let's see how we got the slicer in the timeline. When there's open again, you pick one of your numbers in the pivot table to pick on the analyze manure up top. And then here we have insert slicer that would be there if you have Excel 2010 or 13 or 16 then once I do that can pick and choose as many fields as they wanted. Teoh. The more that you choose, the more combination of that you'll be able to dio. And then I can. Also, if you have Excel 2013 or 16 you can pick in the timeline, which is based on a date field so you could do date ranges as well. So there's a powerful new additions to Excel Call the slicer and the timeline, By the way, I'm also going to get rid of the chart now as well. So I pick on the chart hit Delete 10. Pivot Table lesson 9 - Creating many Summary Sheets: in this lesson. I want to show you how to really, really get a powerful result from the pivot table. And we're gonna make multiple sheets with different reports. Now, first of all, notice how I just scrolled up to the top so I could see Row one. And if you look at Roe Ah, cell a one and B one notice nothing is there right now. So what we're gonna do is we're gonna move something into the filter section. So it's just another way to filter out your pivot table, but more of the higher level. So I'll pick up airline from the fields and dried the airline over here into the filters right there Now knows what happened. And so 81 it says the word airline. And then in Selby, one says the word all. So if you click on the pull down that I can pick on American and then clicking, OK, and now the numbers cheesed again because now it's just American only. So it's just another way to filter out your pivot table more the higher level so I can click on that, pull down and pick on southwest and click OK and the numbers will change again. Now also, I can click on that Pull down and I can pick on select multiple items so I can pick more than one so you can get different combinations. So I pick it off now. Right now, I have to click on that, pull down and then pick American and then print that and then Delta and imprint that I didn't individually. Now let me show you how to get all the sheets. So to do this when you have to have something in the filter section over there, which we do if the airline field, then I'll come up here and I'll pick on the analyze menu. Now come way over here and I'll click in the pulled in our wears his options. Then I'll pick on show report, filter pages. Then I'll click on. OK, now watch what happened at the bottom. Now I have a different sheet for each different airline. I mean, that is so incredible which has happened. So you move something to the airline to the filter section right there moved airline. Then I picked on the analyze menu I picked in a poll. Them wears his options and I said show report, filter pages. Now if I click on OK, though, she still be there a second time. And now look now we have the sheets of second time, and that is so amazing. That's how we can really have ah, the different sheets that showed different reports in the pivot table.