Carlita Holloway

What is a pivot table?

A pivot table is a type of visualization that let the user lay out huge samples of data in one sheet for the user to analyze and examine. They are typically used for all kinds of business practices or financial consultations. Here is an example of one.

With a pivot table like this, a user can take data and organize or “pivot” the information to reconstruct and look at the information differently. That is where the word “pivot” in pivot table comes from.

That is one reason pivot tables are so handy with working with large groups of numbers; being able to organize large complex sets of data and organize them into more comprehensible forms of data makes it much easier for both the reader and presenter to digest. Attached is a video describing how to create a pivot table of your own.