Excel Forum
Similar Content
Excel Import Web Data Copy/Paste + Easy Analysis
Tutorial: How to easily bring data into Excel from the web using copy/paste and then quickly transf...
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT or COUNTA function on a filtered list of data so that hidden rows ar...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Basics #19: Data Analysis Subtotals


The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#19 Video topics:
1)Subtotals
2)See how to sort first and then do Subtotals
3)Major Key Field Subtotals first and then secondary field with the Replace Current Subtotals unchecked
4)Excel List Table Database format is required for Subtotals
5)Data Subtotals Sub Totals





Got a Question? Ask it Here in the Forum.