Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling for Beginners in Excel in 4 Hours!
Financial Modeling - Beginners
Intro - Modules in the Course (2:38)
Exercise Files
Intro - What is a Financial Model (4:24)
Intro - Financial Model Design (7:32)
Intro - Scenario Analysis (2:33)
Intro - Documentation (4:59)
Core Excel Concepts - Cell References (8:31)
Core Excel Concepts - IF Formula (2:27)
Core Excel Concepts - AND Formula (3:18)
Core Excel Concepts - OR Formula (2:33)
Core Excel Concepts - Nested Formulas (3:07)
Core Excel Concepts - Conditional Formatting (3:13)
Core Excel Concepts - Data validation (5:02)
Model - Inputs (8:40)
Model - Revenue (7:22)
Model - Expenses (6:32)
Model - Profit and Loss (7:21)
Model - Cashflow (10:20)
Model - Adding Scenarios (14:41)
Model - Charts (5:09)
Model - Conditional Formatting (4:49)
Model - Protect Workbook (6:02)
Financial Modeling - Intermediate
Intro - Modules in the Course (2:32)
Exercise Files
Intro - Design Principles (7:23)
Core - Aggregate Functions (5:15)
Core - Lookup Functions (14:15)
Core - Forecasting (6:14)
Core - Mixed References and Named Ranges (8:35)
Core - External Links (14:14)
Skills - Error Checks (9:03)
Skills - Goal Seek (7:39)
Skills - WACC (8:11)
Skills - NPV and IRR (9:04)
Model - Introduction (2:36)
Model - Staff Expenses (16:43)
Model - Staff Expenses Summary (6:31)
Model - Revenue (19:11)
Model - Market Analysis (1:57)
Model - Profit and Loss (6:38)
Model - NPV IRR (6:51)
Model - Payback Period (4:26)
Model - Scenario Analysis (6:52)
Core - Lookup Functions
Complete and Continue