ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Mohamed Hakeem Meerashahib , Branch Manager , Sri Lanka State Trading (General) Corporation
تاريخ النشر: 2016/02/12
georgei assi
من قبل 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
من قبل 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
من قبل 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
من قبل 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

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