When you are faced with a large set of data, say in a worksheet or database query, it can be a challenge to get the information you want from that data.
Excel Pivot Tables and Pivot Charts are a great way to get information flexibly, interactively and at the click of your mouse.
Once a Pivot Table is set up, users can view the data in different ways, adding or removing fields, sorting or filtering and adding subtotals and averages to get precisely the view they need.
Pivot Charts add a further dimension, allowing the user to get a graphic view of the information in just the same way.
The Pivot Table can also be linked to the data, so that as new data is added the Pivot can automatically refresh.
The example I have attached was built for a ticketing company with multiple venues and performance sites. Each day the Pivot Table was refreshed to give the user the latest days sales. With a couple of clicks, different venues could be selected and or different dates and times.
2 Reviews For This Service