Indian Institute of Quantitative Finance
Indian Institute of Quantitative Finance
Center of Excellence in Quantitative Finance and Financial Engineering
In fo Current Courses

News Letter
Financial Risk Management, FRM, GARP
We are Authorised Exam Prep Provider for FRM® conducted by GARP®.
Know More About FRM® Programs Below .

Certificate Program in
Advanced Financial Modelling using MS Excel and VBA Programming


Financial Modelling using spreadsheets like MS Excel are used in many fields like investment banking, mergers and acquisitions, equity research, risk analysis, valuations, investment management, credit analysis, scenario analysis, budgeting, sales forecast, financial projections, project evaluation, etc. This is a program where practicing Investment Bankers and Treasury Professionals teach the latest techniques and modeling skills that are used in the industry.


Lot of financial professionals who do all kinds of financial modelling feel handicapped to quite a large extent in implementing certain models that requires them to do considerable amount of programming in VBA. Merely knowing how to record or even write some odd macros in VBA is not of any help to them. There is no specialized course in IT domain that teaches “VBA Programming for Finance”, a course that teaches VBA programming with exclusive focus on Financial Applications.


This is why we have designed this course tailor-made for imparting these skills. This course, apart from teaching financial modeling, has an extensive module on VBA Programming for Finance and Advanced Financial Modelling using VBA. The course starts with learning how to use advanced tools of Excel, then goes on to learn to write VBA programs to help in financial modelling, value derivative instruments of various asset classes using the advanced models being used by the industry and ends with learning how to carry out porfolio risk analysis.


Click here to get the Brochure and detailed Syllabus for the program


MoreInformation Course Highlights

  • The course faculty are investment bankers and treasury professionals
  • Comprehensive training in VBA Programming for Finance along with Advanced Excel Modelling
  • 150 hours of intensive training
  • Exposure to real-world models actually being used in the industry

  • MoreInformation Course Objective
    This is a "hands-on" course, with extensive use of computers and spreadsheets. The objective is to develop VBA programming, spreadsheet and modelling skills for creating computer-based models for analyzing a variety of decision problems facing today’s financial managers and investment banking professionals. The assignments are designed to be similar to assignments delegates will encounter in their jobs.

    Click here to get the Brochure and detailed Syllabus for the program

    MoreInformation Learning Outcomes
    Delegates will learn to :
  • Create MS Excel based financial models
  • Use the advanced tools of Excel.
  • Write VBA programs for implementing advanced functionalities in Excel
  • Carry out financial analysis, forecasting, etc.
  • Valuation of company
  • Bond Valuation
  • Valuation of Mergers and Acquisitions
  • Carry out Monte Carlo Simulations in Excel
  • Price Derivatives
  • Estimate Value-at-Risk forecasts

    MoreInformation Who Should Attend
  • Financial Analysts
  • Research Analysts
  • Risk Analysts
  • Credit Analysts
  • Investment Managers
  • M&A Professionals
  • Finance Controllers
  • Subject Matter Experts
  • Managers from corporates
  • Management students
  • IT Professionals

    MoreInformation Course Details
    Course start dateFebruary 11, 2012 (Mumbai)
    Course duration150 Hours
    Course feeINR 45,000/- (Group discount available.)
    Timings Saturdays 3:00 PM to 8:00 PM
    Sundays 10:00 AM to 3:00 PM
    MoreInformation Registration Process

    You may register online by filling up the form given here .

    Modes of payment

    Mode 1 - Cheque/Demand Draft
    Payments are accepted in the form of Cheque/DD in favor of "INDIAN INSTITUTE OF QUANTITATIVE FINANCE PVT. LTD." payable at Mumbai. Please mention your name, email, telephone number and your course of interest along with the payment.

    Please mail your payment to :
    Indian Institute of Quantitative Finance
    Module No. 624, Mastermind IV,
    Royal Palms IT Park, Goregaon (E),
    Mumbai - 400065

    Mode 2 - Wire Tranfer (NEFT/RTGS)
    Payments can also be made through internet banking. Please contact us for details of making payment through internet banking.


    Contact Details

    Mumbai Office:
    Module No. 624, Mastermind IV,
    Royal Palms IT Park, Goregaon (E),
    Mumbai - 400065

    Office Hours:
    Weekdays : 10:00 AM - 7:30 PM
    Saturdays & Sundays : 2:30 PM - 7:30 PM

    Contact Person:
    Nitish Mukherjee : +91-22-28797660 / +91-9769860151

    Delhi Office:
    F-109 Vardhman Plaza Complex LSC 2,
    Pocket B Mayur Vihar 2
    Delhi – 110091

    Office Hours:
    Weekdays : 10:00 AM - 7:30 PM
    Saturdays & Sundays : 2:30 PM - 7:30 PM

    Contact Person:
    Alok Bharti : +91-9810054323





  • Copyright © Indian Institute of Quantitative Finance Pvt Ltd. All Rights Reserved