Contextures

Pivot Power Premium Videos

This page contains all of the Pivot Power Premium Help videos, so that you can watch them without going to the individual Help pages. To follow along with the videos, download the Food Sales Sample Workbook.

Back to Help Page


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.

Preferences

Watch this video for a quick tour of the Preferences commands on the PPP tab in Excel. It shows how to:

  • Store your favourite pivot table settings
  • Get settings from the selected pivot table
  • Apply Setting 1 to ALL or Selected pivot table
  • See a list of stored settings
  • Export your settings, and import to a new version of PPP

Number Formatting

Watch this video for a quick tour of the Number Formatting commands on the PPP tab in Excel. It shows how to:

  • Change number format for one or more selected value fields
  • Change number format for ALL the value fields
  • Change all value field to SUM and Currency format at once
  • Create and apply a custom number format

Data Fields

Watch this video for a quick tour of the Data Fields commands on the PPP tab in Excel. Also see the "Show SEL As" video below.

Show SEL As

This video shows how to use the Show SEL As commands

Pivot Fields and Items

Watch this video for a quick tour of the Pivot Fields and Items commands on the PPP tab in Excel.

Pivot Table Commands

Watch this video for a quick tour of the Workbook commands on the PPP tab in Excel.

NOTE: the Pivot Table Builder commands are show in separate videos, below.

Pivot Table Builder

PT Builder Field List - From Pivot

This video shows the steps for creating a field list from an existing pivot table. Then, the field list settings are changed, and the original pivot table is updated, based on the new settings.

PT Builder Field List - From Table

This video shows the steps for creating a calculated field in a PT Builder field list. Then, update a pivot table to add or update the calculated field.

  • 0:00 Build Field List from Source Data
  • 1:38 Create a New Pivot Table
  • 3:03 Naming Sheets and Field Lists

PT Builder Field List - Calculated Field

This video shows the steps for creating a field list from a named Excel table. Then, the field list settings are changed, and a new pivot table is created, based on the field list settings.

  • 0:00 Create a Simple Calculate Field
  • 1:45 Update the Pivot Table
  • 2:31 Revise a Calculate Field Formula

Number Formatting Video

Watch this video for a quick tour of the Number Formatting commands on the PPP tab in Excel. It shows how to:

  • Change number format for one or more selected value fields
  • Change number format for ALL the value fields
  • Change all value field to SUM and Currency format at once
  • Create and apply a custom number format

Filters and Cache

Watch this video for a quick tour of the Filters and Cache commands on the PPP tab in Excel. It shows how to:

  • Clear all pivot table filters
  • Sort items in Report Filters
  • Allow Multiple Filters per Field
  • List all Pivot Caches in Workbook
  • Change Pivot Caches (normal pivot tables only)

Workbook Commands

Watch this video for a quick tour of the Workbook commands on the PPP tab in Excel.

Download the Workbooks

  1. To follow along with the videos, download the Food Sales Sample Workbook. The zipped file is in xlsx format, and does not contain any macros.
  2. Download an Excel file that contains a list of all the commands in the PPP add-in. (Updated 12-Jan-2019)

 

 

 

 

Last updated: January 16, 2019 2:58 PM