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
i-Cornerstones Learning and Performance Model
Creating the right learning programme for you

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, retention and consistent gains in profit.

Our i-Cornerstones Learning & Performance Model is dynamic, flexible framework that outlines the TrainingU philosyphy 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.

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.

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.

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.

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.

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?

TrainingU will not pass your contact details onto any third parties, and will only contact you in relation to your enquiry.

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