Penny Stocks King: How 2 really Trade Penny Stocks (6+Hours)
Saad T. Hameed (STH) • 1+ Million Enrollments Worldwide
5.0 (358)·6h 26m · 47 lectures
$3.00$12–$199up to −98%
Loading course
Excel for Finance: Modeling, Analysis & Optimization
Apply Excel to real world finance: 3-statement modeling, Solver optimization, data analysis, loan and bond modeling
5.02 reviews3 learners
- Beginner
- 6h 29m video
- 59 lectures
- English
- Updated 2026
Taught by MB Finance
- 6h 29m of on-demand video
- 59 lectures across 8 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- English audio
Curriculum
8 sections59 lectures6h 29m total
- Introduction4:49
- Financial Data to Decision-Ready Insights with PivotTables0:58
- How to create PivotTables?8:51
- Calculating Product Profitability on a Raw Dataset with PivotTables5:48
- Analyzing Product Profitability by Region with PivotTables4:29
- Analyzing Product Profitability per Sales Person with PivotTables2:58
- Calculating Product Profit Margin & Analyzing with PivotTables7:36
- Introduction: What is Solver and Why is it Useful?1:15
- EBIT Explained1:14
- Maximizing EBIT with Solver: Production Under Constraints - PT I.7:41
- Maximizing EBIT with Solver: Production Under Constraints - PT II.4:09
- Optimize Investment Allocation using Solver - PT I.4:54
- Optimize Investment Allocation using Solver - PT II.6:47
- Maximizing Bank Profit with Solver: Loan Allocation Under Compliance Constraints7:59
- What is GDP?1:19
- Optimizing Capital Allocation with Solver: Maximizing GDP Impact9:20
- Optimizing Workforce Capacity with Solver: An Accounting Firm Case - PT I.5:13
- Optimizing Workforce Capacity with Solver: An Accounting Firm Case - PT II.13:01
- What is the Balance Sheet and P&L Statement?1:10
- Using Goal Seek to Optimize Profit Level5:29
- Using Goal Seek to Maximize Export Sales in P&L Statement3:27
- Optimizing EBITDA margin in P&L Statement5:58
- Calculating and Optimizing ROE6:05
- Calculating and Optimizing ROA2:58
- What is Cash Flow and How to Calculate it8:06
- Optimizing the Operative Cash Flow with Goal Seek3:58
- Optimizing the Financing Cash Flow with Goal Seek2:56
- Introduction: Loan Interest Rates0:56
- Interest Rate Modeling with Excel13:19
- Credit Cash Flow Modeling with Excel13:19
- Net Debt to EBITDA Explained0:58
- Computing Net Debt to EBITDA6:22
- Computing Net Debt to EBITDA - A Different Approach5:00
- Net Debt / EBITDA Sensitivity Analysis with Excel Data Tables7:48
- Turning Sensitivity Results into Credit Risk Signals with VLOOKUP5:47
- Visualizing Credit Risk with Conditional Formatting4:15
- Introduction to Bonds1:22
- Bond Fundamentals: Key Features & Terminology7:06
- How to Evaluate Bonds?3:02
- Bond Valuation with Present Value Approach6:02
- How I Explained Bond Yields to a Development Bank CEO — A Practical Example12:16
- Understanding Bond Duration (Macaulay Duration, Modified Duration)14:23
- Case Study (Part I.): Modeling the Cash Flows & Monthly PV of a Bond15:32
- Case Study (Part II.): Modeling the Cash Flows & Monthly PV of a Bond4:39
- Using Goal Seek to Find the Yield for a Lower Target Bond Price5:43
- Using Goal Seek to Find Yield for a Higher Target Bond Price3:58
- Bonus Lecture: How Economic Expectations and Central Bank Decisions Move Yields17:57
About this course
Solve Real-World Finance Problems with Excel! Learn 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. Each section starts with a financial problem and introduces the Excel tools needed to solve it. Techniques introduced earlier are then reused in more advanced cases, helping you practice and deepen your skills throughout the course. You will build and solve practical finance ca…
Before you start
- General understanding of Excel formulas is helpful. No prior finance knowledge is required as everything is explained during the course.
Who it’s for
- Students, financial analysts, investment bankers, anyone who is interested in learning finance
Related
More in Finance & Accounting
DIY Advance Options Trading (5 Courses) 11hrs w/ Live Trades
Saad T. Hameed (STH) • 1+ Million Enrollments Worldwide
5.0 (275)·11h 19m · 78 lectures$3.00$12–$199up to −98%Forex Mastery: Technical & Fundamental Analysis Mega Course
Ransom Enupe
5.0 (253)·17h 59m · 109 lectures$3.00$12–$199up to −98%Introdução a instrumentos DERIVATIVOS com PYTHON para QUANTS
Andre Cury Maialy
5.0 (212)·129h 22m · 97 lecturesNot available yet
$3.00$12–$199