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
ArrowCertificate Program in
     Quantitative Finance
     and Risk Management
ArrowCertificate Program in
     Applied Mathematical Finance
     for Engineers
ArrowCertificate Program in
     Algorithmic Trading
ArrowPost Graduate Program in
     Algorithmic Trading
ArrowCertificate Program in
     Derivatives Valuations
     & Risk Analytics
ArrowCertificate Program in
     VBA Programming for Finance
ArrowCertificate Program in
     Python Programming for
     Finance
Arrow FRM Training Program

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 (Online Batch)
    Course duration60 Hours
    Course feeINR 19,000/- (Plus Taxes)
    USD 350 (For Overseas Candidates)
    (Group discount available.)
    Schedule Saturdays and Sundays - 2:00 PM to 7: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.

    Mode 2 - Debit/Credit Card
    Payments can also be made through credit/debit cards. Please contact us for details of making payment through credit/debit cards.



    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