Financial Modelling in Microsoft Excel

Financial Modelling in Microsoft Excel

Duration:
1 Day
Objectives:

On completion of this course delegates will;

  • Be able to build financial models based on best practise modelling principles.
  • Be able to build models that are easily understood and easy to share with others.
  • Understand the key issues surrounding building financial models.
  • Be able to conduct a variety of sensitivity and scenario analyses.
  • Have seen and used a wide variety of Excel functions and tools.
  • Be able to produce flexible models for producing periodic statements.

Pre-requisites:

A basic knowledge of Excel spreadsheets is required, ideally with some practical experience of model building.

What will I learn?
Modelling Principles
  • - Model structure, formatting and best practises
  • - Using range names
  • - Maximising flexibility
  • - Using tables
  • - Creating, editing, finding and maintaining links between workbooks
  • - Building larger models
  • - Auditing
  • - Creating charts
  • - Shortcuts
Data Analysis
  • - Financial functions – SUM, SUBTOTAL, NPV, IRR, XIRR etc.
  • - Lookup functions – INDEX, VLOOKUP, HLOOKUP, MATCH, OFFSET etc.
  • - Text functions – LEN, FIND, LEFT, RIGHT, MID, TRIM etc.
  • - Database features – functions, reporting, filtering, extracting, Pivot Tables
  • - Circular references
Management Tools
  • - Goal Seek
  • - Solver
  • - Scenarios
  • - Introduction to Macros (VBA)
  • - Introduction to User Defined Functions using VBA
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot
icornerstones
Creating the right learning programme for you
i-Cornerstones Learning and Performance Model

Our approach is to provide the skills and knowledge to increase productivity and achieve attitudinal and behavioural change, leading to long-term improved performance, increased employee engagement and retention.

Our i-Cornerstones Learning & Performance Model is a dynamic, flexible framework that outlines the TrainingU philosophy and key stage processes we work through to ensure we deliver the exact learning programme for your needs and within your budget.

Read more...

icornerstones

How we deliver learning
Your Offices (in-house)
Your Offices
(in-house)

If you have a number of people in your organisation with the same training need, in-house training programmes are an ideal, collaborative learning solution.

Find out more...
Our Training Venues
Our Training
Venues

Ideal for single/few staff member(s) that need development in a certain area. Sharing ideas and experiences with people from other organisations can be a huge benefit.

Find out more...
Virtual Learning
Virtual
Learning

Enabling staff to join live classroom training via web conferences. Ideal for organisations with multiple offices or where staff are geographically spread.

Find out more...
Sprint Learning
Sprint
Learning

High impact 90-minute training sessions delivered either face-to-face or virtually in targeted subjects, to boost performance whilst reducing your staff time out of the business.

Find out more...
Managed Learning Services
Managed
Learning Services

As an extension to your in-house L&D team, we will look after all the planning and organisation of your staff training needs, from assessment of needs through to delivery and evaluation.

Find out more...
Our commitment to quality

We are an accredited training provider with the Learning and Performance Institute which gives you the assurance that we conform to a professional Code of Practice.

Learning and Performance Institute
Contact Us


If you need any help with finding
the best course for you, please call us on

0333 344 6630


How did you hear about us?
I would like to receive details of your news, offers and promotions

We are collecting your contact details to enable us to answer your enquiry about our services. To see our detailed Privacy Policy, please click here