Home
»
Finance & Accounting
»
Corporate Finance

Master Excel Finance: From Basics to Advanced Analysis

Master Excel for Finance: Unlock the Power of Spreadsheets to Analyze, Calculate, and Manage Your Financial Goals with 100+ Engaging Lessons!

5.0 (29)

238 learners

What you'll learn

Gain proficiency in Excel financial functions and formulas.
Understand the fundamentals of corporate financial management.
Analyze investment criteria and financial statement ratios.
Master asset valuation techniques using Excel tools.

This course includes

20.5 hours of video
Certificate of completion
Access on mobile and TV

Course content

1 modules • 114 lessons • 20.5 hours of video

Master Excel Finance: From Basics to Advanced Analysis

114 lessons • 20.5 hours

▶

Free Excel Finance Course at YouTube01:21
Excel Finance Class 01: Introduction to To Excel 2007 & 201014:48
Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References20:39
Excel Finance Class 03: Math Operators and Order of Operations24:50
Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations13:13
Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting11:33
Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas07:59
Excel Finance Class 07: Stylistic Formatting03:46
ACCTG 455: Excel Finance Class 08: Intro To Corporate Financial Management46:24
ACCTG 455: Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market V34:47
ACCTG 455: Excel Finance Class 10 Income Statement, NonCash Depreciation Expense, Matching Principal21:35
ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information38:26
ACCTG 455: Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates13:10
ACCTG 455: Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short06:15
ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis30:17
ACCTG 455: Excel Finance Class 15: Common Sized Financial Statements11:22
ACCTG 455: Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated14:10
ACCTG 455: Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier & m19:21
ACCTG 455: Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days18:09
ACCTG 455: Excel Finance Class 18.5: Ratios For Cash Cycle In Days.08:54
Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis17:03
ACCTG 455: Excel Finance Class 20: Growth Ratios and Market Value Ratios14:52
ACCTG 455: Excel Finance Class 21: Future Value Lump Sum Calculations31:40
ACCTG 455: Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function17:24
ACCTG 455: Excel Finance Class 23: Solve For Total Number of Periods When You Know PV, FV & P. Rate05:06
ACCTG 455 Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV & Periods11:58
ACCTG 455: Excel Finance Class 25: Future Value For Lender Or Borrower03:41
ACCTG 455: Excel Finance Class 26: Multiple Cash Flow Valuation, Future Value & Present Value20:51
ACCTG 455: Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis & PV Function07:17
ACCTG 455: Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate19:40
ACCTG 455: Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function)17:48
ACCTG 455: Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly05:50
ACCTG 455: Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function)08:20
ACCTG 455: Excel Finance Class 32: Calculate Present Value of Annuity (PV Function)10:23
ACCTG 455: Excel Finance Class 33: Full Life Retirement Plan with PV Annuity & FV Annuity09:49
ACCTG 455: Excel Finance Class 34: Present Value Of Annuity For Asset Valuation03:27
ACCTG 455: Excel Finance Class 35: PMT for Present Value of Annuity PMT Function for Loan Payment02:46
ACCTG 455: Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR w/ Points & RATE function14:49
ACCTG 455: Excel Finance Class 37: How Much Do I Get Each Month During Retirement?03:22
ACCTG 455: Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity02:31
ACCTG 455: Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment02:52
ACCTG 455: Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula03:07
ACCTG 455: Excel Finance Class 41: Interest Only Loan Schedule.01:55
ACCTG 455: Excel Finance Class 42: Consumer Amortized Loans08:40
ACCTG 455: Excel Finance Class 43: Business Amortized Loans03:12
ACCTG 455: Excel Finance Class 44: Deep Discount Loans06:03
ACCTG 455: Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect17:56
ACCTG 455 Excel Finance Class 46: Bonds: Set Of Cash Flows Discounted At Market Rate, Coupon or Zero27:38
ACCTG 455 Excel Finance Class 47: Selling Bond When Coupon Rate Not Equal To Discount Rate: YTM Rate07:33
ACCTG 455 Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows03:53
ACCTG 455: Excel Finance Class 49: Bond Quoted Price & Yield To Market05:53
ACCTG 455 Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price, Excel Chart Visual07:16
ACCTG 455: Excel Finance Class 51: Par - Discount - Premium Bonds09:50
ACCTG 455: Excel Finance Class 52: Bond Discount Or Premium Amortization Table.06:59
ACCTG 455: Excel Finance Class 53: Bond Discount Or Premium Journal Entries07:49
ACCTG 455: Excel Finance Class 54: Bonds & Interest Rate Risk10:43
ACCTG 455: Excel Finance Class 55: Tax Advantage of Muni Bond03:11
ACCTG 455: Excel Finance Class 56: Tax Implications For Zero Coupon Bonds.08:14
ACCTG 455: Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond11:15
ACCTG 455: Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates06:23
ACCTG 455: Excel Finance Class 59: Common & Preferred Stock15:32
ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets14:54
ACCTG 455: Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows.08:49
ACCTG 455: Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity03:26
ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model04:52
ACCTG 455 Excel Finance Class 64: How Stock Value Changes for Dividend Growth Model as Inputs Change07:57
ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model06:28
ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model03:55
ACCTG 455: Excel Finance Class 67: Irregular Dividend PMTs and Constant Growth: Stock Valuation.13:16
ACCTG 455: Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting16:34
ACCTG 455: Excel Finance Class 69: Net Present Value Profile: Table & Chart, Learn NPV Function18:41
ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value03:02
ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule09:35
ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return08:00
ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart19:23
ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR07:04
ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate10:06
ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return09:09
ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index02:29
ACCTG 455: Excel Finance Class 78: NPV Irregular Cash Flows & Time Period: XNPV, NPV, PV Functions06:39
ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index08:50
ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis07:46
ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses12:40
ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows17:05
ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation16:45
ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV07:10
ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows10:37
ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example.22:10
ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation07:33
ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations14:06
ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations10:54
ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock05:45
ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond04:18
ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond03:51
ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock02:41
ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR04:41
ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean03:55
ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return15:58
ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns03:52
ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation10:46
ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons)21:07
ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.03:29
ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data02:58
ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets04:15
ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean04:46
ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock11:43
ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio10:48
ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta13:59
ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods)11:16
ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index06:18
ACCTG 455: Excel Finance Class 109: Beta For Portfolio03:58
ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)09:17
ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM03:03
Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.18:52