The latest episode in the Accountants' Guide series has just been posted to the Excel Community.
In the post, we move on from examining why you might want to use PivotTables or why you might want to ignore them entirely, to considering some of the ways to use a PivotTable to explore and present data. In particular, we look at how adding filters to a PivotTable can help you answer important questions about your data interactively and show how using Timeline Slicers and Slicers can really bring home the bacon:
Accountants' Guide to Excel – anatomy of a PivotTable
This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.