- Using pivot tables to create a dashboard of source data.
- See this video to see the how: https://www.youtube.com/watch?v=g530cnFfk8Y
- Example coming soon!
Use the pivot data to explore data further by using rows/ column analysis of data, application of filters, and increasing/decreasing granularity of the data. Pivot Pal will help with data investigation when it comes to data with many fields!
This is a very useful tool for people like me who would like to gain more advanced skills in Excel for work and personal accounting.