English | 2018 | ISBN: 1615472436 | 70 Pages | PDF

This book completely and thoroughly covers every trick known about Subtotals in Excel.

You will learn: How to get your data ready for subtotals, Adding Subtotals, Showing only the Subtotals, Sorting Subtotals, Formatting Subtotals, Subtotal Tricks, Subtotal Troubleshooting, Using the SUBTOTAL function without using the Subtotal command, using AGGREGATE, Creating Subtotals with VBA, Replacing Subtotals with Power Query.