Fundamentals of Financial Modeling

Fitch Learning
Training overview
1 day
English
Professional course
Next start date: 5/27/2020 - Online
From 995 USD
895 GBP
995 EUR
Start dates
Online
5/27/2020  
995 USD
5/27/2020  
895 GBP
New York City
6/22/2020  
995 USD
9/21/2020  
995 USD
London
7/20/2020  
895 GBP
8/19/2020  
895 GBP

Course description

*With many businesses now working from home, we have introduced virtual learning so we can continue to deliver high quality training to the financial community as we accommodate this new way of working. Since 2003, Fitch Learning has been delivering virtual learning programs to clients and learners. Building on this extensive experience, we are now able to offer a range of public courses in a live online environment, whilst ensuring you will get the same value as you would in our classroom courses.

Fundamentals of Financial Modeling

This course can either be taken in a classroom environment or live online. Get in touch to find out more.

This one-day course practically applies Excel within a financial framework to explore how forecast financial models can be efficiently created and modified. The efficient use of Excel is key and so the course starts by ensuring the participants can quickly and accurately harness Excel’s tools and functionality. We then apply these skills to the best practice modeling guidelines to build, and then flex, the structure and modules of a forecast model.

Want to find out more?

Do you have questions about this training and how COVID-19 might affect it?

At findcourses.com we are committed to helping everyone who wants to learn, to learn. So are the training suppliers we partner with.

Get in touch on this page to find out whether there are any changes to this training in light of COVID-19.

Who should attend?

Professionals in corporates and financial institutions who need to create useful and robust financial models. Attendees should be able to use the basic facilities of Microsoft Excel and have basic accounting knowledge.

Training Content

Introduction to Modeling

  • Using Excel as a spreadsheet
  • Effective construction of a model
  • Objective and structure
  • Initial preparation

The Fundamentals of Model Building

  • Use of shortcuts
  • Workbook set up
  • Formatting data professionally
  • Style basics
  • Inputting base data
  • Setting up date flexibility throughout the model using EDATE, EOMONTH and other date functions
  • Breakdown and grouping of accounting elements
  • Determine drivers of the model
  • Assumptions for projections
  • Effective use of short keys and functions
  • Applicable financial and logical functions
  • Data transfer and links
  • Professional use of Excel – protection, range names, data validation
  • Maximum use of Excel applications
  • Flexible and user-friendly models
  • Sensitivities
  • Model diagnostics

Auditing

  • Using existing models
  • How to become comfortable with ‘new’ models
  • Auditing models

Formatting and Showcasing

  • Formatting
  • Professional showcase
  • Use of graphs
  • Using switches

About Fitch Learning

Fitch Learning - Financial Training in the Americas

Fitch Learning

*With many businesses now working from home, we have introduced virtual learning so we can continue to deliver high quality training to the financial community as we accommodate this new way of working. Since 2003, Fitch Learning has been delivering...


Read more and show all training delivered by this supplier

Request info

Fill out your details to find out more about Fundamentals of Financial Modeling.

  Contact the provider

  Get more information

  Register your interest

Contact info

Fitch Learning


 Show phone number
www.fitchlearning.com


Reviews

Average rating 5

Based on 1 reviews

Felix Minnoh
(5)
Very informative and hands-on, which is great
Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available