Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Mohamed Hakeem Meerashahib , Branch Manager , Sri Lanka State Trading (General) Corporation
Date Posted: 2016/02/12
georgei assi
by 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
by Mahmoud Hamid , Finance Manager , Corp. Fin.

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

Soumya  Raghunath
by 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
by 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.