Introduction to Financial Modeling in Excel
-
Training TypeLive Training
-
CategoryFinance
-
Duration3 Hours
-
Rating4.8/5
Excel Financial Modeling Course Introduction
About Excel Financial Modeling Course
For those new to Financial Modeling, this course from the author of “Financial Modeling in Excel for Dummies”, Danielle Stein Fairhurst will introduce the fundamentals and concepts of building a financial model using Excel. This is a practical course in which you will develop the skills to build your own financial model which can be taken away for future reference.
Excel Financial Modeling Course Objective
You will learn how to design and create a user-friendly model using best practice techniques which can then be taken away for future reference.
You will learn to:
1. Use absolute and relative cell referencing for modeling
2. Create a basic error check formula
4. Use techniques to prevent model errors
5. Document model assumptions
6. Link and change variables
7. Prevent data from being changed by protecting your model
8. Build and use drop-down boxes
This course builds on students’ basic knowledge of simple formulas and incorporates these into a financial model.
Who is the Excel Financial Modeling Course Target Audience?
Finance professionals who need to expand their Excel modeling skills
What Basic Knowledge Required to Learn Excel Financial Modeling Course?
At a minimum, it is assumed that participants will know how to:
- Navigate confidently in Excel
- Create and use simple formulas
- Link between workbooks
Available Batches
Pricing
Require a Different Batch?
Request a Batch For
-
What is Financial Modeling?
-
Model Design
-
Linking for Best Practice
-
Error checks
-
Absolute & Relative Cell Referencing
-
Calculating Project Costs
-
Logical Nested Functions
-
Creating a Financial Model with Inputs & Assumptions
-
Calculating Revenue & Expenses
-
Building the financial statements
-
Protecting your Workbook
-
Scenario Analysis
-
Presenting the Model output