Indian Institute of Quantitative Finance
Indian Institute of Quantitative Finance
Center of Excellence in Quantitative Finance and Financial Engineering
In fo Current Courses
ArrowPost Graduate Program in      Financial Engineering
ArrowCertificate Program in
     Applied Mathematical Finance
     for Engineers
ArrowCertificate Program in
     Financial Modelling in Excel
ArrowCertificate Program in
     Advanced Financial Modelling
     in Excel and VBA Programming
Arrow Financial Risk Management
Arrow FRM® 2012 Training Mumbai
Arrow FRM® 2012 Training Delhi
Arrow FRM® 2012 Training Kolkata
Arrow FRM® 2012 Training Bangalore
Arrow FRM® 2012 Training Hyderabad
Arrow FRM® 2012 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:
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

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 Investment Bankers and Treasury Managers as faculty
  • Hands on modeling on live case-studies


    • 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.
  • Record and use Excel Macros for implementing advanced functionalities in Excel.
  • Valuation of companies, IPOs
  • Valuation of Mergers and Acquisitions
  • Bonds valuations and risk analysis
  • Carry out financial analysis, forecasting, etc.

    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/- (Group discount available.)
    Course Starting DateFebruary 11, 2012 (Mumbai)
    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 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.

    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





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