This “Office Show” video features a common dilemma: The budget data you want to analyze in Excel contains so many rows and columns of numbers that it seems like an impossible task to get it all sorted out. Meanwhile, there’s a deadline looming and mounting pressure to figure out how to save money.
This’s where PivotTables come in. PivotTables are brilliant at making sense out of walls of numbers, because they do a lot of the work for you. They can automatically organize and summarize your data, so you can immediately see things like what areas of your business are performing the best (and, unfortunately, the worst).
So what situations really call for a PivotTable? Consider creating one when you want to:
- Make sense of large amounts of data and numbers – A PivotTable helps you see the forest through the trees
- Analyze your data in minute detail – Drill down to answer specific business questions. For example, you’ll be able to see which of your products are outselling others or which ones are generating the most revenue
- Focus on areas that need your attention – Apply specific filters to see just the data you want to analyze
- View your data from different angles – Pivot the data to get the perspective you want, perhaps to compare data from different regions or different products
- Present your data in a report – A professional-looking report format will help other people easily understand your data analysis, especially if you use features such as conditional formatting and sparklines. You can even include a PivotChart for visual cues.