How are you doing your regular reports? Crunching numbers with calculators and hundreds of bits of paper is no fun. And it’s always against the clock. We’ll show you how to do it with Excel Pivot Table reports. Update your source data, click to refresh your analytical reports and you’re done for another reporting cycle. Easy!
But there’s more to Pivot Table calculations than just a simple SUM or COUNT. We’ll demonstrate the use of calculated fields and items and how to take advantage of the Show Values As options to calculate percentages, comparatives and differences. These are great for showing calculations like variance on previous month or market share etc.
After you’ve crunched your numbers, we’ll show you how to help everyone interpret your data by introducing data graphics like Slicers, Timelines, Charts, Data bars and Traffic lights.