Training Courses
Course Categories

  • Home

  • Financial Modelling in Excel (Intermediate)

Financial Modelling in Excel (Intermediate)

Canberra

$770.00

Training Course ID: (PS)-10018

Overview: 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.
You will:

  • Discover how to measure and interpret the performance of your company using Excel modelling
  • Create your own effective and reliable model and identify weaknesses and predict future performance
  • Gain an in-depth understanding of how to build a business case
  • Master key steps to get the most out of Excel functionality to improve your financial modelling
  • Learn how to enhance the decision-making process
  • Maximise your analytical abilities by learning conventional and new approaches of modelling
  • Translate business concepts into logically structured models and formats

Training Course Details

Duration
1 Day 9am - 5pm
TypePublic / Open
Provider

Plum Solutions

CPD0
Venue

TBA by Plum Solutions

VersionIntermediate

Outlines

Training Course Outlines:

Course content includes:

  • Model Tools
  • Choosing between Excel and Access
  • General Functions
  • Financial Functions
  • Other Useful Tools
  • Modelling Techniques
  • Rebuilding an inherited model
  • Bullet-proofing your model
  • Making a model user-friendly
  • Final Model Results
  • Scenarios and Sensitivity Analysis
  • Presentation of Model Output
  • The Fine Print

Outcomes

Training Course Outcomes:

  • Build a financial model from scratch, or modify and improve an inherited model
  • 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
  • Create 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
  • Present findings in a concise and meaningful way

Accreditations / Prerequisites
Course Accreditations:

Course 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 semi-regular basis, and are comfortable with using its basic tools and functions.

At minimum, it is assumed that participants will know how to:

•Navigate confidently in Excel
•Use absolute cell references (e.g. =$A$1)
•Create and use simple formulas
•Link between workbooks
This course builds on students' existing knowledge of Excel tools and functions and incorporates these into a financial model.

Related Courses

Related Courses:

41 visited

People Visited:

41 people visited

BOOK THIS COURSE

Select Dates

The training supplier is currently updating new course schedules, please contact the mytraining.net team to register your interest at team@mytraining.net or please call 02 8998 4940

Add Attendees (Min 1 and Max 10)




Attendees x 0

Add To Cart

Selected Course Date:

Course Attendees:

PRICE / Person:

$770.00

You have no items in your shopping cart.

Recently Viewed

  1. Financial Modelling for Valuations and M&A

  2. Financial Modelling for Mining Projects

  3. Financial Modelling for Mining Projects

  4. Financial Modelling for Mining Projects

  5. Finance for Non Financial Managers

Compare Courses

You have no items to compare.


Copyright © 2012 mytraining.net Pty Limited. ABN 90 139 474 070 All Rights Reserved.