Excel Report - A Pivot Table Overview
In fact every user that has learned to work with PTs have experienced a tremendous surge in their productivity. Not merely because of the speed of developing reports but through the quick insights you can find from large data sets.
In case you present a report of Sales by Product and by Region and someone inquire, what if... You'd probably say permit me to open the file and drag-and-drop it today.
Allow me to share the pros of why you need to use Pivot Tables
- Summarizes 1000s of rows within minutes.
- Changes customized for specific cultures of report by simply dragging and dropping.
- Formats your report quickly.
- Slices and dices your flat table by category.
- Enables you to add calculated columns.
- No formulas needed (at least you use calculated fields).
- Does not consume enough memory resources.
- Formats data able to be analyzed.
- Allows you to connect with external databases: OLAP, SQL server, Access, etc.
Listed below are the negatives of why you need to not use Pivot Tables
- Won't enable you to understand the source of values reported such as formulas (by pressing F2). Anyone wants to see the place that the data originated from for them to easily confirm the formula.
- Does not offer flexibility to rearrange customized reports in cells.
- Will not refresh the outputs immediately in the event the backend list changes.
- Clutters the workbook if there are a large number of little Pivot Tables everywhere.
- Occupies space inside the worksheet.
- Doesn't offer easiness of moving the final results throughout the worksheet.
- Doesn't let edit calculated fields directly from the cells.
- Offers limited supported functions in calculated fields.
Conclusion. I am a fan of Pivot Tables however i am keen on Lookup formulas too. If you are searching for what-ifs calculations by changing the inputs, data Lookup formulas will be a option. Alternatively, If your input information is relatively static however, you might like to do what-if analysis with drill-down, then Pivot Tables are the ideal choice. Unfortunately, the limited aggregate functions accessible in a Pivot Table, the impossibility to embed outputs in other formulas and the limited functions supported in a calculated field make usage of formulas unavoidable.
For more details about use of pivot table in excel go to see this net page.