Excel Function Reference for Accountants
Excel is a tool for logic, not just math. This library covers the exact formulas you will use daily to organize, check, and summarize financial data.
Lookup & Reference
- VLOOKUP: Finds a value in a table by matching a key. Used to pull data from a master chart of accounts or price list.
- INDEX & MATCH: A more flexible alternative to VLOOKUP that doesn't care about column order.
Logic & Conditionals
Financial & Math
- SLN / SYD / DDB: Standard financial functions for calculating depreciation over an asset's life.
- PMT / IPMT / PPMT: Calculates loan payments, separating principal from interest for amortization schedules.
- ROUND: Keeps financial figures accurate to two decimal places, preventing rounding errors in trial balances.
Text & Data Prep
- TRIM / LEFT / RIGHT: Cleans messy imported bank data by removing extra spaces or extracting specific account codes.