Accounting & Finance

Accounting & Finance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Business Management

Discover business management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Business Process Improvement

Business Process Improvement Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Legal & Compliance

Legal & Compliance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Marketing & Advertising

Discover marketing & digital marketing training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Procurement & Purchasing

Procurement & Purchasing Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Real Estate Management

Real Estate Management Training Courses Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart Building Services | Property Development | Property Asset Management | Retail Property Management | Operations and Facilities Management | Property Investment

view coursesgroup bookings

Sales Training

Discover sales training courses and in-class open programs in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Supply Chain Logistics

Supply Chain Logistic Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Workplace Health & Safety

Workplace Health & Safety Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

IT Technical & Computer

Discover IT and computer training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Personal Development

Personal Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Training & Facilitation

Training & Facilitation Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Training by Industry

Industry Specific Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

First Aid Training

Discover first aid training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Certificates & Diploma

Certificates & Diploma Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Communication Skills

Discover communication skills training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Customer Service Training Courses

Discover customer service training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Government / Public Sector

Government / Public SectorTraining Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

TOP CATEGORIES

Government

Human Resources

Discover human resources training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Leadership Development

Discover leadership development training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Management Training

Discover management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

People Development

People Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

ACT - Australian Capital Territory

Book all your Corporate & Government Training Courses in Canberra ACT Australia | Short In-house In-Class Room Open Programs Software

view coursesgroup bookings

TOP CATEGORIES

Canberra

NSW - New South Wales

Book all your Corporate & Government Training Courses in New South Wales NSW Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

NT - Northern Territory

Book all your Corporate & Government Training Courses in the Northern Territory, NT Australia

view coursesgroup bookings

TOP CATEGORIES

Darwin

QLD - Queensland

Book all your Corporate & Government Training Courses in Queensland, QLD Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

SA - South Australia

Training Reservations for Training Courses, Development Programs, Software Programs in South Australia

view coursesgroup bookings

TAS - Tasmania

Training Reservations for Training Courses, Development Programs, Software in Tasmania, Australia

view coursesgroup bookings

TOP CATEGORIES

Hobart

VIC - Victoria

Corporate & Government Training Courses in Victoria (VIC) Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

WA - Western Australia

Book all your Corporate & Government Training Courses in Western Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

Auckland

Training Reservations for Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Auckland, New Zealand

view coursesgroup bookings

Christchurch

Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Christchurch, New Zealand

view coursesgroup bookings

Dunedin

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Dunedin, New Zealand

view coursesgroup bookings

Hamilton

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Hamilton, New Zealand

view coursesgroup bookings

Palmerston North

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Palmerston North, New Zealand

view coursesgroup bookings

Wellington

Training Reservations for Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Wellington, New Zealand

view coursesgroup bookings
Plum Solutions
Availability: BOOK NOW
more info

Financial Modelling in Excel

(PS)-00003

Brisbane

$880.00per person

1 Day, 9:00am - 5:00pm

Public / Open

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.
    Financial Modelling Theory & Best Practice
  • Overview of Financial Modelling
  • Model Design, planning and steps in building your model
  • Upgrading from Excel 2003 to 2007 or 2010
  • The technical, design, business and industry knowledge required for financial modelling
  • Purposes of financial models


  • Model Tools & Functions
  • Which formula or tool is most appropriate in which modelling situation?
  • Selecting the correct formula

  • Adjusting formulas manually


  • Named ranges
  • Applying absolute and relative cell referencing and it’s importance in Financial Modelling
  • Use of LOOKUP functions, aggregation functions such as SUMIFS, COUNTIFS and nested formulas within a financial model and others
  • How to model compounding inflation
  • Calculating customer acquisition numbers from the potential pool of customers
  • Modelling market penetration in a business case



  • Financial Functions
  • IRR (Internal Rate of Return)
  • NPV (Net Present Value)
  • How to calculate a payback period


  • Modelling Techniques
  • What makes a good model?
  • Best practice in financial modelling
  • Attributes of a good model such as user-friendly and structural features


  • Practical Exercise: Build an individual business case using a range of financial functions and tools utilising best practice financial modelling techniques.

    Error Prevention
  • Modelling techniques and strategies to reduce potential for error
  • Identifying and correcting common errors

  • Avoiding error displays in formulas
  • Creating in-built, self-balancing error checks and error alerts


  • Other Useful Tools
  • Hiding sections of the model
  • Using Goal Seek within Financial Models
  • Macros and Financial Modelling
  • Pivot tables and their use in Financial Modelling


  • Rebuilding an inherited model
  • Formula auditing
  • ""Sense-checking"" methodology
  • Identifying formula error
  • Dealing with links and the potential errors they can cause


  • Bullet-proofing your model
  • Protect data by locking cells
  • Password Protection
  • Restricting incorrect data entry with data validations
  • Using worksheet protection to prevent entry
  • Protecting your file using “Read Only” and password protection
  • Retain model integrity and prevent misuse of your model by learning to restrict incorrect inputs


  • Making a model user-friendly
  • Formatting
  • Inserting Navigation buttons
  • Hyperlinks


  • Scenarios and Sensitivity Analysis
  • Manual sensitivity analysis
  • Creating drop-down switches for scenario selection
  • Adjusting inputs variables to impact outcomes
  • What-if analysis
  • Stress-testing


  • Practical Exercise: Create a best, base and worst case scenario on your model. Select from the drop-down box and watch the results change

    Assumption Documentation
  • Why document assumptions?
  • Linking to source referencing
  • Importance of assumptions when assessing risk
  • Mitigate liability by including appropriate caveats and key assumptions


  • Presentation of Model Output
  • Summarising results and display of findings
  • Communicate the results of your model clearly and concisely whilst getting the key message across to the audience
  • Summarising key assumptions, documentation and source referencing
  • Writing operation instructions
  • Summarising model data into a presentation"
    You will learn how to:
  • Build a financial model from scratch, or modify and improve an inherited model

  • Select the most appropriate formula to achieve the desired outcome

  • Identify common errors in modelling

  • Mitigate errors by building in error checks

  • Prevent incorrect use of your model by protecting worksheets

  • Validate data entry by setting data entry parameters

  • Create a navigation page to help users find their way around your model

  • Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected

  • Mitigate liability by providing assumptions

  • Write instructions for use

  • Gain an in-depth understanding of how to build a business case

  • Communicate the results of your model clearly and concisely"

