Excel Subtotals Straight to the Point
- 47m
- Bill Jelen
- Tickling Keys
- 2018
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.
In this Book
-
Preparing Your Data and Adding Subtotals
-
Subtotal Tricks & Techniques
-
Subtotal Troubleshooting
-
Using the SUBTOTAL function without Invoking the Command
-
Introducing AGGREGATE
-
Using VBA with Subtotals
-
Replacing Subtotals with Power Query
