Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME
 

 
NEW!  XL-Subtotal Fixes Excel's Subtotaling Bugs!
The only solution to completely correct Excel Subtotal Bugs in one click!
GET the FREE Forever Subtotaling Bug Fix Now!
  Download the 15-Day full XL-Subtotal trial
and Fix Excel Subtotals FREE forever.  

Fixes Multilevel Subtotals, Nested Subtotals, Subtotals in wrong Position / Column / Order,
Incorrect Subtotal Outlines, Missing / Erroneous Grand Totals in Subtotals Above and Below.


The XL-Subtotal Excel Toolbar
The Subtotal "FIX" Feature on the Excel Ribbon and Excel Toolbar is FREE forever.
After the Trial, purchase for $19.95 to keep using dozens of Subtotaling enhancements.
The Free Excel Subtotal Fix in XL-Subtotal benefits everyone using Excel Subtotals!

See How to Create Excel Charts in Three Clicks from Fixed Subtotaled Data!



Microsoft Excel Add-ins and Microsoft Excel Tools
for both the 32 bit and 64 bit versions of Excel

Use EZ-Split to quickly split Excel Lists and Excel Tables
by selected values creating new identically formatted worksheets.
Splits retain formatting, totals and data to the right and below.
Split data for multiple selected values into one new worksheet.
Includes features for everyday Excel use, like Exporting the
visible rows of any worksheet retaining all formatting and
automatically converting formulas producing #REF errors to value.



The EZ-Split Excel 2007 / Excel 2010 Ribbon
Access the Identical Features from the EZ-Split Toolbar in Excel 2000, XP and 2003.



Our Most Popular Add-in: EZ-Format for Microsoft ® Excel ®

Quickly Format Data Using Excel's Most Popular Features!
Create Reusable Formats for Completely Automatic Formatting!


EZ-Format includes EZ-Split, EZ-Subtotal and EZ-Calc features, and all EZ-Stat features.

Mouse-over Ribbon for Tooltips and Click to
Watch "How-to" Video on Highlighted EZ-Format Feature.

After watching Video on YouTube, click "Back" (or Alt+"Left-Arrow") to return to this page.
Videos cover all versions of Excel.  Video Descriptions and Times are on the New EZ-Format Movie Page.

EZ-Format Menu - No Video EZ-Format Settings Menu - No Video Delete EZ-Format Formatted Worksheet Automatic 'Default' Formatting of New Data Sort and Subtotal Stats Menu - Quick Stats Video Format for Printing and Print Preview - No Video Standard Print Dialog - No Video Maintain Column Totals Turn Subtotals Off and On, and Remove Subtotals Export Visible Rows - No Video Split Sheet Menu - Split Worksheet Video View Excel Subtotal Outline Levels Select Reusable Worksheet Format Save / Delete Reusable Worksheet Formats - No Video Formula Field Menu - Add Formula Field Video EZ-Format's 8 Excel Style Features Create Excel Conditional Format Sort and Subtotal Field Order Rank / Resort Subtotaled Data Set Field Widths and Wrap Data Drag Reference Data to Subtotal Rows Hide Fields and View Hidden Fields Clear Data Filters and Show Non-Hidden Columns Show Data and Subtotals one Filter Value at a Time Select 'Full Stats' Break Field for Walking - No Video Bold and Shade Subtotal Rows View only Break, Subtotaled and Dragged Fields Filter Views Menu and Reapply Simple Data Filter - No Video Set Break Field 1 Subtotal Row Height

Access the Identical Features from the EZ-Format Toolbar in Excel 2000, XP and 2003.

The EZ-Format Excel Toolbar
Click on Ribbon Options for Videos


Coming in May!  Automatically correct all Excel Subtotaling Bugs for FREE!
Delete Grand Total rows and Outline Levels created in error,
and create Subtotals and Subtotal Outlines omitted in error.
Over one dozen additional subtotaling enhancements for only $19.95!

New!  Double-click cells to quickly set and unset
the filter value in Lists, Tables and Subtotaled data.

In filtered subtotaled data, related subtotals and grand totals are
automatically unhidden when subtotals are below the data.
Exposing related subtotals and grand totals is impossible to do manually.

New!  Copy only the visible rows in filtered Lists, Tables and
Subtotaled data to a new worksheet retaining all formatting.

Copied subtotaled data retains the Excel subtotal outlines.

New!  Analyze data using any or all of Excel's 25 mathematical formulas.
Analyze Lists, Tables and Subtotaled data without modifying the data.
Analyze data as a whole or broken down by up to four dynamically
selected break fields.  Selected formula calculations are presented in
an easy to read Excel PivotTable.

New!  Create Custom Excel Formula Fields:
Aged Dates, Reformatted Dates, switch values in one column to negative
based on values in another column, Running Total fields
and Percent of Total fields.

Split Lists and Tables by the unique values in any field
creating multiple new Workbooks in seconds!

Selectively exclude List and Table columns when
splitting Lists and Tables beginning in cell A1.

