Pivot Table facts

While investigating facts about Pivot Table Tutorial and Pivot Tables For Dummies, I found out little known, but curios details like:

EA's CTO Ken Moss created the Pivot Table feature in Microsoft Excel.

how pivot tables work?

What pivot tables are used for?

In my opinion, it is useful to put together a list of the most interesting details from trusted sources that I've come across answering what pivot table do. Here are 1 of the best facts about Pivot Table Calculated Field and Pivot Table Pandas I managed to collect.

what pivot table in excel?