Designed for Ottawa accountants, financial managers, and analysts who want to extract more value from Excel. This course focuses on the financial functions that matter most in professional practice -- loans, investments, depreciation, and cash flow analysis. Practical examples drawn from real financial scenarios throughout. Prerequisite: Excel Level 1
» determining monthly payments for a loan
» creating an amortization table for a mortgage
» computing present and future value for a series of payments or amounts
» calculating internal rate of return for cash flows
» calculating the number of months to pay off a loan
» calculating imputed interest rate
» building a 1- or 2-dimensional What-If table for financial terms such as payments, present value, etc.
Also, if you’re connected to the audit profession, Audit Data Analytics may be of particular value. ADAs can enhance the traditional sampling techniques used in audit examinations.
