Financial Modeling with MS-Excel (FIN4306) crash course, Online MBA, Semester 3:
This subject teaches you to build financial models in MS-Excel, from core Excel features, database and finance functions to simulation, capital budgeting,…
- 15 video lessons
- 6h 30m
- Study notes
- 70 quiz questions
- Assignment
15 lessons in Financial Modeling with MS-Excel
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject teaches you to build financial models in MS-Excel, from core Excel features, database and finance functions to simulation, capital budgeting, valuation, portfolio models and VBA automation. After it you will be able to forecast and analyse financial statements, appraise projects and value firms with built-in risk and sensitivity analysis, and write macros and user forms to automate your models.
- 1
Introduction to Financial Modeling in Excel
Module I, Understanding the Basic Featuresof Excel: Introduction to Modeling, Introduction to Excel
Learn Financial Modelling - Step by Step· The Valuation School· 36 min
Study notes 5 quiz questionsWatch lesson - 2
Excel Database Functions and Charts
Module I, Understanding the Basic Featuresof Excel: Database Functions in Excel, Creating Charts
Excel Tutorial For Beginners in Hindi | Complete Microsoft Excel Tutorial (Basic To Advance)· Rishabh Mishra· 38 min
Study notes 5 quiz questionsWatch lesson - 3
Excel Finance Functions Explained
Module I, Understanding the Basic Featuresof Excel: Understanding Finance Functions present in Excel
Ms Excel Financial Functions, FV, PMT, Rate, NPER, PV Details explanation | Lecture-10 UPCISS· upciss· 34 min
Study notes 5 quiz questionsWatch lesson - 4
Dynamic Models with Forms and Controls
Module I, Understanding the Basic Featuresof Excel: Using Forms and Control Toolbox, Creating Dynamic Models
Build a Dynamic Financial Model in Just 15 Minutes· Kenji Explains· 15 min
Study notes 5 quiz questionsWatch lesson - 5
Statistical Distributions for Simulation
Module II, Simulation using Excel: Different Statistical Distributions used in Simulation
Session 40 - Probability Distribution Functions - PDF, PMF & CDF | DSMP 2023· CampusX· 23 min
Study notes 5 quiz questionsWatch lesson - 6
Generating Random Numbers in Excel
Module II, Simulation using Excel: Generating Random Numbers that follow a particular distribution
Build A Simple Stochastic Model For Predictive Analysis In Excel – Using RAND And VLOOKUP· The Excel Hub· 6 min
Study notes 5 quiz questionsWatch lesson - 7
Monte Carlo Simulation Models in Finance
Module II, Simulation using Excel: Building Models in Finance using Simulation
Monte Carlo Simulation in DCF Valuation | Step-by-Step Excel Tutorial· GrowthBridge™ Labs· 21 min
Study notes 5 quiz questionsWatch lesson - 8
Common Size Statements and Financial Forecasting in Excel
Module III, Excel in Capital Budgeting, valuation: Preparing common size statements directly from Trial Balance, Forecasting Financial Statements using Excel, Analysing Financial Statements by using Spreadsheet Model
Financial Statement Analysis in Excel | Session 3 | Kuldeep Sir· PW Skills - Finance· 80 min
Study notes 5 quiz questionsWatch lesson - 9
Project Appraisal: Viability, Risk and Simulation
Module III, Excel in Capital Budgeting, valuation: Determining Project Viability, Risk Analysis in Project Appraisal, Simulation in Project Appraisal
Risk Analysis in Capital Budgeting | All Methods & Numerical | Risk Analysis in Project Management |· Rajnish Sharma Classes· 33 min
Study notes 5 quiz questionsWatch lesson - 10
DCF Valuation Model and Value Drivers
Module III, Excel in Capital Budgeting, valuation: Determination of Value Drivers, DCF Valuation, Risk Analysis in Valuation
Build A Full Discounted Cash Flow Model for a REAL Company· Kenji Explains· 29 min
Study notes 5 quiz questionsWatch lesson - 11
Portfolio Optimization and Insurance in Excel
Module III, Excel in Capital Budgeting, valuation: Determining Efficient Portfolio, Creating Dynamic Portfolios, Portfolio Insurance, Fixed Income Portfolio Management using Excel
Portfolio Optimization in Excel: Step by Step Tutorial· Ryan O'Connell, CFA, FRM· 15 min
Study notes 5 quiz questionsWatch lesson - 12
VBA Subroutines and Functions for Finance
Module IV, : Understanding Subroutines and Functions and building simple financial models using subroutines and functions, Subroutines and Functions
Learn Excel VBA to Automate Anything· Kenji Explains· 9 min
Study notes 5 quiz questionsWatch lesson - 13
Recording and Editing Macros
Module IV, : Recording and Editing Macros
How to Create & Use Excel Macros (Real world example)· Leila Gharani· 10 min
Study notes 5 quiz questionsWatch lesson - 14
VBA Decision Rules, MsgBox, InputBox and Debugging
Module IV, : Decision Rules, Message Box and Input Box, Debugging
Excel Macros & VBA - Tutorial for Beginners· Kevin Stratvert· 22 min
Study notes 5 quiz questionsWatch lesson - 15
Advanced Financial Models with VBA User Forms
Module IV, : Designing Advanced Financial Models using VBA, User Forms, Other Advanced Features, Actual Model Building
Automated Data Entry Form in Excel· Ajay Anand· 19 min
Study notesWatch lesson
Assignment
Build a Dynamic Project Appraisal and DCF Model in Excel
Less scrolling. More passing.
- Free
Hand-picked video lessons
15 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
15 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
70 questions across the course, with the right answer and why, the moment you pick.
- Free login
Assignments
1 subject assignments with clear tasks, so you practise what each subject actually asks of you.
- Free login
Notebook
Write notes beside the video, stamped with the exact time, and jump back to that moment later.
- Free login
Progress that follows you
Completed lessons, quiz scores and where you stopped, saved to your account on every device.
- Live chat pass
Live chat
A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.
The Online MBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online MBA. Ask a Financial Modeling with MS-Excel doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online MBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online MBA live chat
Anyone else finding Financial Modeling with MS-Excel tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Database Management Systems tonight if anyone wants to go together
More from Online MBA Semester 3
All subjects- Sem 3E-Commerce
ECM4302
Database Management Systems
This subject covers how database management systems are structured, how relational databases and ER models are designed, the integrity rules and relational…
- 18 lessons
- 4h
- Notes
- Quiz
- Sem 3E-Commerce
ECM4307
Dynamic Web Design & Development
This subject covers building web pages with HTML and CSS, then writing server-side PHP programs using variables, loops, functions, strings, arrays, forms,…
- 21 lessons
- 9h 48m
- Notes
- Quiz
- Sem 3Finance
FIN4302
Business Valuation
This subject covers how companies and their shares are valued using discounted cash flow models and relative valuation multiples, including the special cases…
- 13 lessons
- 5h 55m
- Notes
- Quiz
- Sem 3HR
HRM4305
Training and Development
This subject covers how organisations run training: assessing training needs, designing programmes, choosing training methods, evaluating results including…
- 12 lessons
- 2h 57m
- Notes
- Quiz
- Sem 3Marketing
MKT4308
Consumer Behaviour
This subject explains how consumers think, feel and decide when buying, covering individual factors like motivation, perception and attitude, social influences…
- 19 lessons
- 7h 21m
- Notes
- Quiz
- Sem 3Marketing
MKT4305
Direct Marketing
This subject covers how direct marketing works, from planning, customer databases, mailing lists and media such as telemarketing and e-communications to…
- 17 lessons
- 4h 18m
- Notes
- Quiz
Financial Modeling with MS-Excel: common questions
This subject teaches you to build financial models in MS-Excel, from core Excel features, database and finance functions to simulation, capital budgeting, valuation, portfolio models and VBA automation. After it you will be able to forecast and analyse financial statements, appraise projects and value firms with built-in risk and sensitivity analysis, and write macros and user forms to automate your models. It's the Financial Modeling with MS-Excel subject of Online MBA, Semester 3, in 15 lessons: Introduction to Financial Modeling in Excel; Excel Database Functions and Charts; Excel Finance Functions Explained; Dynamic Models with Forms and Controls; Statistical Distributions for Simulation; Generating Random Numbers in Excel; Monte Carlo Simulation Models in Finance; Common Size Statements and Financial Forecasting in Excel; Project Appraisal: Viability, Risk and Simulation; DCF Valuation Model and Value Drivers; Portfolio Optimization and Insurance in Excel; VBA Subroutines and Functions for Finance; Recording and Editing Macros; VBA Decision Rules, MsgBox, InputBox and Debugging; Advanced Financial Models with VBA User Forms.
Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.
About 6h 30m of video across 15 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “Build a Dynamic Project Appraisal and DCF Model in Excel”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.
A members-only live chat beside the video, shared by everyone studying Online MBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.
No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.