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

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

متابعة

What are the most important excel formulas that the financial analyst should use especially in budgeting and financial reporting?

user-image
تم إضافة السؤال من قبل Ali Al Aqrabawi CFM , Program Budget , The United Nation
تاريخ النشر: 2017/01/23
Rahyan Opimo
من قبل Rahyan Opimo , General Accountant , Energy Solutions

Functions like  sum, average, count, sumif , hlookup and vlookup are very useful. Pivot & sub-totals will make summarizing data easier and faster. You can use graphs as well for improved reports presentation.

Vikram Zanwar
من قبل Vikram Zanwar , Head of Business Budgeting and Planning , GBI QSTP

Important basic formulas are Vlookup, Hlookup, sumif, match function

Other might have significant use like index function, Goal-seek function, Average, ABS,indirect, FV 

DINESH CHAUDHARI
من قبل DINESH CHAUDHARI , Finance Manager-Corporate , Neelkamal group of Companies

Pivot Table, Vlookup and Sumif

مستخدم محذوف‎
من قبل مستخدم محذوف‎

Nice question, Excel formulas are similar to Lego that can be reshaped depending on a situation. Yet at a basic level to be able to work with Excel at analyst level you should know indexing (advanced vlookup), conditional functions with nested formulas, logical functions. At processing level it is important to work with pivot and data models. Knowing visual basic and macros is sure a great plus. But for a daily basis the above mentioned can help you manipulate data from different sheets and workbooks. At a start, I would advise to build on formulas and learn there different usages especially for Date functions. Hopefully this answered your question.

shabeeb pk
من قبل shabeeb pk , Finance Officer , MEDEOR 24x7 INTERNATIONAL HOSPITAL LLC

As far as a financial analyst concerned, There is some intermediate function in excel for the the smooth functioning of financial reports such as VLOOKUP, HLOOKUP, pivot table and graph, $ symbols, Macros etc.. .

Ahmed Talal  Arif
من قبل Ahmed Talal Arif , Financial Affairs Manager , Astranova Tarim Ticaret Ve Sanayi A.S.

There are no standard and it depends on the expertise of the preparer and the size of working papers. In my opinion better are the ones which can help any user to identify the flow of figures, the links for helping the user to reach to the base or data figures.

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