From the course: Excel: PivotTables for Beginners

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Solution: Build a sales summary PivotTable

Solution: Build a sales summary PivotTable

From the course: Excel: PivotTables for Beginners

Start my 1-month free trial Buy for my team

Solution: Build a sales summary PivotTable

“

So this is the solution to challenge 02. You can see that my dataset is now in a table. If we jump up to the table design ribbon, you can see it says sales data. We then on the dashboard tab have three different PivotTables all formatted with a slicer. When we click on the different slicer options, you can see that those pivot tables below are updating. So let's walk through this from the beginning. Now, to make this a bit easier to see, I'm going to have my instructions on the right hand side of the screen and the spreadsheet that I'm working in on the left. So the first thing to do here is format the data on the sales worksheet as an Excel table. So let's press control T. Yes, my table has headers. Let's click on OK. And remember, if you don't like the style, you can change it to something else. And I'm going to give this table a name. We're going to call it sales data and press enter. So now I need to create my three pivot tables and the first one is units sold by Sales Manager. So…

Contents