Training: Excel – Formulas and functions for financial management

Module 1: Financial functions

• Use the financial functions: VPM(), NPM(), RATE()
• Use the amortization functions : AMORLIN(), AMORDEGRC()
• Use the Consolidate function

Module 2: Stock Market Charts

• Organize your data to create a stock chart
• Create a stock chart
• Set up and format a chart

Module 3: Forecasting

• Designing an assumption table
• Use the Scenario Manager
• Analyze data with the solver
• Manage variable and target cells, constraints, results
• Create a forecast sheet