New!  Retain associated PivotTables and PivotCharts
when splitting data in Excel Lists and Excel Tables.

PivotTables and PivotCharts are automatically updated for
the new source data in all new split workbooks.

New!  Includes 32 bit and 64 bit versions for Excel 2010.

New!  Use EZ-Email to automatically Email Excel
Workbooks to 'Embedded' and 'Linked' Addresses.


EZ-Email Product Page

 

 
Links to Product Pages, Videos, Free Trial Downloads
All Excel Add-ins Install and Completely Uninstall in Seconds.
Add-ins include Free Updates and Enhancements.
 
 

XL-Subtotal Completely Corrects / Fixes Excel Subtotaling Bugs for Free!
Fixes Multilevel Subtotals, Nested Subtotals, Subtotals in the wrong position / column.
Completely fixes Subtotals Below and Subtotals Above in a single click for FREE!

XL-Subtotal

$19.95

FREE
forever
Excel
Subtotal
Bug
Fix
without
Buying!

Fix Excel Bugs in Subtotals Above and Subtotals Below for FREE!
Double click filtered data to set and unset filters and expose appropriate subtotals.
Export the visible rows of filtered data retaining subtotals and outlines.
Switch between subtotals below and above, and temporarily turn subtotals off.
Switch between one outline level per subtotal and one outline level per Break field.
Bold and Shade subtotals for easier viewing.
Drag constant data in any field to the subtotal rows of the lowest break level.
Hide and unhilde fields that are not Break, Dragged or Subtotaled fields.
Save subtotal settings and reuse saved settings on different data for the same fields.
View and export subtotal data at any single outline level hiding all empty data columns.
Export break field and subtotaled field data at any level to quickly create Charts.
Split Fixed Subtotaled data by values in any field with the separate EZ-Split add-in.
Supports the 32 bit and 64 bit versions of Excel 2010 and Excel 2013.
Try

EZ-Format is the only Excel Add-in to Completely Automate Worksheet Formatting.
Go from raw data to an identically-formatted, feature-rich and printer-ready Excel worksheet in seconds.

EZ-Format

$49.95

Best
Value!

Quickly format data utilizing Excel's time-consuming major formatting features.
Create reusable worksheet formats for identically formatting new data in seconds.
Re-use formats to automatically and identically format data in a fraction of the time.
Use conditional formatting, sorting, better subtotaling & enhanced data analysis.
Filtered data exposes subtotal rows.  Export visible data and subtotals in a single click.
Split Data & Totals to New Worksheets / Workbooks.  Automatically utilize Excel Styles.
Mix subtotal types (sum count ... standard formulas) on bolded shaded subtotal rows.
Automatically recreate all User-Defined and 5 EZ-Format Custom Excel Formula Fields.
Includes many EZ-Split, EZ-Subtotal and EZ-Calc features, and all EZ-Stat features.
Visit the New EZ-Format Movie Page for over two dozen new "How-to" Videos.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
Try

Add-ins are Windows Vista, Windows 7 and Office 2007/2010 Compatible.
Install for Excel 2000, XP, 2003, 2007 and 2010 on Windows 2000, XP, Vista and Windows 7.

EZ-Split

$39.95
Split tens-of-thousands of worksheet records to individual workbooks in seconds!
Split / Separate Excel Worksheet Data to new worksheets for selected values in a field.
New Split worksheets can be in one new workbook or multiple new workbooks.
Copy all data for multiple selected values in any field to one new combined worksheet.
Split All or Selected Sheets / Tabs in one workbook to new individual Workbooks.
Spread a Numeric Field to new Columns for each unique value in a non-numeric field.
Split combined Names into First, Middle, Last Names.  Fill Blank Cells from Cells Above.
New! Selectively exclude columns from split worksheets / workbooks.
New! Email Workbooks to Embedded Addresses or Addresses by Field Value.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
EZ-Split's three major Splitting functions are included free with EZ-Format.
Try
EZ-Email

Free!
Email Excel Workbooks to 'Embedded' and 'Linked' Email Addresses.
Maintain 'Linked' Address workbooks through EZ-Email or directly in Excel.
Email EZ-Split split workbooks and other qualifying Excel workbooks.
EZ-Email is included Free in EZ-Split and EZ-Format.
Try

EZ-Stat

$39.95
On-demand calculation of Excel Math & Stat Formulas with no formatting changes.
Sum Average Median Min Max Count Stdev Range ... All 24 Excel Math & Stat Formulas.
Calculate for all data, a selected value and at changes in up to four non-numeric fields.
"Full Stats" calculates up to 24 standard Excel Formulas for Analysis & Charting!
All EZ-Stat features are built into and included free with EZ-Format.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
Try

Flash Video on EZ-Stat
On-Demand Instant Data Analysis Tool
EZ-Subtotal

$39.95
This Add-in is for every Excel user who works with Subtotals!
In five minutes or less learn how to create better formatted Excel Subtotals.
Change Subtotal Types and Subtotal Fields without removing Subtotals.
Mix Count, Sum ... Excel Formulas on each Bolded and Shaded Subtotal row.
Many EZ-Subtotal features are included Free in EZ-Format.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
Try

