Financial Modelling in Excel Training courses in Financial Modelling

Financial Modelling in Excel Training courses in Financial Modelling

  • EY Client Portal
  • Library
  • About us
    • Our values
    • Our global approach
      • Our leaders
      • Global review
    • Entrepreneurship
      • Entrepreneur Of The Year
    • Our people and culture
      • Diversity and inclusiveness
      • Our history
      • Our awards
    • Our sponsorships and programs
    • Our alliances
    • Corporate responsibility
    • EY/Ethics hotline
  • Newsroom
    • News releases
    • PR contacts
    • Analyst relations
    • Facts and figures
  • Connect with us
    • Email alerts
    • Mobile applications
    • Social media
    • Webcasts/podcasts
  • United Kingdom (English)
    Location selector

    Global (English)

EY Ernst Young logo
  • Home
  • >  Services
  • >  Transactions
  • >  Valuation, Modelling & Economics
  • > Our courses
EY Financial Modelling Training - Our courses on offer

Our courses

Financial Modelling Training

  • Overview
  • Our courses
  • How we work with you
  • Why use us?
  • Upcoming public courses
  • Share

All of our courses last 1 or 2 days and are conducted in a classroom format

Our courses are aimed at both intermediate and experienced staff – it is expected that all participants will have a good grasp of Excel prior to attending our courses. Whilst our introductory courses are considered suitable for intermediate users of Excel, all our courses will also suit more seasoned modellers who may be looking to refresh their modelling skills or gain some new insights on model building approaches.

Course outlines with detailed information on content, format, target audience and prerequisites are below.

Each course provides a well-balanced mix of theory and practical exercises, and aims to provide an understanding of how to construct an integrated income statement, balance sheet and cash flow model from start to finish. Calculations cover revenues, operating and maintenance costs, capital expenditure, depreciation, debt and equity financing, taxation and key output measures suited to the relevant industry or transaction. The models are built according to our principles of best practice. They are dynamic in nature, with the ability to run different scenarios and adjust key event timings.

2 Day courses

Course

Detailed outline

Introduction to Financial Modelling

Download PDF(756KB) as a printable document

Modelling for M&A

Download PDF(770KB) as a printable document

LBO Modelling

Download PDF(828KB) as a printable document

Modelling for Project Finance

Download PDF(763KB) as a printable document

Introduction to DCF modelling

Download PDF(802KB) as a printable document

 

1 Day courses

Course

Detailed outline

Best Practice workshop

Download PDF(1.21MB) as a printable document

Introduction to Visual Basic

Download PDF(349KB) as a printable document

Reviewing Models Download PDF(353KB) as a printable document

Connect with us

Stay connected with us through social media, email alerts or webcasts.

null

Subscribe to our Financial Modelling Training Newsletter

Receive our free monthly newsletter to find out more about our financial modelling courses. The newsletter also includes top tips, and advice.

Skip to main content
Skip to search
Skip to accessibility help

  • Schools and departments
  • Staff directory
  • Student Hub

  • Staff

    • Email
    • Staff Hub
    • Moodle
    • Library

City, University of London

Search

Menu

  • Courses and study

    Courses
    • Undergraduate courses
    • Foundation courses
    • Postgraduate courses
    • Research degrees
    • Short courses
    • CPD courses
    • Cass Executive Education
    Study
    • Applying
    • Fees and funding
    • Scholarships and bursaries
    • Living in London
    • Accommodation
    • Visit us
    • Undergraduate Open Days
    • Postgraduate Open Evenings
    • Student support
    International students
    • Visa and immigration
    • Exchange and study abroad
    • Preparatory programmes
    Order a prospectus

  • Research

    Research

    • City Graduate School
    • Spotlight on research
    • Research publications
    • REF 2014
    • City Research and Enterprise Review 2011

  • Business services

    Business services

    • Research and consultancy
    • Professional development
    • Strategic partnerships
    • Areas of expertise
    • Facilities and equipment
    • Student enterprise (CityVentures)
    • Case studies
    • Contact business services

  • Alumni

    Alumni

    • Alumni benefits
    • Events
    • News
    • Alumni Ambassadors
    • Support us
    • Careers and professional development
    • Contact us
    • Update your details

  • About City

    About City

    • Vision and Strategy 2026
    • Our history
    • Who’s who at City
    • Governance
    • Global City
    • Work for City
    • City and the community
    • Sustainability and the environment
    • Building the Vision
    • Education
    • Campus and maps

Schools and departments
Staff directory

  • Student Hub

  • Staff

    • Email
    • Staff Hub
    • Moodle
    • Library

