Financial modelling introduction 3: Logical statements and lookups online course

Financial modelling is becoming an increasingly important skill in an economic environment characterised by ever more uncertainty: the ability to use Excel to predict what the financial performance and position of a business or venture might look like in the future, depending on particular assumptions and estimates.

Effective use of logical statements is an essential skill required to build a dynamic and flexible financial model. The ability to lookup particular data items is also important and this course covers a number of different ways of doing this.

Price: £35 + VAT

Book now with BPP

What you will gain

This course explains the effective use of logical statements to build a dynamic and flexible financial model, along with ability to lookup particular data items.

Course content

By the end of this course, you will have a greater understanding of:

• the use of logical statements (IF/AND/OR) to model conditions
• the use of lookup functionality (V/H Lookup, Match, Index. Offset) to select particular data

Questions?

BPP | Tel: 0330 060 3303 | Email: ldicas@bpp.com