What are Pivot Tables?
The Excel tutoring site EXCELJET describes pivot tables as, “one of the most powerful and useful features in Excel”. These interactive tables allow users to breakdown large data sheets into more manageable pieces that can focus on specific areas of the data. EXCELJET offers a quick and easy tutorial that breaks down each step needed to create an amazing pivot table.
My Personal Experiences
I was lucky enough to have used pivot tables before as part of an internship with a utilities company. They tables were a huge help when we needed to categorize and sort through large amounts of customer data.
The table above is just a small sample of the type of data we would have to work with and they would often include thousands of customers. Pivot Tables allowed us to quickly organize this data into whatever form we needed. Whether that was….
by the type of services they used,
the length of the time that they were customers,
or to quickly find certain accounts for auditing purposes.