Thursday, May 12, 2016

Subtotals Rock!

As I often say, there are so many great tools in Excel that get surprisingly little notice. The built-in Subtotal feature can save you an enormous amount of time and give you a remarkably easy way to Organize Your Data.  The really great thing is that it takes practically no effort. Here are 3 Reasons Why you should put Subtotals in your Excel tool belt:

1. Flexibility: As you would expect, Subtotals are able to Summarize your data by SUM. But that’s not all! Your data can also be reviewed by Count, Average, Max, Standard Deviation, as well as other functions.

2. Energetic: On the fly accessibility whenever you need to control your data and fields at your fingertips, you have the ability to slice and dice your information in real time!

3. Sharable: Often what an analyst or manager wants is a “Quick and Dirty” way of reviewing their data in a logical manner. Moreover, however, it is typically desirable to share the information (“Informationas I always say is clearly an analyst’s goal, rather than presenting mere “Data”) with others. Subtotals are a sharp, concise way of doing exactly that!

Subtotals are often misunderstood, ignored, or simply overlooked. Important Tip: Since you need to initially sort your data according to what you wish to summarize, it might be a good idea to save it to a Practice File before first trying this out. It is always good to have a backup.

Subtotals. Another example of a Fine Excel Tool that you should test out soon!

No comments: