PivotPower Premium Excel Add-in

Do you use the free PivotPower add-in that's available on my Contextures website? I created PivotPower to make my own work easier to do, and shared it on my website to help you with your pivot table tasks.

It automates some of the features that aren't built in to an Excel pivot table, and makes some of the buried Excel pivot table features easier to access. For example, there is a command that changes all the data fields to SUM, which is handy when Excel defaults to COUNT.

pivotpowersum01

PivotPower Premium Now Available

The free version is still available, and I've created a premium version, with more features.

You can store your pivot table default settings in the add-in, and then apply those settings to any pivot table, and the active sheet and workbook.

There's a list of the new features below, and one of my favourites is Currency SUM. It changes the selected field to the SUM function, formatted as currency.

pivotpowerpremcurrencysum

Watch the PivotPower Premium Demo Video

To see a few of the new features in PivotPower Premium, you can watch this short video.

What's New in PivotPower Premium?

The following features have been added in PivotPower Premium  -- they are not in the free PivotPower add-in.

User Guide

  • Details on installing the add-in, and description of the commands

Formatting

  • Column Width Autofit On
  • Column Width Autofit Off
  • Set Defaults
  • Apply Defaults

Number Formatting

  • Currency
  • Number - 2 decimals
  • Number - 0 decimals
  • Currency SUM
  • Number - 0 decimals COUNT

Pivot Items

  • Hide All (Blank) Items
  • Show All (Blank) Items

Pivot Fields

  • Include New Items
  • Clear All Fields
  • Field List A-Z
  • Field List Source Order

Grand Totals

  • Show All Totals and Subtotals
  • Hide All Totals and Subtotals

Cache

  • Create New Cache

Password

  • Until September 30th, at 11:59 PM Eastern time, the password to the VBA project is included in the purchase. You'll be able to rearrange the menu, add your own macros, and see how the existing code works.
  • Starting October 1st, 2012, the password will be available as a separate purchase, for an additional $10 US, or buy the add-in and password together, for $18 total.
    • Note
      • No programming skills are need to use the PivotPower Premium add-in
      • You must be familiar with VBA in order to modify the code in this add-in.
      • Purchase does not include programming help for customizing the PivotPower Premium add-in.

Purchase the PivotPower Premium Add-in

To make your pivot table tasks easier, you can purchase the PivotPower Premium add-in, by clicking the Buy Now button below.

The price is $10 US, and you will receive instructions for downloading a zipped file that contains the Excel add-in, the User Guide, and your password (if purchased by 11:59 PM, Sept. 30, 2012).

If purchased on Oct. 1st, or later, the VBA password will be sold separately, for a $10 US fee.

  • Note: You must be familiar with VBA in order to modify the code in this add-in. Purchase does not include programming help for customizing the PivotPower Premium add-in.

If you previously purchased the password for the free PivotPower add-in, you can email me to request a free copy of PivotPower Premium.

Buy now -- $10

_______________

8 comments to PivotPower Premium Excel Add-in

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>