Financial Modelling Introduction 2: Absolute Cell Referencing and Formatting tips (1hr)

This course is presented online in a video lecture format. The duration is one hour. Once purchased you have access to the course for 12 months from the purchase date.

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 is a vital skill. 

Effective use of Fn 4 $$s for absolute cell referencing is an essential skill required to build a dynamic and flexible financial model. High quality formatting is also important, and cell styles provide an ideal way to achieve this.

On completion of this course, you will have a greater understanding of:

• The use of Fn 4 $$s for absolute cell referencing of column, row and both
• The use of cell styles for effective formatting in Excel

This course is authored by Dave Marlow. Dave 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. He is the Head of the Financial Modelling area at BPP within Professional Development.

CPD points = 1

A CPD certificate of completion will be provided by BPP Professional Education Limited upon successful completion of the online course.

Pass Assured Guarantee does not apply for this course.