Join Dennis Taylor for an in-depth discussion in this video Setting up subtotals, part of Managing and Analyzing Data in Excel 2010.
After sorting a list of data, perhaps like the current list which is sorted by…department, you might want to insert automatic subtotals at appropriate…breakpoints in the list.…Once you do this too there will be some automatic expansion and collapsing tools…called Outlining Symbols, which you can create using other features in Excel.…So this particular list here is ready to have some subtotals inserted and…rather than that manually--…and it would take a lot time, there are about 23 departments here, but imagine…manually putting a new row in front of each one of these--…a prerequisite also is that your data has not been converted into a table.…
The next sheet to the right here is a table.…I'll click on this and if we were about to use the Subtotals feature it's on the Data tab.…Recognize that Subtotal out here is grayed out.…You cannot use this on the data we first saw.…I am going to back to that first sheet. We are ready to insert Subtotals here…and on the Data tab the Subtotal command is available.…
- Multiple key sorting
- Single and multiple column numeric filters
- Creating a top-ten list with values or percentages
- Setting up subtotals
- Creating multiple-field criteria filters
- Creating unique lists from repeating field data
- Using the Remove Duplicates command
- Finding duplicate data with specialized arrays
- Counting the number of unique items in a list
- Using SUMIF and COUNTIF functions
- Working with the database functions such as DSUM and DMAX
Skill Level Appropriate for all
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.