Financial and Accounting Functions in Excel
Lookup, conditional and aggregation functions, plus loan, depreciation and time-value-of-money functions.
Course contents
- 1Lookup functions: VLOOKUP, XLOOKUP and INDEX/MATCH
- 2Conditional and aggregation functions: IF, SUMIFS and COUNTIFS
- 3Loan and time-value-of-money functions
- 4Depreciation functions
- 5Date and text functions
What you gain from the course
You can pick the right function for each accounting problem and combine functions into advanced formulas.
Other courses in the same track
Basic level
Excel from Zero to Advanced
From the interface and formatting to formulas, functions, tables and charts.
30 training hours
Excel for Accountants
Everyday Excel in accounting work: entries, balances, reconciliations and reports.
24 training hours