Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!
  • No products in the cart.

  • LOGIN

Login

Investment Banking courses with certification is the most sought after training course in the Finance domain today. This module has been designed by Subject Matter Experts to equip students with Ms Excel Course covering over 30 Formulas,  Company Valuation course with Relative Valuation Method, Financial Modeling course on Excel, Company Profiling course with 1 Page Template/Format. With real-life examples from the Industry, our online course gives the candidate immense exposure to understand how to go ahead and make assumptions and prepare a dynamic model to make precise business decisions.

This course will provide PDF based case studies which will give insights into building complex dynamic models in MS Excel using amazing formulas in order to maintain the dynamic nature of the model. Conducting Scenario Analysis, Ratio Analysis through the use of mesmerizing charts using Developer tab etc. will give the presenter of such projects an edge over his competitors.

  • Excel for Managers
  • Financial Modeling including DCF Method (04 Sectors)
  • Company Valuation – Relative Valuation Method (02 Sectors)
  • Company Profiling
  • Develop income statement, balance sheet, cash flow statement, debt schedules for different companies from different sectors
  • Conduct ratio analysis to gauge the performance of the firm
  • Prepare dynamic charts in Excel to make presentations
  • Project multi-year financial statements using industry techniques
  • Learn to calculate metrics such as NPV, IRR to check for project feasibility
  • Conduct sensitivity analysis, stress tests and dilution analysis to monitor the performance under different scenarios
  • Prepare dynamic models in Excel to look at outcomes for different arrangements with stakeholders
  • Understand and inculcate best practices from the industry to develop models
  • Use advanced tricks in Excel to make the model automated, robust and dynamic
  • Learn how to compare companies and value them through peer-to-peer analysis based on Relative Valuations
  • Understand and implement the concept of EV and its multiples
  • Get exposure to different styles of reporting in Indian and US-based companies; Form 10K, Form 10Q, Annual Report, CSR etc.
  • Learn the pros and cons of valuation techniques
  • Conduct rigorous financial analysis through ratios, debt schedules, scenarios etc.
  • Prepare insightful charts and graphs to gauge the performance of the project and compare across alternatives
  • Link the 3 statements using Excel to its full potential like a Pro
  • Have an On-the-job style training experience at home

All finance professionals and students who want to learn from the best institute for online training. Every person who wants have Investment Banking job/career and work at the biggest companies in will benefit from this course.

  • FRM Certified Course
  • Downloadable Videos gives you 24/7 offline access
  • Downloadable PDFs for Lifetime
  • Prepared by Corporate trainers
  • 100% Placement Assistance provided
  • Course Completion Certificate will be provided

MS Excel
  • Lecture 1.1 : Excel Basics
  • Lecture 1.2 : Excel as a Calculator
  • Lecture 1.3 : Error
  • Lecture 1.4 : Sort and Filter
  • Lecture 1.5 : Charts
  • Lecture 1.6 : Formatting
  • Lecture 1.7 : Aggregate
  • Lecture 1.8 : Function Wizard
  • Lecture 1.9 : Cell Referencing
  • Lecture 1.10 : Logical Functions
  • Lecture 1.11 : Lookup Functions
  • Lecture 1.12 : Index Match Function
  • Lecture 1.13 : Date Time text functions
  • Lecture 1.14 : Nested Functions
  • Lecture 1.15 : Annotating Formulae
  • Lecture 1.16 : Conditional Formatting
  • Lecture 1.17 : Custom Number Formatting
  • Lecture 1.18 : Hyperlink
  • Lecture 1.19 : Auto Filter
  • Lecture 1.20 : Subtotal
  • Lecture 1.21 : Data Consolidation
  • Lecture 1.22 : Data Validation
  • Lecture 1.23 : Age Calculator
  • Lecture 1.24 : Nested IF
  • Lecture 1.25 : Pivot Tables and Charts
  • Lecture 1.26 : Goal Seek
  • Lecture 1.27 : What If – Scenario Manager
  • Lecture 1.28 : Password Protection
  • Lecture 1.29 : Import Export Data
  • Lecture 1.30 : Amortization of Loan
  • Lecture 1.31 : Sparkline, Trendline, Candlestick Charts
  • Lecture 1.32 : Macros
  • Lecture 1.33 : VBA
  • Lecture 1.34 : SUMIF COUNTIF Functions
Financial Modeling
  •   Lecture 2.1 :  Cycle Manufacturer- XYZ Inc
  •   Lecture 2.2 :  Fast Food Chain- Burgerzz
  •   Lecture 2.3 :  Hospitality- Vintage Hotels Part 1
  •   Lecture 2.4 :  Hospitality- Vintage Hotels Part 2
  •   Lecture 2.5 :  DEL Constructors
Company Valuation
  •  Lecture 3.1 : IT Industry
  • Lecture 3.2 : Chemical Industry- Part 1
  • Lecture 3.3 : Chemical Industry Part 2 (Dilution Effect)
Company Profiling
  • Lecture 4.1 : IB_Company Profiling (FMCG Sector: Dabur)
Supported Desktop Browsers
  • Internet Explorer (IE9)(IE10)(IE11)
  • Microsoft Edge
  • Mozilla Firefox
  • Google Chrome
  • Safari
  • opera
Supported Operating Systems
  • Microsoft Windows 7 (or higher)
  • OSX (Last two major releases)
  • Most Linux Distributions
Supported Mobile Operating Systems
  • iOS 9 (or higher)
  • Android 6.0 (or higher)
Supported Mobile Browsers
  • iOS : Default browsers in version 9 and above
  • Android : Default browser in version 6.0 and above
Browser settings
  • JavaScript must be enabled.
  • Cookies must be enabled.
  • Local Storage must be enabled.

Click ‘TAKE  THIS COURSE’ button on this page. Give your details on Checkout Page and confirm payment.

Course Curriculum

Investment Banking
Investment Banking 20:00:00
TAKE THIS COURSE
  • $333.00 $100.00
  • 45 Days

Instructors

0 STUDENTS ENROLLED