Pivot Power Premium Help Topics

This page shows how to use the main features of the Contextures Pivot Power Premium (PPP) 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.

Pivot Power Premium Add-in Overview

The Contextures Pivot Power Premium (PPP) 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 .

PPP Tab on Excel Ribbon

On the PPP tab, the pivot table tools are divided into the following categories (Groups). Click a category name below, to go to that section of the PPP Help.

• Preferences
• Number Formatting
• Data Fields
• Pivot Fields and Items
• Pivot Table
• Filters and Cache
• Workbook
• Resources

Video: PPP Quick Tour

Watch this short video to get a quick tour of the PPP tab in Excel, and see some of the key commands that will help you save time when working with pivot tables.

To follow along with the video, download the Food Sales Sample Workbook. The zipped file is in xlsx format, and does not contain any macros.

MORE VIDEOS: To watch all of the PPP videos, go to the PPP Help Videos page.

PPP Command List

Download an Excel file that contains a list of all the commands in the PPP add-in. (Updated 12-Jan-2019)

• The list shows the command names and their location on the PPP tab.
• The OLAP column shows if a command is available for use with OLAP-based pivot tables, such as those created with the Data Model option.

User Guide and Screen Tips

The Pivot Power Premium kit includes a user guide which explains how the add-in works, and how to install it.

The PPP tab on the Excel Ribbon also has screen tips to guide you as you work with the add-in. Point to a command, to see its information in a popup screen tip.

Frequently Asked Questions (FAQs)

The FAQs page contains frequently asked questions and answers about the PPPP add-in.

Click here to visit the PPP FAQs page.

___________