22. Using Automatic Subtotals
The Subtotal command was added way back in Excel 97. Not enough people realize that the command is in Excel, and those who have tried it often don’t realize how powerful the command truly is. I used to have a regular gig as the Excel guy on Leo Laporte’s Call for Help television show. During one appearance, I showed people how to use the Subtotal command. I figured it was probably the most boring 6 minutes of television in the history of the world. However, that one show generated more fan email than any other. People wrote to say that they have been spending 2 hours every day adding subtotals manually and used the trick from the show to reduce the task to a minute.
Adding Automatic Subtotals
When you have a database ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
