EZ-Pivot for Excel

Creates PivotTables and PivotCharts in seconds
Create PivotTables and PivotCharts in seconds. Unlike Excel, EZ-Pivot works with subtotaled and filtered data.

Easily modify and re-use the pre-defined colors, fonts and alignments of pivot table regions. EZ-Pivot automatically formats Excel's unformatted drill worksheets.

Specifiy the field order, visible columns, sorts, and column totals for drill worksheets. Excel Styles are automatically created and applied to every field in Drill worksheets.

Export snapshots of PivotTables without the source data. Export all or only visible columns in drill worksheets.

Walk PivotTable page and row fields one value at a time with a single click. Intuitive toolbars and menus make it easy to access dozens of features.

The 30-minute Getting Started Tour begins with the creation of a PivotTable, and walks through nearly every EZ-Pivot feature. Version 5 adds the ability to convert PivotTable formatting to black and white with a single click.

Main features of EZ Pivot for Excel:

NEW! (12/07) Create a re-usable default format for the separate and embedded PivotCharts!

NEW! (11/30) Convert EZ-Charts to PivotTables and PivotCharts and Drill into the chart data!

Unlike Excel, create PivotTables from subtotaled and filtered data

Unlike Excel, PivotTables and PivotCharts are formatted

Unlike Excel, Drill worksheets are customizable and formatted

Unlike Excel, PivotTables, PivotCharts and Drill worksheets are printer-ready

EZ-Pivot never modifies the original data used to create PivotTables and PivotCharts

PivotTable data is automatically maintained in a worksheet separate from the original data

Refresh the separate PivotTable data worksheet from the original Excel data at any time

EZ-Pivot assigns the separate automatically maintained worksheet as the PivotTable data source

Convert Excel created PivotTables to EZ-Pivot formatted PivotTables in two clicks

EZ-Pivot optimally auto-sizes PivotTable columns to reduce the overall PivotTable width

Eighteen user modifiable region formats for color, font and alignment are automatically applied

Preferences for the font, alignment and color of PivotTable regions is intuitively maintained

Band the data area of the PivotTable for easier viewing when there are multiple data fields

Refresh the print and region formatting of a PivotTable with one mouse click

Export PivotTable and PivotChart snapshots without the underlying PivotTable source data

Create printer-ready embedded and separate PivotCharts in two clicks

A single click walks the individual values of the first Page field or the first Row field

Drill worksheets for EZ-Pivot created PivotTables are automatically formatted

User maintainable Excel Styles are automatically created for and assigned to all Drill fields

For each PivotTable reorder, hide, sort and total the automatically styled Drill worksheet fields

Export all Drill columns or only visible Drill columns to a new printer-ready workbook

Works with Microsoft Excel 2000 / XP / 2003 on Microsoft® Windows® 2000 / XP / 2003 Server

Use EZ-Calc to create eight useful types of calculated fields including Accounting-Type "Date Aging" and "Re-formatted Date" fields

All products install in seconds, and completely uninstall as separate products

EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc are included in the EZ-Deluxe product

EZ-Deluxe is the economical way to purchase all four EZ products

Upgrade to EZ-Deluxe from any one EZ product without a price penalty

All products self-register upon purchase if software is currently installed or is subsequently installed

All products include life-time free updates for product enhancements and bug fixes


Limitations of EZ Pivot for Excel:

15 days trial

Free Download ( Evaluation | 2.8 MB )