What are the most important Excel functions for accounting & finance?

• VLOOKUP. Make sure that they also know how to do this when looking up based on more than one field (e.g. First Name, Last Name, Month).
• INDEX and MATCH. Vlookups are a bit faster to write, but index match gives you a lot more flexibility in certain situations.
• Separating input data from calculations. Each input data source should be pasted in directly as received, all calculations should be done in other sheets (using vlookup/index match to pull in the data)
• IF, AND, OR every user needs to know how to use these basic conditional logic formulas.
• Pivot Tables
• Named Ranges
• Making charts that combine multiple types (e.g. a line graph overlayed on a  bar chart, clustered bar charts, )
• Array Formulas (e.g. SUM of profit on all deals worth more than $1m usd where the buyer is from China)
• Custom number formats (e.g. making show up as "$3.0 million")
• Conditional Formatting
• Special types of paste (paste link, paste values, paste formats, etc)
• Doing almost everything with keyboard shortcuts
• Text-To-Columns (To parse flat text files)

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. 

I SEE THAT ALL FUNCTIONS OF EXCEL IS VERY IMPORTANT FOR ACCOUNTING

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