Skip to Main Content
Excel Macros For Dummies, 3rd Edition
book

Excel Macros For Dummies, 3rd Edition

by Dick Kusleika
March 2022
Beginner content levelBeginner
304 pages
6h 19m
English
For Dummies
Content preview from Excel Macros For Dummies, 3rd Edition

Chapter 8

Automating Common Reporting Tasks

IN THIS CHAPTER

Bullet Refreshing all PivotTables

Bullet Creating a PivotTable inventory summary or a set of disconnected charts

Bullet Adjusting all pivot data field titles

Bullet Setting all data items to sums

Bullet Setting the number format or custom sort for all data items

Bullet Sorting all fields in alphabetical order

Bullet Applying PivotTable and pivot field restrictions

Bullet Automatically deleting PivotTable drilldown sheets

Bullet Printing PivotTable for each report filter item or for all charts

Creating new workbook for each report filter item

Resizing or aligning charts

If you’re tasked ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies

Excel Macros For Dummies

Michael Alexander

Publisher Resources

ISBN: 9781119844433Purchase Link