Excel: Using the Subtotal command
Did you know that you can automatically calculate subtotals in a list for a column by using the Subtotal command? No formulas needed by you on this one.
Take the time to save time and read on for the overview and the instructional bonus video providing the step-by-step instructions. You do not want to miss out on this.
What is the Subtotal command?
Note: this feature is available in several versions of Excel.
The Subtotal command is used to automatically create subtotals and grand totals within your data. The Subtotal command will also automatically outline your list so that you can display and hide the detail rows for each subtotal.
The Subtotal command in Excel 2007 is accessed from the Outline group, which you can get to from the Data tab. If you are using a lower version of Excel you will find the Subtotal command in the Data menu.
How do I use the Subtotal command?
This week's tip is provided via a training video that is just 6.5 minutes. It is worth the 6.5 minutes to save possibly hours of work, so warm up your coffee, sit back and enjoy taking in some knowledge that will increase your productivity.
Special Note: your spreadsheet list must be setup a certain way to use the Subtotal command. Each column must have a label for the first row, contains similar information within each column, and your list cannot
contain any blank rows or columns. You should alphabetize the column that you wish to group your subtotals by.
Training Video
Practice what you learned
It's always important to have hands-on practice to reinforce what you learn so I have included the practice file that I used in the video. Use the Practice link below to download the file.
The next tip will be on PowerPoint!
Have a fabulous week!
Member of:
American Society for Training and Development
National Speaker's Association
| 
