Data Presentation Products   Microsoft Excel Subtotals     Microsoft Excel Add-ins

HOME PRODUCTS EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products MOVIES DOWNLOADS EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products PURCHASE EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products CONTACT US MORE FAQ Support Site Map About Us

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 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 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 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 Filtered Subtotals with Associated Detail "Show Associated Detail" on the "L" Menu Exposes All Rows in Filtered Groups Excel Filtered Subtotals set using the Filter Drop Down Excel does not expose Subtotal Rows unless the Rows Contain the Filter Value 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 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 The Equivalent Excel Only Created State and City Subtotals More Subtotal Rows, little Bolding, no Shading and no Hiding of Non-Subtotal Columns 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 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 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 In Non-Subtotaled Data Calculate using All the Visible Data for the Fields with Column Totals 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 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

DPPI Add-ins for Excel are Windows Vista®, Windows 7® and Microsoft® Office 2007/2010 Compatible HOME PRODUCTS DOWNLOADS PURCHASE MOVIES FAQ SUPPORT CONTACT US ABOUT SITEMAP COPYRIGHT © 2002-2010, Data Presentation Products, Inc., ALL RIGHTS RESERVED Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.