Sort lengthy and complex data into easy-to-understand reports and graphs
with Pivot Tables.
You might have a lot of data in many different categories. Using Pivot Tables, you can sort and chart data easily. Whether you want a "helicopter" overview or to drill down into a specific category, you can extract exactly what you need. You can even get Excel to lead you step-by-step through this process. Best of all, you can then turn your chosen data into an simple graph, which is great for presentations or for analysing trends.

Click play to watch