Graves Flores posted an update 5 months, 2 weeks ago
The reality is that every user who may have learned to make use of PTs have observed a huge boost in their productivity. Not simply because of the speed of making reports but with the quick insights you can get from large data sets.
If you present a written report of Sales by Product by Region and someone inquire, let’s say… You’d probably say let me open the file and drag-and-drop it today.
Here are the pros of for you to use Pivot Tables
– Summarizes a huge number of rows quickly.
– Changes the layout of report by just dragging and dropping.
– Formats your report quickly.
– Slices and dices your flat table by category.
– Lets you add calculated columns.
– No formulas needed (at the very least you utilize calculated fields).
– Does not consume enough memory resources.
– Formats data able to be analyzed.
– Permits you to connect to external databases: OLAP, SQL server, Access, etc.
Listed here are the negatives of why you should not use Pivot Tables
– Will not let you start to see the source of values reported as in formulas (by pressing F2). Anyone would like to see in which the data came from to enable them to easily look into the formula.
– Will not offer flexibility to prepare customized reports in cells.
– Won’t refresh the outputs immediately if the backend list changes.
– Clutters the workbook if there are a large number of little Pivot Tables everywhere.
– Occupies space in the worksheet.
– Doesn’t offer easiness of moving the outcome through the worksheet.
– Doesn’t let edit calculated fields directly inside the cells.
– Offers limited supported functions in calculated fields.
Conclusion. I am a fan of Pivot Tables but I am a fan of Lookup formulas too. If you are looking for what-ifs calculations by changing the inputs, data Lookup formulas would be a option. Alternatively, Should your input data is relatively static however, you want to do what-if analysis with drill-down, then Pivot Tables make the perfect choice. Unfortunately, the limited aggregate functions available in a Pivot Table, the impossibility to embed outputs in other formulas and the limited functions supported within a calculated field result in the using formulas unavoidable.
More info about use of pivot table in excel explore our site: