Data Presentation Products
 
Microsoft Excel Subtotals  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-SUBTOTAL > Worksheet Examples

EZ-SUBTOTAL | FEATURES | INTERFACE | Examples | RANKING | VIDEOS | FREE-FEATURES
 

 

EZ-Subtotal Created and Excel Created
Subtotaling Worksheet Examples


Create Every EZ-Subtotal Worksheet Shown Below in Minutes



EZ-Subtotal Created Excel Subtotals

Better Formatted and Easier to Create and Use

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

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

EZ-Subtotal Created Subtotals


EZ-Subtotal Created Ranked Excel Subtotals

States Automatically Resorted in
Descending Order by the Sales Amount Subtotals


Use the Subtotal Dialog to Set the Ranking Field

EZ-Subtotal Created Ranked Subtotals


EZ-Subtotal Ranked Excel Subtotals for City & Above

At Outline Level 3 it is easy to see the Automatic Resorting of the
States in Descending Order by the Sales Amount Subtotals


Created in Two Clicks using EZ-Subtotal

EZ-Subtotal Created Ranked State Subtotals at Subtotal Outline Level 3



EZ-Subtotal Filtered Excel Subtotals

Double-Clicking "Steve Smith" Sets the Data Filter and Exposes Subtotal Rows

Standard Excel Data Filters do not expose Excel Subtotal Rows

EZ-Subtotal Created Excel Subtotals


EZ-Subtotal Filtered Subtotals with Associated Detail

"Show Associated Detail" on the "L" Menu Exposes All Rows in Filtered Groups

EZ-Subtotal Created Excel Subtotals


Excel Filtered Subtotals set using the Filter Drop Down

Excel does not expose Subtotal Rows unless the Rows Contain the Filter Value

EZ-Subtotal Created Excel Subtotals


Subtotals Created using only Excel Subtotaling

No mixing of Excel's Subtotal Types and no use of Formulas for Percents and Averages

The erroneous Grand Total Rows sometimes created by all versions of Excel are highlighted

Excel Only Created Excel Subtotals



Comparison of Viewing Excel Subtotals without Detail

EZ-Subtotal Created State and City Excel Subtotals at Outline Level 3

With City Subtotal Shading and Bolding Removed and Empty Non-Subtotal Columns Hidden

EZ-Subtotal Created State and City Subtotals at Outline Level 3


The Equivalent Excel Only Created State and City Subtotals

More Subtotal Rows, little Bolding, no Shading and no Hiding of Non-Subtotal Columns

Excel Only Created State and City Subtotals at Outline Level 6



Example of Exporting Only Visible Subtotaled Data

Two Clicks Exports only the Currently Visible Rows and Columns

In this EZ-Subtotal Export of filtered data all hidden rows have been automatically deleted

Excel Only Created State and City Subtotals at Outline Level 6



Instantly Calculate All 11 Excel Subtotal Type
Formulas and the Median & Mode Formulas at
Each Subtotal Break for One or All Subtotaled Fields


Two Clicks Instantly Calculates 13 Formulas for Only the Visible Data

Demonstration Video EZ-Subtotals 13 Calculations Video 04/15/2009 1:53

Calculate for Subtotaled Fields at each Subtotal Break and View Only Formulas of Interest

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
In Non-Subtotaled Data Calculate using All the Visible Data for the Fields with Column Totals

Eight of Thirteen Formulas Calculated for Column Totaled Fields for all visible data.

Dashes "--" in "StdDev" and "Var" indicates formulas produced an Excel error because Count = 1.

Dashes "--" in "Median" and "Mode" indicates formulas not calculated (done only at highest "LV").

Blank in "Mode" indicates there is no most frequently occurring number at the highest "LV".          



Use "Formulas for ..." on the "L" icon's Menu to Create Formula Worksheets

Use "Formulas to Hide or Display" to Select Formulas to Display by Default

EZ-Subtotal's 'L' icon's Menu with the 'Formulas for ...' Options




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.





More Information on Making & Using Better Excel Subtotals

EZ-SUBTOTAL | FEATURES | INTERFACE | Examples | RANKING | VIDEOS | FREE-FEATURES