Financial Modelling IIM Indore

I want to do Advanced Certificate In Financial Modelling program from the Indian Institute of Management Indore so please tell me is this College offers this course? What is the eligibility required and give me details about its admission procedure of it?

I want to get the details of Spreadsheet Modelling using MS-EXCEL program in Indian Institute of Management Indore so can you provided me the details of the program?

[pawan]

The Spreadsheet Modelling using MS-EXCEL programme aims to teach the participants how to use Microsoft Excel 2013 tool for modelling, reporting and solving several problems related to business.

Spreadsheet Modelling using MS-EXCEL

This is a rigorous hands-on course which is appropriate for beginners as well as proficient excel users. The exercises used in this programme are based on some commonly observed problems from different domains in management.

For Whom-

Anyone who deals with excel on a regular basis.

Residential Fee-

42,000
Service Tax, as applicable, will be additional

Content-

The course will cover, in-detail, the following basic and advanced topics:

Introduction to excel functionality (Absolute and Relative Referencing)
Using basic built-in functions (IF, VLOOKUP, INDEX, MATCH, COUNTIF, Text Functions )
Using advanced built-in functions (OFFSET, INDIRECT, Array formulae)
Data crunching tools (Data Tables, What-if analysis, Database functions, Pivot tables)
More complex excel functionality (Solver, Macros and introductory VBA)

The exercises to cover the above mentioned topics have been mainly chosen from HR, Operations, Legal, Accounting, Finance and Sales.

Programme Coordinator-

Prof. Harshal Lowalekar
Email: harshal@iimidr.ac.in
Phone: 0731-2439578

Contact-

Enquiry and Registrations

Management Development Programmes (MDP) Office
Indian Institute of Management Indore
Prabandh Shikhar, Rau-Pithampur Road
Indore 453556, Madhya Pradesh, INDIA

Email : mdp@iimidr.ac.in
Tel. : +91-731-2439750, 2439752, 2439753, 24397544
Fax : +91-731-2439751, 2439800