Setting up subtotals


show more Setting up subtotals provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Setting up subtotals

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 comma...

Setting up subtotals
Video duration: 4m 20s 1h 32m Appropriate for all

Viewers:

Setting up subtotals provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...