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
Financial Modelling in Excel






People regularly have to deal with situations in business where they have to make some decisions after analyzing some data. In such cases they often build a spreadsheet model of their problems. 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, skills in recording, writing and using Macros in Excel is also required.


This course is designed for professionals who are interested in learning financial modelling using MS Excel and basic VBA macro writing skills 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 model various kinds financial situations and ends with learning how to do Monte Carlo Simulations in Excel.


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


MoreInformation Course Highlights

  • Comprehensive training in Financial Modelling using Excel
  • 50 hours of intensive training
  • Practising Quant professionals and financial modellers as faculty
  • Hands on real life financial modelling and writing macros
  • IIQF has trained over 300 professionals in this course.
  • 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 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.
  • Carry out Monte Carlo Simulations in Excel


    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 duration50 Hours
    Course FeeINR 15,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 (10 AM – 2 PM) Sundays (3 PM – 7 PM)
    Delhi April 24, 2010 Vidya Institute, Connaught Place Saturdays (4 PM – 8 PM) Sundays (10 PM – 2 PM)
    Online April 20, 2010 Online Tuesdays & Wednesdays(8.30 PM - 10 PM)
    Sundays (9 AM – 12 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 or Delhi. 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