iife
Indian Institute of Quantitative Finance
Formerly Institute of Quantitative Finance (India)
Center of Excellence in Quantitative Finance and Financial Engineering
In fo Current Courses
ArrowCertificate Program in      Quantitative Finance and
     Risk Management
     Winter Session 2009
ArrowCertificate Program in
     Advanced Financial Modelling
     in Excel and VBA
ArrowCertificate Program in
     Financial Modelling in Excel
Arrow Financial Risk Management
Arrow FRM® 2010 Training Mumbai
Arrow FRM® 2010 Training Delhi
Arrow FRM® 2010 Training Kolkata
Arrow FRM® 2010 Training Bangalore
Arrow FRM® 2010 Training Hyderabad
Arrow FRM® 2010 Training Chennai

News Letter

Contact us Contact Us
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-9769860151 /
                             +91-22-28797660

Delhi Office:
S-3, Krishna Commercial Complex,
LSC-2, Mayur Vihar, Phase-II,
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

Kolkata Office:
3rd Floor, Webel Bhavan,
Salt Lake Electronics Complex,
Block EP & GP, Sector V,
Kolkata - 700091

Office Hours:
Weekdays : 10:00 AM - 5:30 PM (With Prior Appointment)
Saturdays & Sundays : 2:30 PM - 5:30 PM (With Prior Appointment)

Contact Person
Prabir Dutta : +91-33-23576081 /
                      +91-33-23576981

Certificate Program in
Advanced Financial Modelling in Excel and VBA






Financial Modelling using spreadsheets like MS Excel are used in many fields like financial analysis, risk analysis, valuations, investment management, credit analysis, scenario analysis, budgeting, sales forecast, financial projections, project evaluation, etc. Along with the use of Excel as a tool for modelling, these areas also demand the professional to have very good skills in writing macros and VBA programs. High-end Quant analysts need to know how to solve mathematical finance problems using VBA.


This course is designed for professionals who are interested in learning advanced financial modelling using MS Excel as well as VBA programming and their applications to finance and investing. 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 and ends with learning how to solve advaced mathematical finance problems by writing VBA programs.


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


MoreInformation Course Highlights

  • Comprehensive training in advanced VBA Programming along with Excel Modelling
  • Includes Mathematical Finance programming in VBA
  • 70 hours of intensive training
  • Practising Quant professionals and financial modellers as faculty
  • Hands on modeling and VBA programming
  • IIQF has trained over 200 professionals in this course over the past three years.
  • Access to online support for next one year


    • 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 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.
  • Price Derivatives.
  • Estimate Value-at-Risk forecasts.
  • Carry out Monte Carlo Simulations in Excel
  • Write VBA programs to solve Mathematical Finance problems that are required in high-end Quant problems.


    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 duration70 Hours
    Course FeeINR 25,000/-
    (15% Group discount for group of 4. 10% Early Bird discount till March 31, 2010)
    Centre Start Date Venue Timings
    Mumbai April 24, 2010 Corporate Avenue, Goregaon (E) Saturdays (4 PM – 8 PM) Sundays (10 AM – 2 PM)
    Delhi April 24, 2010 Vidya Institute, Connaught Place Saturdays (3 PM – 8 PM) Sundays (10 PM – 3 PM)
    Bangalore June 19, 2010 Golden Square, Koramangala Saturdays (3 PM – 8 PM) Sundays (10 PM – 3 PM)
    Online April 19, 2010 Online Mondays, Wednesdays, Fridays & Sundays
    (8.30 PM - 10 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 our Mumbai or Delhi office.

    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.

    Mode 3 - Credit Card
    Payments can also be made through credit card. Please contact us for details.


    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:
    S-3, Krishna Commercial Complex,
    LSC-2, Mayur Vihar, Phase-II,
    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





    • Web Development & eMarketing by www.bhartisoftland.com Bharti Softland
    Copyright © Indian Institute of Quantitative Finance Pvt Ltd. All Rights Reserved