Prerequisites:

Prerequisites The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a regular basis, and are comfortable with using its tools and functions. At minimum, it is assumed that participants will know how to: • Navigate confidently in Excel • Create and use formulas • Link between workbooks • Build a basic chart

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.
    Financial Modelling Theory & Best Practice
  • Overview of Financial Modelling
  • Model Design, planning and steps in building your model
  • Upgrading from Excel 2003 to 2007 or 2010
  • The technical, design, business and industry knowledge required for financial modelling
  • Purposes of financial models


  • Model Tools & Functions
  • Which formula or tool is most appropriate in which modelling situation?
  • Selecting the correct formula

  • Adjusting formulas manually


  • Named ranges
  • Applying absolute and relative cell referencing and it’s importance in Financial Modelling
  • Use of LOOKUP functions, aggregation functions such as SUMIFS, COUNTIFS and nested formulas within a financial model and others
  • How to model compounding inflation
  • Calculating customer acquisition numbers from the potential pool of customers
  • Modelling market penetration in a business case



  • Financial Functions
  • IRR (Internal Rate of Return)
  • NPV (Net Present Value)
  • How to calculate a payback period


  • Modelling Techniques
  • What makes a good model?
  • Best practice in financial modelling
  • Attributes of a good model such as user-friendly and structural features


  • Practical Exercise: Build an individual business case using a range of financial functions and tools utilising best practice financial modelling techniques.

    Error Prevention
  • Modelling techniques and strategies to reduce potential for error
  • Identifying and correcting common errors

  • Avoiding error displays in formulas
  • Creating in-built, self-balancing error checks and error alerts


  • Other Useful Tools
  • Hiding sections of the model
  • Using Goal Seek within Financial Models
  • Macros and Financial Modelling
  • Pivot tables and their use in Financial Modelling


  • Rebuilding an inherited model
  • Formula auditing
  • ""Sense-checking"" methodology
  • Identifying formula error
  • Dealing with links and the potential errors they can cause


  • Bullet-proofing your model
  • Protect data by locking cells
  • Password Protection
  • Restricting incorrect data entry with data validations
  • Using worksheet protection to prevent entry
  • Protecting your file using “Read Only” and password protection
  • Retain model integrity and prevent misuse of your model by learning to restrict incorrect inputs


  • Making a model user-friendly
  • Formatting
  • Inserting Navigation buttons
  • Hyperlinks


  • Scenarios and Sensitivity Analysis
  • Manual sensitivity analysis
  • Creating drop-down switches for scenario selection
  • Adjusting inputs variables to impact outcomes
  • What-if analysis
  • Stress-testing


  • Practical Exercise: Create a best, base and worst case scenario on your model. Select from the drop-down box and watch the results change

    Assumption Documentation
  • Why document assumptions?
  • Linking to source referencing
  • Importance of assumptions when assessing risk
  • Mitigate liability by including appropriate caveats and key assumptions


  • Presentation of Model Output
  • Summarising results and display of findings
  • Communicate the results of your model clearly and concisely whilst getting the key message across to the audience
  • Summarising key assumptions, documentation and source referencing
  • Writing operation instructions
  • Summarising model data into a presentation"
    You will learn how to:
  • Build a financial model from scratch, or modify and improve an inherited model

  • Select the most appropriate formula to achieve the desired outcome

  • Identify common errors in modelling

  • Mitigate errors by building in error checks

  • Prevent incorrect use of your model by protecting worksheets

  • Validate data entry by setting data entry parameters

  • Create a navigation page to help users find their way around your model

  • Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected

  • Mitigate liability by providing assumptions

  • Write instructions for use

  • Gain an in-depth understanding of how to build a business case

  • Communicate the results of your model clearly and concisely"

Prequisites:

Prerequisites The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a regular basis, and are comfortable with using its tools and functions. At minimum, it is assumed that participants will know how to: • Navigate confidently in Excel • Create and use formulas • Link between workbooks • Build a basic chart

Plum Solutions

Plum Solutions delivers training in the following course categories

  • Financial Modeling
  • Financial Services

Plum Solutions Training Courses and Open Programs in Sydney, Melbourne and Brisbane, Australia.

Short Courses and In-House Training Programs:

With Training Courses available in these categories:

Financial Modelling | Budgeting & Forecasting | Business Cases & Pricing Models | Data Analysis

Call us to book on 1300 768 368

Need Approval?