Learn Advanced Excel, VBA Macros or MS Access

Buy DVD and Learn Self

Excel Financial Modeling with VBA

Microsoft Excel can be an invaluable resource for investors wanting to dig into more detail on financial market data. There are literally hundreds of ways to use Excel to manipulate financial data and help it improve the investment process. In this tutorial, we will examine some of the more useful tools used in Excel for finance.

Buy DVD Now

PART=1

        Excel Finance Class 01: Intro To Excel 2007 & 2010

        Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References

        Excel Finance Class 03: Math Operators and Order of Operations

        Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations

        Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting

        Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas

        Excel Finance Class 07: Stylistic Formatting

        Excel Finance Class 08: Intro To Corporate Financial Management

        Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market Value

        Excel Finance Class 10: Income Statement, Non Cash Depreciation Expense, Matching Principal

        Excel Finance Class 11: Finance Cash Flow From Accounting Information

        Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates

        Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short

        Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis

        Excel Finance Class 15: Common Sized Financial Statements

        Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated

        Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier, more...

        Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days

        Excel Finance Class 18.5: Ratios For Cash Cycle In Days.

        Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis

        Excel Finance Class 20: Growth Ratios and Market Value Ratios

        Excel Finance Class 21: Future Value Lump Sum Calculations, Simple & Compound Interest

        Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function

        Excel Finance Class 23: Solve For Total Number Of Periods When You Know PV, FV and Period Rate

        Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV and # of Periods

        Excel Finance Class 25: Future Value For Lender Or Borrower

        Excel Finance Class 26: Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions

        Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis and PV Function

        Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate

        Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function)

        Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly

        Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function)

        Excel Finance Class 32: Calculate Present Value of Annuity (PV Function)

        Excel Finance Class 33: Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions

        Excel Finance Class 34: Present Value Of Annuity For Asset Valuation

        Excel Finance Class 35: Calculate PMT for Present Value of Annuity PMT Function for Loan Payment

        Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR with Points and RATE function

        Excel Finance Class 37: How Much Do I Get Each Month During Retirement?

        Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity

        Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment

        Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula

        Excel Finance Class 41: Interest Only Loan Schedule.

        Excel Finance Class 42: Consumer Amortized Loans

        Excel Finance Class 43: Business Amortized Loans

        Excel Finance Class 44: Deep Discount Loans

        Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect

        Excel Finance Class 46: Bonds: Just Set Of Cash Flows Discounted At Market Rate, Coupon or Zero

        Excel Finance Class 47: Selling Bond When Coupon Rate Is Different Than Discount Rate (YTM Rate)

        Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT

        Excel Finance Class 49: Bond Quoted Price & Yield To Market

        Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price (Scatter Diagram Excel Chart)

        Excel Finance Class 51: Par - Discount - Premium Bonds

        Excel Finance Class 52: Bond Discount Or Premium Amortization Table.

        Excel Finance Class 53: Bond Discount Or Premium Journal Entries

        Excel Finance Class 54: Bonds & Interest Rate Risk

        Excel Finance Class 55: Tax Advantage of Muni Bond

        Excel Finance Class 56: Tax Implications For Zero Coupon Bonds.

        Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond

        Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates

        Excel Finance Class 59: Common & Preferred Stock

        Excel Finance Class 60: Basics Of Financial Markets

        Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows.

        Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity

        Excel Finance Class 63: Stock Valuation with Dividend Growth Model

        Excel Finance Class 64: Chart How Stock Value Changes for Dividend Growth Model as Inputs Change

        Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model

        Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model

        Excel Finance Class 67: Irregular Dividend Payments, Followed by Constant Growth -- Stock Valuation.

        Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting

        Excel Finance Class 69: Net Present Value Profile -- Build Table and Chart in Excel NPV Function

        Excel Finance Class 70: Investment Criteria: Net Present Value

        Excel Finance Class 71: Investment Criteria: Payback Rule

        Excel Finance Class 72: Investment Criteria: Average Accounting Return

        Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function Plot Chart

        Excel Finance Class 74: IRR and Non-conventional Cash Flows, Plot Chart To See Multiple IRR

        Excel Finance Class 75: IRR and Mutually Exclusive Projects - Plot Chart To See Cross Over Rate

        Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return

        Excel Finance Class 77: Investment Criteria: Profitability Index

        Excel Finance Class 78: NPV For Irregular Cash Flows and Time Periods XNPV, NPV and PV functions.

        Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index

        Excel Finance Class 80: Recognizing Patterns of Cash Flows For Discounted Cash Flow Analysis

        Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses

        Excel Finance Class 82: Relevant Costs For Discounted Cash Flow Analysis = Incremental Cash Flows

        Excel Finance Class 83: Estimating Cash Flows For NPV calculation

        Excel Finance Class 84: Undoing Accrual Accounting to Discover Cash Flows For Estimating NPV

        Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows

        Excel Finance Class 86: Estimating Cash Flows For NPV calculation Comprehensive Example.

        Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation

        Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations

        Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations

        Excel Finance Class 90: Period (Holding) Returns For Stock

        Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond

        Excel Finance Class 92: Period (Holding) Returns For Zero Bond

        Excel Finance Class 93: Period (Holding) Returns For Preferred Stock

        Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR

        Excel Finance Class 95: Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean

        Excel Finance Class 96: Comparing Geometric Mean with Arithmetic Mean For Average Stock Returns

        Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns

        Excel Finance Class 98: Stock Return Variation Measured with Standard Deviation (Risk of Stock)

        Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.

        Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data

        Excel Finance Class 102: In The Short Run Financial Markets Can Be Inefficient Mispriced Assets

        Excel Finance Class 103: 2 Ways To Calculate Geometric Mean

        Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock -- Estimating Future

        Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio -- Estimating Future

        Excel Finance Class 106: Unexpected Information, Market & Asset Specific Risk, Diversification, Beta

        Excel Finance Class 107: Calculating Beta (2 Methods) & Chart Beta, SLOPE CORREL & STDEV functions

        Excel Finance Class 108: Reward To Risk Ratio - Treynor Index

        Excel Finance Class 109: Beta For Portfolio

        Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)

        Excel Finance Class 111: Treynor Index & CAPM

        Excel Finance Class 111: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean

        Excel Finance Class 111: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula

     Course Duration & Fees

         Around 15 Hours Video

         Live Online Class Video

         Fees : - 2500/-

Buy DVD Now

Sample Videos

Advanced Excel & MIS Training Institute

Part of IPT (Institute of Professional of Training)
This is Group of Working Professianal Do Frelance with Us you can join our Class from your Computer using Gotomeeting

Operational Office : - Dakshinpuri, New Delhi - 110062
E-Mail - Kumar@iptindia.com, sujeetkumar.ipt@gmail.com, Skype ID - AdvExcel1

Mobile - +91 8802579388, +91 8826828093, +91 9968811487

         

Live Online Class