Excel Week 7: Data Types & Pivot Tables

A pivot table can be considered to be a valuable Excel reporting tool as it allows users to easily analyze the data and arrive at quick decisions. This serves as a huge advantage in the industrial world, where it is crucial to make precise and quick decisions.

Benefits of using pivot tables:
Pivot Tables are worksheet tables that let you summarize and analyze your Excel data. Benefits include:
 Ability to recap using any data element and then drill down to review the details.
 Formulas may restrict sorting capabilities or maybe corrupted when adding and deleting rows
or columns.
 Ability to get a summary or recap of the data rather than scrolling down to find each subtotal.
 Data does not have to be sorted by a particular element in order to get a subtotal for that data
element.