Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Pivot tables are essentials and useful in compiling the report as per your own needs and requiremnts and save a lot of time that was spent on formatting the files.
Preparing almost any statement by combining the power of a classified list and a Pivot Table is such an easy and smart thing to do. You can use pivot tables for analyses of the financial reports. Excel Pivot Tables will quickly identify errors in a set of serveral thousand accounting records, then print financial and departmental profitability reports. All of this cam be done within a fraction of the time the same tasks would take using conventional methods.
Main Advantage is that it makes the report you are preparing more understandable to which you can take a quick decision.
By using Pivot table we can make comparison report ,monthly report ,branch wise report ..We can make lot of analysis report