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.
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.
Access the Identical Features from the EZ-Format Toolbar in Excel 2000, XP and 2003.
|
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.
|
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

|
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

|
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

|
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

|
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

|
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
|
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

|
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

|
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

|
|
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
|
|
|