How to use the power of the spreadsheet to perform their day-to-day analysis effectively and efficiently

How to use basic modelling tools such as optimisation and what-if analysis to make better informed decisions

How to perform basic data analysis using Excel statistical functions to facilitate day-to-day analysis and decision-making

Introduce tools for decision making including resource optimization, product mix decisions, personnel planning, capacity planning and for modeling uncertainty

For: This programme is designed to benefit all those individuals who are actively involved in the decision making process of their organizations. This includes those who actually take decisions and those who provide analytical support to the decision maker. The former comprises all mid to senior level executives, while the latter includes consultants and analysts - financial analysts, operations analysts, marketing analyst, etc.

Contents: The first part of the course will introduce some of the most useful EXCEL functions that help handle and manipulate data efficiently. Here, functions such as COUNTIF, SUMIF, GOAL SEEK, DATA TABLES and PIVOT TABLES will be introduced in the context of specific business problems.

The second part deals with describing and summarizing data and capturing relationships between various factors. Here, concepts such as Histograms Descriptive statistics, Regression, Correlation and Forecasting techniques will be covered. This will help in valuable analysis such as: -

How to spot outliers in data?

How can trends be detected from the data?

How can sales be forecasted?

In the third part, how to identify the "best" decision using optimization modeling and sensitivity analysis will be covered. Some typical questions that optimization modeling seeks to answer are: -

Where to expand capacity?

How to schedule resources and personnel?

What product mix will maximize profit?

How to minimize distribution costs?

In the last part, Monte-Carlo simulation will be introduced as a tool to model uncertainty. Some typical applications covered will be: -

Given the uncertainty in the demand for products and services such as hotel rooms, airline and bus seats, how to price them in order to maximize yield?

How to plan projects under uncertainty?

How to plan on staffing levels?

Fees:
Residential: Rs. 30,000/-
Non-Residential: Rs. 22,000/-

Mail your queries to
Prof. Ishwar Murthy : ishwar@iimb.ernet.in
Prof. Rajluxmi V. Murthy : rvm@iimb.ernet.in

Chief Programmes Officer,
Indian Institute of Management Bangalore,
Bannerghatta Road, Bangalore - 560 076.
Phone: 080-26993742 / 3264 / 3475
Fax: 080-26584004 / 26584050
E-mail: edp@iimb.ernet.in
Website: http://www.iimb.ernet.in/
Refer: CoolAvenues' MDP Alert

Click here to post your views/ comments/ experience on this program...