Accountant Formulas

Which formulas accountants used the most?

Accountants use number of formulas to perform the activities of data matching, reconciliation, analysis, reporting and etc.

This post list down the most important formulas to successfully perform an Accountant job in IT environment.

To gain an in depth knowledge about these formulas and how to use them, you can search these formulas on internet.

Accountant Formulas and functions List

  • SUM,SUMIF, SUMIFS, SUMPRODUCT
  • COUNTIF, COUNTIFS,COUNTA
  • VLOOKUP,HLOOKUP, LOOKUP, INDEX and MATCH , CHOOSE
  • IF, IF with  And, IF with Or
  • LEFT, RIGHT, MID, SEARCH, FIND, LEN
  • INDIRECT FUNCTION
  • OFFSET
  • CONCATENATION
  • TEXT
  • TRIM
  • SUBSTITURE
  • IFERROR
  • ISERROR,ISBLANK,ISNA,ISNUMBER,ISTEXT
  • DAY, MONTH, YEAR, DATE, NOW
  • COLUMN,COLUMNS, ROW,ROWS
  • AVERAGE,SUBTOTAL,SUM
  • MAX,MIN
  • ROUND
  • GETPIVOTDATA

 

Contact Us

Learn Excel Tricks
Email: info@learnexceltricks.com