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

Email BPP to book

BPP are currently in the process of moving to a new online system and therefore we ask in the interim that you email BPP (using the booking button above) to book your online course.

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