Indian Institute of Quantitative Finance
Indian Institute of Quantitative Finance
Center of Finance Excellence - Quantitative Finance and Risk Management
Industry Partners
and Clients



In fo Current Courses

News Letter

Proud to be awarded the National Education Leadership Awards by Dainik Bhaskar and Lokmat




Certificate Program in
Financial Modelling in Excel



In business people regularly have to deal with situations 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.


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


Click here to see our student testimonials


Faculty List


MoreInformation Course Highlights

  • Comprehensive training in Financial Modelling using Excel
  • 60 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 build 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 start dateTo be announced (Mumbai)
    Course duration60 Hours
    Course feeINR 25,000/- (Plus S.T. @15%)
    (Group discount available.)
    Schedule Saturdays and Sundays


    Course start dateTo be announced (Online Batch)
    Course duration60 Hours
    Course feeINR 19,000/- (Plus S.T. @15%)
    USD 340 (For Overseas Candidates)
    (Group discount available.)
    Schedule Saturdays and Sundays - 3:00 PM to 8:00 PM (Indian Standard Time)

    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 (by prior appointment)

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



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