EZ-Pivot for Excel 5.2

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 Excels 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.
Here are some key 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
Version restrictions:
- 15 days trial