Excel Subtotals Straight to the Point
Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
| Author: | Bill Jelen | ISBN: | 9781615473656 |
| Publisher: | Holy Macro! Books | Publication: | March 15, 2018 |
| Imprint: | Holy Macro! Books | Language: | English |
| Author: | Bill Jelen |
| ISBN: | 9781615473656 |
| Publisher: | Holy Macro! Books |
| Publication: | March 15, 2018 |
| Imprint: | Holy Macro! Books |
| Language: | English |
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.
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.
