Data Presentation Products
 
Microsoft Excel Subtotals  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-Subtotal

EZ-Subtotal | FEATURES | INTERFACE | EXAMPLES | RANKING | VIDEOS | FREE-FEATURES
 

 
EZ-Subtotal
For the Best Formatted Excel® Subtotals,
Easier to Create Excel Column Totals,
Easier to Set Excel Data Filters,
Data Filters that expose Excel Subtotal Rows,
Exporting / Copying Only Visible Excel Data,
Calculating All 11 Excel Subtotal Types and Mean & Mode at all Subtotal Breaks for Subtotaled Fields,
and Many More Excel Subtotaling Enhancements ...

"Every Excel® User can Benefit from EZ-Format & EZ-Subtotal!"

How to Quickly Create Subtotals using EZ-Subtotal - 05/01/2009 03:22

15-Day Trial   Purchase for $29.95

New Version 06/19/10

EZ-Format includes free use of EZ-Split & EZ-Subtotal

& all EZ-Stat features are built-in for use with EZ-Format worksheets.

EZ-Format includes all EZ-Subtotal subtotaling features plus many

additional worksheet formatting features not found in EZ-Subtotal.

Purchase EZ-Format for $39.95 and use EZ-Subtotal ($29.95) and EZ-Split ($29.95) free.

EZ-Split split worksheets retain all EZ-Format and EZ-Subtotal Formatting and Subtotals.

Download EZ-Format and EZ-Split and then EZ-Subtotal
to try all three add-ins at the same time.

New!  EZ-Subtotal, EZ-Format, EZ-Split & EZ-Stat Excel 2007 Ribbons

The EZ-Subtotal Excel 2007 Ribbon
Every add-in's single install works with Excel 2000, XP, 2003 and Excel 2007

Create Better Formatted More Useful Excel Subtotals

No Pre-sorting • Turn Subtotals Off & On • Dynamically Change with Subtotals Turned On


Mix Counts, Sums ... and Excel Formulas for Percents on all Subtotal Rows.

Optional Bolding, Shading, Column Borders and Excel Data Filters Work

with Dozens of Enhancements to Make More Useful Excel Subtotals.


EZ-Subtotal Created Subtotals
The same data subtotaled using only Excel!

More Subtotal Outlines make Viewing more Difficult.

The Count and Sums are not mixed on each Subtotal Row.

It is impossible to create subtotals for Percent and Average Fields.

Excel Only Created Subtotals

Dynamically Change Excel Subtotal Types
without having to remove and recreate Subtotals


Impossible when using only Excel!

Dynamically Change Excel Subtotal Types and Sorts

Double-Click to Set Filters and Expose Subtotal Rows

Impossible when using only Excel!

Double-Click to Set Filters and Expose Subtotal Rows
View all Records in the Groups of Filtered Data

Time Consuming and tedious when using only Excel!

View all Records in the Groups of Filtered Data
Export Visible Rows Retaining all Formatting

Difficult to impossible when using only Excel!

Export Visible Data Retaining all Formatting
Instantly Calculate All 11 Excel Subtotal Type
Formulas and the Median & Mode Formulas at
Each Subtotal Break for One or All Subtotaled Fields


Calculate: Sum Count Average Min Max CountNums StdDev StdDevp Var Varp Product Median Mode

Eight of Thirteen Formulas Calculated for All Subtotal Fields at each Subtotal Break
Feature List       Try EZ-Subtotal

New Version 06/19/10

Experience how to quickly create and use better formatted Excel Subtotals!
Installs and Completely Uninstalls in Seconds - Become an EZ-Subtotal Expert in Minutes.
Securely Purchase from within Excel for $29.95 and EZ-Subtotal Automatically Self-Registers.
Includes Life Time Free Updates and Upgrades - Simply Download & Install the Latest Version.


 

EZ-Subtotal Features

Not Available in Excel

Faster, Easier and Better Excel Column Totals and Excel Subtotals
Learn to create Better Formatted Excel Subtotals within minutes of installing
No Pre-Sorting of the Excel Data to be Subtotaled
Automatically Sort Excel Subtotal Break Fields
Automatically Sort Additional Fields beyond Excel Subtotal Breaks
Optionally Moves Excel Subtotal Break Fields to the Left for easier viewing
Automatically Groups All Blank Excel Subtotal Break Field Values
Turn Excel Subtotals Off and Turn Excel Subtotals On
Re-order Multiple Excel Worksheet Columns in One-Step
Hide and Unhide Multiple Excel Worksheet Columns in One-Step
Make Excel Subtotaling changes without removing and recreating subtotals
Dynamically Change Excel Subtotal Break Fields and Subtotaled Fields
Dynamically Change Excel Subtotal Types
Dynamically Change the Additional Excel Subtotal Sort Fields
Mix Count, Sum, Avg ... All 11 Excel Subtotal Types on All Excel Subtotal Rows
Use Excel Division Formulas to Subtotal Percent and Average Fields
Mixing Excel Subtotal Types Creates Fewer Excel Subtotal Outline Levels
Automatically Removes & Recreates Excel Column Totals
Create 12 Different Adjustable Excel Column Total Types
Optionally Create Excel Data Filters when Creating Excel Subtotals
Double-Clicking Data Values Sets and Unsets Excel Data Filters
Excel Subtotals and Excel Column Totals Automatically Adjust to Data Filters
Excel Subtotal Rows are automatically exposed after Setting Excel Data Filters
Optionally Bold and Gradient Shade Excel Subtotal Rows
Create Optional Column Borders for easier viewing of Subtotaled Excel Data
Toggle Excel Subtotal Bolding, Shading and Column Borders On and Off
At any Excel Subtotal Outline Level Export / Copy the Visible Worksheet Data
Instantly and Simultaneously Calculate All 11 Excel Subtotal Types
    and Median & Mode at each Subtotal Break for Subtotaled Fields

Resort Subtotaled Data by the Excel Subtotals of the Primary Break Field
Eliminates erroroneous Excel Subtotal Rows created by All Versions of Excel



More Information on Making & Using Better Excel Subtotals

EZ-Subtotal | FEATURES | INTERFACE | EXAMPLES | RANKING | VIDEOS | FREE-FEATURES