What are Pivot Tables and why are they useful?
Pivot Tables are essentially reports that companies use for their own personal checks and balances. What sets them apart from statistical charts is the fact that they are very interactive. Instead of having a multitude of confusing formulas, you can have a very simple table where you can choose what variables you want to compare.
In my research, I found a lot of interesting ways to use Pivot Tables. This website was particularly helpful in simplifying what the tables are used for and how to construct one.
https://exceljet.net/excel-pivot-tables
According to https://www.criticaltosuccess.com/top-29-pivot-table-tips-for-consultants/ , The best use for pivot tables are for recording sales numbers. You can specify the time of year, a certain product, and a lot of other fields.