• Hein Silverman posted an update 5 months ago

    In fact every user who may have learned to make use of PTs have noticed a huge increase in their productivity. Not just due to the speed of creating reports but by the quick insights you can get from large data sets.

    If you present a study of Sales by Product and also by Region and someone inquire, suppose… You would say allow me to open the file and drag-and-drop it at this time.

    Listed here are the professionals of why you should use Pivot Tables

    – Summarizes 1000s of rows quickly.

    – Changes layout, design of report through dragging and dropping.

    – Formats your report quickly.

    – Slices and dices your flat table by category.

    – Permits you to add calculated columns.

    – No formulas needed (no less than you use calculated fields).

    – Won’t consume enough memory resources.

    – Formats data able to be analyzed.

    – Enables you to hook up to external databases: OLAP, SQL server, Access, etc.

    Here are the disadvantages of why you ought to not use Pivot Tables

    – Will not permit you to start to see the source of values reported such as formulas (by pressing F2). Anyone desires to see where the data originated from for them to easily look at the formula.

    – Doesn’t offer flexibility to arrange customized reports in cells.

    – Does not refresh the outputs immediately when the backend list changes.

    – Clutters the workbook if there are lots of little Pivot Tables everywhere.

    – Occupies space in the worksheet.

    – Doesn’t offer easiness of moving the final results over the worksheet.

    – Doesn’t let it edit calculated fields directly inside the cells.

    – Offers limited supported functions in calculated fields.

    Conclusion. I’m a fan of Pivot Tables but I am hot for Lookup formulas too. If you are searching for what-ifs calculations by changing the inputs, data Lookup formulas would have been a option. However, Should your input details are relatively static nevertheless, you might like to do what-if analysis with drill-down, then Pivot Tables make the perfect choice. Unfortunately, the limited aggregate functions for sale in a Pivot Table, the impossibility to embed outputs in other formulas along with the limited functions supported within a calculated field result in the utilization of formulas unavoidable.

    More info about

    what is a pivot table see this web page