Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Functioning of financial tables, which are useful financial analysis and what distinguishes the existence of equations providing the time and effort
1. Pivot Table
2. VLOOKUP
3. HLOOKUP
4 Autosum
Pivot Table
countif
ifblank
subtotal
vlookup
1) sum (=sum)
2) Average
3)Equal to
4)If
5)count
6)countif
7)pmt
8)Rate
9)Nper
10) PV (present value)
11) FV (Future Value)
Thanks for the invitaion
Following are essential:
1) Vlookup and Hlookup
2) Macros
3) Excellent grip of shortcuts
4) Pivot Tables
5) Data Manipulation
6) IF, AND and OR formulas
All the excel functions are mostly used in Finance and Accounting. Microsoft has designed it only for the purpose.
Pivot table
Auto sum
V look up
H look up
If formula
Macros
Excel spreadsheets are the most common and indispensable tool used by accountants, enabling them to analyse, report and share financial information. Much of this can be accomplished using only a fraction of the wealth of functions and options within the Excel program.
Basic arithmetic, the SUM() function and some cell border formatting will let you produce useful models and perform some quite complex calculations. By expanding your knowledge with just a few other functions, Excel can become a much more versatile tool. Very occasionally Excel does not contain a function that you may expect, and it is necessary to combine other functions to perform tasks such as calculating weighted averages.
thanks for the invitation
Professors also prefer the previous answers
Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?