Contextures

Pivot Power Premium Help

This page shows how to use the main features of the Contextures Pivot Power Premium add-in. If you have a question that is not answered here, send an email to
Debra Dalgleish -- ddalgleish @ contextures.com

NOTE: This page is under construction -- more information will be added soon.

Contextures Pivot Power Premium Add-in Overview

The Contextures Pivot Power Premium add-in saves you time and effort, when working with Excel pivot tables. There are installation instructions in the User Guide that is packaged with the add-in.

After you install the add-in, a new tab will appear on the Excel Ribbon -- PPP. You can point to any command on the PPP tab, to see a popup description of that command .

On the PPP tab, the pivot table tools are divided into the following categories. Click a category name, to go to that section on this Help page.

Preferences

Number Formatting

Data Fields

Pivot Fields and Items

Pivot Table

Filters and Cache

Workbook

Resources

Preferences

Store and apply up to 5 sets of pivot table settings.

Number Formatting

Apply number formatting to selected fields, or to all fields in the pivot table .

Data Fields

Apply summary functions to selected fields, or to all fields in the pivot table. Apply Show Values As setting to selected value fields.

Pivot Fields and Items

Change settings for pivot fields and pivot items, clear old items from the pivot table.

Pivot Table

Change pivot table settings, create info lists, build or update pivot tables from field lists.

Filters and Cache

Clear filters, change filter settings, change cache, list cache information

Workbook

Change the appearance of the workbook and worksheets.

Resources

Click these commands to visit the Contextures website, send an email, or return to this Help Page for this product.

Video: Pivot Power Premium Demo

To see a few key features of the Pivot Power Premium add-in, please watch this short video demonstration.

The Pivot Power Premium creates a Ribbon tab, and is for Excel 2007, and later versions.
NOTE: Windows only
-- does not work with Excel for Macintosh.

Many More Features

In addition to the features described above, there are many more timesaving commands in the Pivot Power Premium add-in. For example:

  • Go to the Source data
  • List details for the selected pivot table
  • Remove all the selected Value Fields
  • Change all the Value headings, to remove the "Sum of" or "Count of"

User Guide

The Pivot Power Premium kit includes a user guide which explains how the add-in works, and how to install it. The Ribbon also has screen tips to guide you as you work with the add-in.

 

Last updated: June 21, 2017 4:37 PM