Courses

  1. Undergraduate
  2. Postgraduate
  3. Research Degrees
  4. CPD
  5. Short Courses
  1. End of term questionnaire
  2. Payment response
  3. The Novel Studio


    Courses

    • Home

    • Undergraduate

      • Aeronautical Engineering (BEng)

        • 2019

      • Aeronautical Engineering (MEng)

        • 2019

      • Biomedical Engineering (BEng)

        • 2019

      • Biomedical Engineering (MEng)

        • 2019

      • Civil Engineering (BEng)

        • 2019

      • Civil Engineering (MEng)

        • 2019

      • Civil Engineering Foundation Programme

        • 2019

      • Computer Science (BSc)

        • 2019

      • Computer Science with Games Technology (BSc)

        • 2019

      • Criminology

        • 2019

      • Criminology and Psychology

        • 2019

      • Criminology and Sociology

        • 2019

      • Data Science

        • 2019

      • Economics

        • 2019

      • Economics with Accounting

        • 2019

      • Electrical & Electronic Engineering and Biomedical Engineering Foundation Programmes

        • 2019

      • Electrical and Electronic Engineering (BEng)

        • 2019

      • Electrical and Electronic Engineering (MEng)

        • 2019

      • Engineering (BEng)

        • 2019

      • Engineering (MEng)

        • 2019

      • English

        • 2019

      • Financial Economics

        • 2019

      • Health and Social Care

        • 2019

      • History

        • 2019

      • International Foundation Programme

        • 2018

      • International Political Economy

        • 2019

      • International Politics

        • 2019

      • International Politics and Sociology

        • 2019

      • Introduction to Optometry

        • 2019

      • Journalism

        • 2019

      • Law

        • 2019

      • MSci Computer Science

        • 2019

      • MSci Computer Science with Cyber Security

        • 2019

      • MSci Computer Science with Games Technology

        • 2019

      • Mathematics

        • 2019

      • Mathematics and Finance

        • 2019

      • Mathematics with Finance and Economics

        • 2019

      • Mechanical Engineering (BEng)

        • 2019

      • Mechanical Engineering (MEng)

        • 2019

      • Mechanical and Aeronautical Engineering Foundation Programmes

        • 2019

      • Media, Communication and Sociology

        • 2019

      • Midwifery

        • 2019

      • Music

        • 2019

      • Music, Sound and Technology

        • 2019

      • Nursing Studies

        • 2019

        • 2018

      • Nursing: Adult

        • 2019

      • Nursing: Child

        • 2019

      • Nursing: Mental Health

        • 2019

      • Optometry

        • 2019

      • Politics

        • 2019

      • Psychology

        • 2019

      • Radiography – Diagnostic Imaging

        • 2019

      • Radiography – Radiotherapy and Oncology

        • 2019

      • Sociology

        • 2019

      • Sociology with Psychology

        • 2019

      • Speech and Language Science

        • 2019

      • Speech and Language Therapy

        • 2019

      • Structural Engineering (MEng)

        • 2019

    • Postgraduate

      • Academic Practice

        • 2018

        • 2019

      • Adult Mental Health

        • 2018

        • 2019

      • Adult and Mental Health Nursing (pre-registration)

        • 2019

      • Advanced Mechanical Engineering

        • 2019

      • Advanced Nurse Practitioner – Adult; Child

        • 2018

      • Advanced Nurse Practitioner – Ophthalmic

        • 2018

        • 2019

      • Midwifery (Advanced Practice and Health Social Care)

        • 2018

        • 2019

      • Advanced Practice Nursing

        • 2018

        • 2019

      • Advanced Practice in Health and Social Care

        • 2018

        • 2019

      • Air Transport Management

        • 2018

        • 2019

      • Air Safety Management

        • 2018

        • 2019

      • Aircraft Maintenance Management

        • 2018

        • 2019

      • Airport Management

        • 2018

        • 2019

      • Artificial Intelligence

        • 2019

      • Bar Professional Training Course

        • 2019

      • Behavioural Economics

        • 2019

      • Broadcast Journalism

        • 2019

      • Business Economics / International Business Economics

        • 2019

      • Business Systems Analysis and Design

        • 2019

      • Child and Adolescent Mental Health

        • 2018

        • 2019

      • Civil Engineering Structures

        • 2019

      • Civil Engineering Structures (Nuclear Power Plants)

        • 2019

      • Civil Litigation and Dispute Resolution LLM

        • 2018

        • 2019

      • Clinical Optometry

        • 2018

        • 2019

      • Clinical Research

        • 2019

      • Clinical, Social and Cognitive Neuroscience

        • 2019

      • Composition

        • 2019

      • Computer Games Technology

        • 2019

      • Construction Management

        • 2019

      • Counselling Psychology

        • 2019

      • Creative Writing and Publishing

        • 2019

      • Criminal Litigation LLM

        • 2018

        • 2019

      • Criminology and Criminal Justice

        • 2019

      • Culture, Policy and Management

        • 2019

      • Cyber Security

        • 2019

      • Data Science

        • 2019

      • Development Economics

        • 2019

      • Diplomacy and Foreign Policy

        • 2019

      • Dispute Resolution LLM

        • 2018

        • 2019

      • Economic Evaluation in Health Care

        • 2019

      • Economics

        • 2019

      • Energy and Environmental Technology and Economics

        • 2019

      • English

        • 2019

      • Ethnomusicology

      • European Commercial Law LLM

        • 2018

        • 2019

      • European Union Law LLM

        • 2018

        • 2019

      • Financial Economics

        • 2019

      • Financial Journalism

        • 2019

      • Food Policy

        • 2019

      • Global Political Economy

        • 2019

      • Postgraduate Certificate in Counselling Psychology

        • 2019

      • Graduate Diploma in Law

        • 2019

      • Graduate Entry LLB

        • 2019

      • Health Economics

        • 2019

      • Health Management

        • 2018

        • 2019

      • Health Policy

        • 2018

        • 2019

      • Health Psychology

        • 2019

      • Health Services Research

        • 2019

      • Human-Computer Interaction Design

        • 2019

      • Information Science

        • 2019

      • Interactive Journalism

        • 2019

      • International Banking and Finance Law LLM

        • 2018

        • 2019

      • International Business Law (distance learning)

        • 2018

        • 2019

      • International Commercial Law LLM

        • 2018

        • 2019

      • International Communications and Development

        • 2019

      • International Economic Law LLM

        • 2018

        • 2019

      • International Energy Law and Regulation LLM

        • 2018

        • 2019

      • International Human Rights LLM

        • 2018

        • 2019

      • International Journalism

        • 2019

      • International Politics

        • 2019

      • International Politics and Human Rights

        • 2019

      • International Publishing

        • 2019

      • Internet of Things with Entrepreneurship

        • 2019

      • Investigative Journalism

        • 2019

      • Journalism, Media and Globalisation

        • 2019

      • LLM Legal Practice

        • 2019

      • LLM Professional Skills

        • 2019

      • Legal Practice Course

        • 2019

      • Library Science

        • 2019

      • Magazine Journalism

        • 2019

      • Maritime Law (Dubai)

        • 2018

        • 2019

      • Maritime Law (Greece)

        • 2018

        • 2019

      • Maritime Law LLM

        • 2018

        • 2019

      • Maritime Operations and Management

        • 2019

      • Maritime Operations and Management in Greece

        • 2019

      • Master of Laws

        • 2018

        • 2019

      • Media and Communications

        • 2019

      • Medical Ultrasound

        • 2019

      • Midwifery (90-week shortened programme for nurses)

        • 2019

      • Music

      • Newspaper Journalism

        • 2019

      • Organisational Psychology

        • 2019

      • Primary Care (Practice Nursing)

        • 2018

        • 2019

      • Professional Advocacy LLM

        • 2018

        • 2019

      • Professional Practice

        • 2018

        • 2019

      • Project Management, Finance and Risk

        • 2019

      • Public Health

        • 2019

      • Public Health (District Nursing Health Visiting or School Nursing)

        • 2019

      • Public International Law LLM

        • 2018

        • 2019

      • Publishing

        • 2019

      • Radiography (Computed Tomography)

        • 2018

        • 2019

      • Radiography (Medical Magnetic Resonance)

        • 2018

        • 2019

      • Renewable Energy and Power Systems Management

        • 2019

      • Research Methods

        • 2019

      • Research Methods with Psychology

        • 2019

      • Software Engineering

        • 2019

      • Speech Language and Communication Needs in Schools: Advanced Practice

        • 2018

        • 2019

      • Speech and Language Therapy

        • 2019

      • Speech, Language and Communication (Advanced Practice in Health and Social Care)

        • 2018

        • 2019

      • TV Journalism

        • 2019

      • Temporary Works and Construction Method Engineering

        • 2019

      • Adult Nursing (pre-registration)

        • 2019

      • Children’s Nursing (pre-registration)

        • 2019

      • Mental Health Nursing (pre-registration)

        • 2019

    • Research Degrees

    • CPD

    • Short Courses

      • End of term questionnaire

      • Payment response

      • The Novel Studio

        • Tutor information

        • Alumni

        • The Novel Studio competition

        • What will I learn?

    Financial Modelling in Excel
    Short Courses

    Choose a start date

    Recent Posts

    Categories