0 Items Total: $0

Advanced Excel and Financial Modelling

Advanced Excel and Financial Modelling
Advanced Excel and Financial Modelling
Advanced Excel and Financial Modelling
Learn financial modeling using advanced excel tools

A sound financial model is essential to understand the drivers and implications of business decisions. PwC's Academy three day Advanced Excel and Financial Modeling course covers the fundamental skills needed to utilise Excel to the best effect and then illustrates these skills in the context of developing best practice financial models.

CPE Credits
18
CPE Credits
Days
3
Days
Advanced Excel and Financial Modelling

In this three day course, delivered by subject matter experts with practical industry and training experience, participants will learn key tools of Excel useful for business analysis and practice how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).

Advanced Excel and Financial Modelling

This course adopts a case study approach and minimising the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.

Advanced Excel and Financial Modelling

The course is suitable for professionals working or aspiring to work in the field of investment banking, project consultancy, private equity, corporate finance, asset valuation and equity research. It is of particular benefit to corporate and project financiers, finance managers, accountants and bankers.

Want to run this in-house?
Course structure

Improving efficiency by using Basic excel tools and shortcuts

Excel fundamentals refresher

Customising Excel

Useful tools in Excel for financial modelling such as:

  • IF
  • AND OR
  • OFFSET
  • Named ranges
  • MAX
  • MIN
  • ABS

Basic structure of a model

Financial statements refresher

Model design and consideration of inputs

orecasting EBITDA

Integrity of financial model

Including checks and balances

Forecasting working capital

Forecasting capex and depreciation

Forecasting financing flows

Trouble shooting circularity problems

The camera function

Sensitivity analysis

Charting the results

Creating impressive output

Schedule
Schedule

There are no scheduled dates for this course. Fill out the form to check future dates or deliver the course in-house

Trainers
Frequently asked questions

Enquire now