FormulaGym
XP 0
Streak 0

Excel functions for finance

Finance work in Excel comes down to a handful of jobs: totalling, comparing against a budget, matching codes to names and keeping numbers tidy. These are the functions that cover them.

Typical jobs

  • Total spend by team, category or month
  • Flag invoices that are over budget
  • Match account codes to account names
  • Round prices and tax so totals agree with invoices

13 functions to learn

Other jobs