From the course: Miss Excel’s Top Productivity Hacks

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

PivotTable grouping tool: The summarizing savant

PivotTable grouping tool: The summarizing savant - Microsoft Excel Tutorial

From the course: Miss Excel’s Top Productivity Hacks

Start my 1-month free trial Buy for my team

PivotTable grouping tool: The summarizing savant

“

- Have you ever noticed that data keeps getting bigger and bigger and bigger? Well, big data is here to stay and we need to learn how to work with it in Excel. Let's pivot, table. Let's take a look at this powerful pivot table tool. And in order to demonstrate this, we have some data over on the left with our offices, order dates and our sales amounts. And from this I've gone in and created a pivot table to the right for us to work with. Now, something to notice about this pivot table is that we do have all of our dates there as our column headings which is making our table super long. Let's say that we actually want to summarize this by quarter instead of by date here, up at the top. What we can do is leverage the pivot table grouping tool. In order to access this tool, all you need to do is click on your pivot table, and here I'm going to navigate over to one of the dates that we want to go in and update. And when…

Contents