• Qvist Gibbons posted an update 1 year, 6 months ago

    The fact is that every user who may have learned to work with PTs have seen a huge boost in their productivity. Not only due to speed of producing reports but with the quick insights you can find from large data sets.

    In case you present a study of Sales by Product and also by Region and someone inquire, what if… You’ll say i want to open the file and drag-and-drop it at this time.

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

    – Summarizes thousands of rows quickly.

    – Changes the layout of report simply by 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 employ calculated fields).

    – Won’t consume enough memory resources.

    – Formats data able to be analyzed.

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

    Allow me to share the cons of why you need to not use Pivot Tables

    – Does not permit you to begin to see the method to obtain values reported as in formulas (by pressing F2). Anyone really wants to see the place that the data came from to enable them to easily check the formula.

    – Will not offer flexibility to set up customized reports in cells.

    – Won’t refresh the outputs immediately once the backend list changes.

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

    – Occupies space within the worksheet.

    – Will not offer easiness of moving the outcomes throughout the worksheet.

    – Does not allow to edit calculated fields directly from 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 looking for what-ifs calculations by changing the inputs, data Lookup formulas will be a good option. Conversely, If the input details are relatively static however you wish to accomplish what-if analysis with drill-down, then Pivot Tables are a good 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 inside a calculated field make the use of formulas unavoidable.

    Check out about

    use of pivot table in excel browse this popular webpage