Calgary accountants, financial analysts, and finance managers who want more precision from Excel will find this course built specifically for their work. The financial functions that matter most in practice -- loans, investments, depreciation, cash flow analysis -- with examples drawn from real financial scenarios. 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.
