This is the demonstration file to accompany the article, How to quickly make Excel subtotals stand out from the data, by Susan Harkins.

From the intro of this Microsoft Excel tutorial:

Microsoft Excel’s Subtotal feature calculates subtotals and a grand total for columnar data, but that’s not all. This Excel feature supports 11 calculating processes: sum, count, average, maximum, minimum, product, count number and more. The good news is that Excel’s Subtotal feature requires very little setup–in less than a minute, you can render a rather complex problem into results. Unfortunately, there’s scant little formatting. In this Excel tutorial, I’ll show you how to run subtotals on a simple data set and then quickly apply formatting that will make those totals really stand out.