Pivot Tables are great for summarizing data in multiple buckets. It’s easy to break out the data into different categories, and subtotal the values for each one. In this video, we’ll add Columns to our analysis to split out the results by business unit, and into Actual and Budget categories with subtotals.
If you already use Pivot Tables, grab a copy of my Top 5 Strategies for Effective Pivot Table Reporting to learn new techniques, including: how to make GETPIVOTDATA return different values, and how to use Excel Tables to refresh your pivot tables with ease!
Download the document here: http://xcellerations.com/pivottablescourse
Also, it would be awesome if you would please send this link to your co-workers and friends, too. I’d love to get as many people as possible using pivot tables to make their lives easier and their analyses FAST!
Thanks for stopping by!
p.s. You can check out other posts on the Blog feed and/or Sign up to be notified when the next post is available.
Leave A Response
You must be logged in to post a comment.