Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

What Excel skills are most valuable for finance and accounting?

user-image
Question ajoutée par Utilisateur supprimé
Date de publication: 2015/11/01
AHMAD AL-KHATEEB
par AHMAD AL-KHATEEB , Sr. Electrical Eng. , Engicon

Pivot tables are one of Excel's most powerful features.

RAUF ABDUL
par RAUF ABDUL , Business Analyst (FMCG & Manufacturing) , Exposures Finance

Financial modeling, some more advance excel like pivot table, v-lookup, graph,

Andreeas Stingaciu
par Andreeas Stingaciu , Pricing Specialist , Transguard Group LLC

When you work with large amounts of data knowing the basics like VLOOKUP, SUMIF, complex IF functions, Subtotals, Conditional Formatting, Pivot Tables would help you properly consolidate your results. Presenting them in a nice and easy to understand way would be key.

AHMED ZAIN ABDULLAH ALHABSHI
par AHMED ZAIN ABDULLAH ALHABSHI , محاسب عام للشركة , مجموعة بن لادن السعودية

one of most valuable for finance and accounting

sort &filter you can by this arrange data so that it's easier to analyze

Haitham EL sayed Ahmed Ali Abd El Aal
par Haitham EL sayed Ahmed Ali Abd El Aal , Regional Warehouses Supervisor , شركه عبد الرحمن سعد الراشد واولاده المحدوده (ARTAR)

Contrary to the initial basics of Excel must To be a good practitioner knowledge and to be very good and be familiar with the function and most importantly how to use the function well where that knowledge functions tasks is not everything, but more importantly know how to employ them properly

Hanan Hanif Qureshi
par Hanan Hanif Qureshi , Chief Financial Officer , Experts Group

other than having basic knowledge in the Excel formulas and functions, one must have skill to build the logical formulas to make decisions and conclusions, full knowledge of importing external data and other tables, use of pivot tables, knowledge of Lookup and index formulas, presenting financial data using charts. Learning of Financial Functions inside the Excel Function Library is very essential.

Ravin Mangtani
par Ravin Mangtani , sales operations supervisor , PORCELLAN CO. LLC

The formulas. You should have complete knowledge of all the formulas in Excel for eg. Addition, Subtraction, percentile etc.

Bishan Jamwal
par Bishan Jamwal , Finance Manager , G4S Qatar WLL

Use of formulae that helps in saving time to produce analytic reports to present to Management. 

Utilisateur supprimé
par Utilisateur supprimé

Mathematics formula & functions the equal sign is the lead focus.

Mohammed Shahsad
par Mohammed Shahsad , Freelance Travel Consultant , Freelancing

In my view, an accountant doesn't only operates Erp software they should also have experience in operating MS excel. Excel keeps track on finance out from Erps. So that it's easy to work with.

More Questions Like This