ALX Training / Excel / Excel: Financial Formulas

The Need:

To use formulas to calculate valuations, investment opportunities, compounding interest, savings & repayment plans
To calculate capital & interest payments
To round & depreciate values using Excel

You will learn how to:

Use PV, FV functions for present and future values
Use PMT, PPMT & IPMT functions relating to payment values
Use NPER and RATE functions for periods and interest rates
Use the Goal Seek tool to find unknown values
Write, nest & edit all ROUND formulas
Use Date formulas such as EDATE, EOMONTH, NETWORKDAYS, WORKDAY, TODAY & NOW

Logistics:

The course can be delivered online or face to face in our training centre or at your place of work. If you would like to have this class online, you will need access to two screens, a webcam, speakers & a microphone

Prerequisites:

You need to be familiar with content covered in The Essentials

Includes:

All training spreadsheets for future practice
A copy of the presentation with answers in the notes section.

Cost:

£479 for up to 6 delegates
£79.83 for each additional place