Viewers: in countries Watching now:
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
You can limit the data that appears in a PivotTable by applying a filter. But there would be little sense in applying a filter if you weren't able to remove it later. In Excel you can remove filters from individual fields, remove all filters at the same time, and reapply filters you just got rid of. So for example in this PivotTable here, I have filters applied to the Year and Month fields. So let's say that I want to clear the filter from the Year field. To do that I can go into the PivotTable Field List, click the downward- pointing black triangle at the right edge of the Year field header and then click Clear Filter From Year.
When I do, Excel removes the filter. Now let's say that I want to bring the filter back. Well I could either recreate the filter or I could use the Undo feature. To do that I'll go up to the Quick Access Toolbar and click the Undo button and when I do Excel reapplies the filter. Now let's say that you have filters in many fields of your PivotTable and you want to remove them all at one time. To do that, click any cell in the on the PivotTable and then on the Options contextual tab click the Clear button and then click Clear Filters.
Doing so removes every active filter in the PivotTable. When you're done with the filter, simply remove it and continue with the rest of your work. You can always re-create the filter or if you haven't many changes you don't want to lose you can also use Ctrl+Z or the Undo button to bring the filter back.
There are currently no FAQs about Excel 2010: Pivot Tables in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.