Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

Is it more convenient to use MS Excel Pivot Table to prepare a financial statements?

user-image
Question ajoutée par Mohamed Hakeem Meerashahib , Branch Manager , Sri Lanka State Trading (General) Corporation
Date de publication: 2016/02/12
georgei assi
par georgei assi , مدير حسابات , المجموعة السورية

Pivot Table

Since that Microsoft added pivot tables for the first time one of the most attractive and frequently used Alkhais For users of Excel.

Pivot tables allow you to create groups and totals for whatever you want and imagine different arrangements for your data to be shown in a report in the form of an adjustable with ease tables and tables you can embed on any page you want to work or put it in a page independent work.

It uses the pivot table with the menus to display the data in easy access to the information as soon as meditation in the tables so-called pivot table report ... and is ideal for use during explaining the existing data in conferences and lectures, for ease amended.

Mahmoud Hamid
par Mahmoud Hamid , Finance Manager , Experts

For me it is more convenient and reliable to use table mapping and SUMIFS function to prepare financial statments.

Soumya  Raghunath
par Soumya Raghunath , Senior executive , Avt McCormick

first of all understanding the financial terms is what is necessary. pivot and excel are only the tools of representing the analysis made. 

 

Aslam Khan
par Aslam Khan , Senior Accounts Officer , Pakistan Software Export Board

you can use the pivot tables only for management reporting, in more advanced power query , power pivot and power can be used for advanced type of management reporting

 

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?