Excel Financial Modeling and Business Analysis Masterclass
Excel Financial Modelling from scratch: Financial Statements, Project Costing, Discounted Cash Flow (DCF), Accounting
4.55 (976 reviews)
4,581
students
15.5 hours
content
Mar 2025
last update
$74.99
regular price
What you will learn
Design scalable, flexible, and reusable financial models with Excel
Create a complete range of applicable Excel models from Financial Statement Modeling, Budgeting, Forecasting, Discounted Cash Flow Analysis, What if Analysis
Build calculations to assist in decision-making
Learn to structure a Financial Report from scratch
Understand Financial Modeling Theory: what it is, who uses it, and why it matters
Plan and Design your Financial Model: how to find the Data for the Model, the steps To Build a Model, and methods for Including Documentation in a Model
Learn tools and techniques for Financial Modeling: Cell Referencing, Naming and Dynamic Ranges, P&L Calculations, Restricting & Validating Data, Goal Seeking
Master Excel formulas and functions: SUMPRODUCT, SUMIFS, OFFSET, VLOOKUP, XLOOKUP, PMT, PPMT, IPMT, NPER, PV, NPV, XNPV, INDIRECT, ADDRESS etc
Build Scenarios to Financial Models: Drop-Down Scenarios, Sensitivity Analysis with Data Tables, Scenario Manager
Learn Charting for Analysis and Model Output: Trending Column Chart, Bullet chart & Four-Segment Line Chart
Financial Statements (3-statement) Model
Project Costing Model
Discounted Cash Flow (DCF) Modelling
Activity-Based Costing
Budgeting
Forecasting Development
Learn model construction, assumptions, advanced excel functionality, error trapping, sensitivity analysis, presentation of model output, and pro tips and tricks
Become a successful Financial Analyst in no time!
Screenshots
4985300
udemy ID
11/19/2022
course created date
12/25/2022
course indexed date
Bot
course submited by