Financial Problem Solving With Excel: Modeling & Analysis
Published 8/2026
Created by MB Learning
MP4 |
Video: h264, 1280x720 |
Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner |
Genre: eLearning |
Language: English |
Duration: 51 Lectures ( 5h 58m ) |
Size: 2.4 GB
Apply Excel to real-world finance through optimization, data analysis, loan and bond modeling & financial analysis
What you'll learn
⚡ Build and analyze complete financial statements, connecting the P&L, Balance Sheet and Cash Flow Statement to assess company performance.
⚡ Use Excel Solver and linear programming to optimize financial decisions, including investment, allocation and production problems
⚡ Build financial models, including loan cash flows, leverage and sensitivity analysis, bond valuation and duration.
⚡ Solve real-world financial problems in Excel using Goal Seek, Solver, PivotTables, Data Tables and other advanced tools.
Requirements
❗ No requirements
Description
This course contains the use of artificial intelligence
Solve Real-World Finance Problems with Excel
This course teaches you how to use
Excel to solve practical corporate finance problems - from targeted calculations and optimization tasks to complete financial models.
This is
not a traditional Excel course. Instead of learning functions in isolation, each section starts with a financial problem and introduces the Excel tools needed to solve it.
What You Will Work On
Throughout the course, you will build and solve practical finance cases, including
✨
P&L and Balance Sheet optimization using Goal Seek
✨
Financial dataset analysis with PivotTables, including product profitability analysis
✨
Loan cash flow modeling and repayment analysis
✨
Net Debt / EBITDA modeling with sensitivity analysis using Data Tables
✨
Bond valuation and modeling, including the relationship between interest rates, yield curves and bond prices, duration, and many more!
✨
Linear programming for finance and economics using Solver
✨
Complete financial modeling, connecting the P&L, Balance Sheet and Cash Flow Statement
✨
Financial analysis and interpretation of the completed models
Finance First, Excel Second
Excel is the tool -
financial problem-solving is the focus.
Along the way, you will work with Goal Seek, Solver, Data Tables, PivotTables and increasingly advanced formulas and modeling techniques. By the end of the course, you will be working with Excel at an advanced level without learning it through disconnected feature demonstrations.
No Prerequisites
No Excel or finance knowledge is required.
The financial concepts needed for each exercise are explained as they appear - including financial statements, cash flow, leverage, bonds and interest rates. Important concepts are reinforced when they return in later exercises, helping you gradually connect individual topics into a broader understanding of corporate finance.
By the end of the course, you will be able to
structure financial problems, build models to solve them, analyze the results and use Excel as a practical finance tool.
Who this course is for
⭐ Students, financial analysts, investment bankers, anyone who is interested in learning finance
Homepage
Код:
https://www.udemy.com/course/financial-problem-solving-with-excel-modeling-analysis
Financial Problem Solving With Excel Modeling & Analysis
