Learn how to insert subtotal rows into sorted data without having to spend time doing it manually.
Recently I ran a training session for an Accounts Manager and her staff. They spent a lot of time pulling data out of their in-house computer system, sorting it by customer and then inserting a new row at every change in the customer name. This was so that they could place a SUM into the row to total what the customer had spent with them.
Using the Subtotals feature I showed them a quick and effective way in which to summarise their data. And yep! They were pretty impressed! Read more