Pragmatic Excel - Advanced Pivot Tables

Who Would Be Interested in This Course:

Practitioners who would like to learn how to manipulate their pivot table data faster and more efficiently.

Topics Covered:

Creating dynamic and interactive graphs with Excel’s PivotChart feature.

 ·     Discovering the Recommended PivotTables feature.

 ·     Launching macros that clean up pivot tables with a single mouse click.

 ·     Learning the nuances associated with subtotaling data within a pivot table.

 ·     Learning how the Table feature can vastly improve the integrity of pivot tables in Excel.

 ·     Incorporating calculations within or alongside pivot tables.

 ·     Learning how to expand and collapse pivot table elements, thereby avoiding information overload.

 ·     Gaining control of unruly pivot table data by creating a macro that can automatically transform all count fields into sums and apply number formatting in one fell swoop.

·     Mitigating the side effects of converting a table back to a normal range of cells.

·     Compiling unwieldy data into the format required for pivot table analysis quickly and easily.

·     Staving off frustration by filling blank cells within any columns that contain numbers with zeros before you create pivot tables.

Learning Objectives:

•      Recall how to clean up your pivot tables with a mouse click.

•      Recognize when and why to apply the Slicer feature.

•      Identify pivot table data in new ways by grouping based on dates or custom arrangements that you define.

Level:

Intermediate

Format:

On-Demand Webcast

Instructional Method:

Self-Study

Program Prerequisites:

Previous Experience with Excel Pivot Tables

Advance Preparation:

None