• Hein Ahmad posted an update 2 months, 1 week ago

    The truth is every user who may have learned to make use of PTs have seen a tremendous surge in their productivity. Not merely due to the speed of making reports but through the quick insights you can find from large data sets.

    If you present an investigation of Sales by Product through Region and someone ask you, let’s say… You’d probably say let me open the file and drag-and-drop it today.

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

    – Summarizes 1000s of rows within seconds.

    – Changes customized for specific cultures of report by just dragging and dropping.

    – Formats your report quickly.

    – Slices and dices your flat table by any category.

    – Allows you to add calculated columns.

    – No formulas needed (at least you have calculated fields).

    – Won’t consume enough memory resources.

    – Formats data able to be analyzed.

    – Enables you to connect with external databases: OLAP, SQL server, Access, etc.

    Listed here are the negatives of for you to not use Pivot Tables

    – Won’t permit you to understand the way to obtain values reported such as formulas (by pressing F2). Anyone desires to see the place that the data originated from so they can easily look into the formula.

    – Will not offer flexibility to arrange customized reports in cells.

    – Doesn’t refresh the outputs immediately when the backend list changes.

    – Clutters the workbook should there be dozens of little Pivot Tables everywhere.

    – Occupies space inside the worksheet.

    – Won’t offer easiness of moving the outcome through the worksheet.

    – Won’t allow to edit calculated fields directly in the cells.

    – Offers limited supported functions in calculated fields.

    Conclusion. I am 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 will be a sensible choice. Conversely, In case your input data is relatively static however, 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 and the limited functions supported within a calculated field result in the using formulas unavoidable.

    For additional information about

    use of pivot table in excel see our new internet page