From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

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

Sorting options

Sorting options - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

Sorting options

“

- [Instructor] Alright, welcome to section four, sorting, filtering, and grouping. Now up to this point, we've been really sticking with the basics. We learned how to bring in and insert pivot tables, manipulate views, deal with source data, and use formatting tools to customize the look and feel, but realistically, we're not even scratching the surface in terms of how powerful these pivot tables can be. And this section is designed to start to show you some of those capabilities, specifically in terms of sorting, filtering, and grouping. And these are the tools that will start to allow you to slice and dice and explore and really analyze your data in much more meaningful ways. So when you're looking at a pivot for any of your column headers, you should see this little drop-down menu which activates the sorting and filtering options. You can also right click on any value within the column to get to the same menu. And in here, you'll see a combination of sorting options like A to Z, Z…

Contents