3 hour Excel & Word Sessions | Beginner to Advanced
£100pp (excl GST)

Open Courses

Book nowBook now

We can create content for Inductions,
Micro Learning modules and Training Videos

eLearning

Find out moreFind out more

3 fully equipped rooms
£45 per hour | Daily rates available

Room Hire

Find out moreFind out more

Inductions | In-house systems
Support | Project Work

Consultancy

Find out moreFind out more

Inductions | Migrations
New Processes | Best Practice

Systems Training

Find out moreFind out more
ALX Training / Excel / Excel – Financial Formulas

Excel – Financial Formulas

Audience

For individuals who need to write or trouble-shoot financial formulas in Excel

Outcomes

You will be able to calculate valuations, interest rates, number of payments, growth rates, future & present values, debt repayments and depreciation.

Course Content

Calculating Present Values (PV), Calculating Future Values (FV)
Calculating the Number of Periods (NPER)
Calculating Payment Values (PMT, PPMT, IPMT)
Calculating interest rate (RATE)
Use the Goal Seek tool to find unknown values
Insert a two-way Data Tables to visual a sliding scale of variables
Calculate different depreciation rates
Write, nest and edit ROUND, ROUNDUP, ROUNDDOWN, CEILING & FLOOR formulas
Use Data formulas such as EDATE, EOMONTH, NETWORKDAYS, WORKDAY, TODAY & NOW

Duration

3 hours with lots of hands-on practical exercises

Prerequisites

Must be a confident Excel user, with a good understanding of financial principles

Price

£435 including the hire of 8 laptops

Includes

  • All training spreadsheets for future practice
  • Full-colour booklet to accompany the lesson

[contact-form-7 404 "Not Found"]
SUBMIT

Contact

Fill out the form below to discover how ALX Training can help you:

    Or talk to us directly...

    +44  1534 873785
    +44  7797 774676
    [email protected]

    Hilary House
    19 Hilary St
    St Helier, Jersey
    JE2 4SX