Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the advantage in using pivot table for you financial reports?

user-image
Question ajoutée par Salah Elsheikh
Date de publication: 2014/01/15
Umair Butt
par Umair Butt , Senior Accounts Supervisor at Site , Al Hosn Gas

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.

 

Utilisateur supprimé
par Utilisateur supprimé

Pivot tables can be used for all MI reports as they can quickly categorise ang group similar transactions from extremely large amounts of raw data. They are even better used alongside macros and VBA in order that the same reports can be run regularly without needing to create the pivot tables over or change data sources for fresh information.

Ahmed Saeed
par Ahmed Saeed , Supply Chain and Purchasing Manager , Tuff Gear Ltd.

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.

 

Jazir Thahir
par Jazir Thahir , Executive Secretary , Al Farida Beauty Intl Co. (PUIG)

Main Advantage is that it makes the report you are preparing more understandable to which you can take a quick decision.

Sanoop Kumar V G
par Sanoop Kumar V G , financial controller , Africana Discount Hypermarket

By using Pivot table we can make comparison report ,monthly report ,branch wise report ..We can make lot of analysis report 

More Questions Like This