Flash Video on EZ-Subtotal
Fast, easy, better formatted Excel Subtotals
EZ-Pivot

$39.95
Create automatically formatted Excel PivotTables, PivotCharts and Drill
Worksheets in seconds without modifying the original data's formatting.
Customize Drill Sheets: fields to display, field order, sort order, totals ...
Create Re-usable Custom Drill Worksheets for any PivotTable.
Use EZ-Format for even more options in automatically formatting Drill Worksheets.

Try

FlashVideo on EZ-Pivot
PivotTable, PivotChart and Drill Worksheet
Creation, Formatting and Analysis Tool
EZ-Chart2

$39.95
Many of EZ-Chart's features with an easy to use chart creation interface!
Make XY, XYZ, XY Combination (2 Y-Axes) Charts and 1 Chart per X Value.
Chart multiple secondary Y-Axis fields. Age X-Axis Date Fields on-the-fly.
Installs separately from EZ-Chart but uses the same software licensing.
EZ-Chart2 is an even easier way to create Excel Charts.
Get Both EZ-Chart and EZ-Chart2 for only $39.95.
Try

Flash Video on EZ-Chart2's Quick and Easy
Data Summarization and Enhanced Excel Charting

EZ-Chart

$39.95
Automatically summarize data and create identically formatted Excel Charts.
Customize, save and reuse Excel Chart Formatting for all Excel Chart Types.
Dynamically sort and set the number of values to chart.
Creates Excel XY, XYZ and Combination Charts having a seconday Y-Axis.
If you only want to summarize and calculate Excel Formulas for creating your own charts, use the "Stat" features in either EZ-Format or EZ-Stat.
Try

Flash Video on EZ-Chart
Data Summarization and Enhanced Excel Charting Tool
EZ-Calc

$39.95
Create Excel Formulas, Aged Dates and seven practical Excel formula fields.
Paste Excel Formulas to detail rows without first removing Excel Subtotals.
Aged and Reformatted Dates are included in EZ-Chart and EZ-Pivot.
Five of seven EZ-Calc Custom Excel Formula Fields are included Free in EZ-Format.
Try

Flash Video on EZ-Calc
for creating Standard and Custom Excel Formula Fields

Add-ins for Very Fast Microsoft Dynamics GP SmartList Excel Exports
and Automatic Reformatting of QuickBooks Reports Exported to Excel.


EZ-GP

$39.95
Over 100 times faster exports to Excel from SmartList in Microsoft Dynamics GP.
EZ-GP is included at no charge with Xcelerator.
Xcelerator immediately and automatically formats SmartList exports to Excel.
If you do not need automatic Charts and PivotTables, use EZ-Format to create identically formatted worksheets from SmartList exports.
Try

Flash Video on EZ-GP
Microsoft Dynamcis GP SmartList Fast Excel Export Tool
EZ-Quick

$39.95
Improve readability & reduce pages in Quickbooks Reports exported to Excel.
Reformats QuickBooks Reports for better viewing and printing in fewer pages.
Auto update QuickBooks Reports Excel Page Layout for printing in 50% fewer pages.
Merge Descriptions in Quickbooks Reports to print more Amount Columns per page.
View totals for filtered records when setting Excel data filters in QuickBooks Reports.
Export only the visible worksheet data with auto-conversion of #REF formula errors.
New! Includes Ribbon for use with Excel 2007 / Excel 2010.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
Try

Flash Video on EZ-Quick
The QuickBooks Excel Reports Re-formatting Tool

Xcelerator is the Only Excel Add-in to Completely Automate Workbook Formatting.
Go from raw data to an identically-formatted, feature-rich and printer-ready Excel workbook in seconds.

Xcelerator

$99.95
Xcelerator is the only Excel Add-in to completely automate Excel formatting.
Automatically create identically formatted Excel workbooks in seconds.
Create Excel Formulas, Sorts, Subtotals, Conditional Formatting, Filters ...
Automate every major Excel feature used to format new or updated data.
Quickly create re-usable workbook formats using the same Excel formatting
features & techniques found in EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc.
Xcelerator includes EZ-Pivot, EZ-Split, EZ-Stat's Quick-Stats feature and EZ-GP.
Try

Flash Video on Xcelerator
Excel Formatting Automation Add-in Tool

Xcelerator is the only Microsoft Excel Add-in automtically creating 100% identical Workbooks.
Transparently create re-usable Excel Templates for Worksheets, Charts and PivotTables.
Re-use to create identical Workbooks for imported, extracted and manually maintained data.
Creating identically formatted, feature rich Excel Workbooks for new data is completely automatic.

If you periodically format new raw data for the same sets of fields to create identically formatted
Excel Worksheets, Charts and PivotTables use Xcelerator to completely automate the formatting.

Download the Free 15-Day Trials
Take the short automated demos.
All Products install and uninstall in seconds.
All Products include free updates and enhancements.
If you have questions email support@datapresentation.com