Book Nowbook-now

Finance Skills

What do you want to learn today?

We have selected the following short online courses to enhance your finance skills. Courses are 1-2 hours long, but the effect will last a life-time. We believe, once you know better, you can do better.

Financial Modelling √Źntroduction 3: Logical Statements and Lookups

Overview:

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.
 
CPD Points: 1

CPD Duration (hours): 1
 
Access: 12 months from purchase date
 
Price: 425

Learning Outcomes:

On completion 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

Authored by: Dave Marlow

Dave Marlow has a wealth of experience training city professionals in all areas of financial modelling, accounting and financial analysis.
 
Dave qualified as a chartered accountant with PricewaterhouseCoopers. He then joined the PwC Training Consulting practice, helping PwC clients implement their finance change initiatives with related training programmes.
 
Dave is the Head of the Financial Modelling area at BPP within Professional Development.
 
A CPD certificate of completion will be provided by BPP Professional Education Limited upon successful completion of the online course.

Get a quote

Course Enquiry


Subscribe to our newsletter

We'll only send you good stuff

Lecturers for this Course

Farai Jambaya
 P1 Performance Operations, Sandton...
Read More
Nafisa kistan
 E2 Project and Relationship Managem...
Read More