Search
Contextures Sites
| |||
|
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 21, 2013 12:34 AM
Search Contextures Sites
PivotPower Premium Add-in
The PivotPower Premium add-in helps you by automating many of the features that aren't built in to an Excel pivot table, and by making some of the buried Excel pivot table features easier to access.
PivotPower Premium Add-in Overview
The PivotPower Premium add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:
- save and apply default pivot table settings
- clear old items from an Excel pivot table
- change all the data fields from the Count function to the Sum function.
This version of the PivotPower Premium creates a Ribbon tab, and is for Excel 2007, and later versions. There is also an Excel 2003 version.
Video: PivotPower Premium Demo
To see a few key features of the PivotPower Premium add-in, please watch this short video demonstration.
Save Your Default Settings
With the PivotPower Premium add-in, you can save your favourite pivot table and worksheet settings, and then apply them to any pivot table. From the Formatting menu, select Set Defaults, and check the settings that you prefer.
Then, select a cell in any pivot table, and click the Apply Defaults button, to quickly apply your default settings to that pivot table, and to the active worksheet and workbook.
Note: Some settings are only available in Excel 2010 and later versions.
Quickly Change Functions and Formatting
With the PivotPower Premium add-in, you can quickly change all the values in a pivot table from COUNT to SUM, and apply currency format or number format with zero decimals.
Hide Tabs and Gridlines
With the PivotPower Premium add-in, you can turn off scroll bars, and hide sheet tabs, gridlines and row and column headers -- with a single click. Or turn them back on with another click.
Many More Features
In addition to the features described above, there are many more timesaving commands in the PivotPower Premium add-in. You can see all the ribbon commands in the screen shot below.
- Formatting: change captions, and AutoFit setting
- Default Settings: Save default settings, and apply to any pivot table
- Number Formatting: Click to set Currency or Number format
- Pivot Items: Clear old items, show/hide items with no data, repeat labels every row
- Data Fields: Change all data fields to SUM, or another summary function
- Totals: Hide/Show Grand Totals, Hide/Show Subtotals
- Pivot Fields: Clear Fields, Include New Items, Sort field list
- Filters: Clear all filters, clear report filters, allow multiple filters
- Restrict Features:Restrict/Allow Features, Hide/Show Tabs, Scrollbars, Headings, Gridlines
- Printing: Print PivotTable, Show/Hide Page Breaks and Zero Values
- Pivot Cache: Create New Cache, Cache Count, Last Refresh, Memory Used
- Information: Source Data, Active Cell PivotTable, List Pivot Tables
- Select: Pivot Table, Show/Hide Selection Arrows
User Guide
The PivotPower 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.
Buy the PivotPower Premium Add-in
Click the Buy Now button below, to purchase the PivotPower Premium add-in. You will go to a PayPal page, where you can pay with a credit card, or through your PayPal account.
$30 US
Approximately 30 minutes after you pay for the PivotPower Premium add-in, you will get a link to download a zipped file that contains the PivotPower add-in and the user guide. If you have not received the link within 30 minutes, please contact me at ddalgleish@contextures.com
There are installation instructions in the User Guide.
How the Payment Process Works
- You will be taken to a secure PayPal payment site, where you can
- pay by credit card (click the "Don't Have a PayPal Account?" button.
- or pay through your own PayPal account (if you have one).
- After you make the payment, you will be redirected to a secure download page, on the e-junkie website.
- You will also receive an email with a link to the download page.
- Your download will be available for 48 hours, or 5 downloads, whichever comes first.
- If you have any trouble with the download process, please contact me at ddalgleish@contextures.com
Unconditional 30 Day Guarantee
After you purchase the PivotPower Premium add-in, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.
Note
If you have comments or suggestions, please contact ddalgleish@contextures.com
This version of the PivotPower Premium creates a Ribbon tab, and is for Excel 2007, and later versions. There is also an Excel 2003 version.
Contextures Inc., Copyright ©2013
All rights reserved.
