Managerial Decision Modelling with Spreadsheets Course Duration: 40 Hrs I

Explore

Overview of the Course Objectives of the program II III Indicative Course Content IV Class Setup V Target Audience VI Faculty Course Fee: Rs 29,999/- Module-I: Overview of the course Topics Today many business entities capture enormous amount of data in various formats that can be easily transported to spreadsheets like MS-Excel. Spreadsheet computing has become one of the essential skills for today’s executives to get full benefits from such past data. Spreadsheets help manager to build various decision models that can help them to arrive at better decisions. This program covers Spreadsheet based techniques used to guide business decisions. Decision modeling and analysis will be the core of the course. MS-Excel will be used for computational work.

Next

Module-II: Objectives of the program: This course focuses on modeling, analyzing, and ultimately solving business decision problems on Excel Spreadsheet.
The focus of the course will be on modeling, analysis and interpretation rather than the underlying mathematical theory
or computational algorithms. This practical approach to problem solving will not only complement the theoretical one
but also help managers, who find spreadsheets a natural, intuitive, and user friendly platform for organizing information
and performing “what if” calculations, which has made them indispensable tools of modern business analysis.

Next

Module-III: Indicative Course Content Topics Introduction to Managerial Decision Modelling
 Basics of Spreadsheet Computing
 What-If and Sensitivity Analysis
 Optimization and Linear Programming
 Transportation and Network Models
 Decision Analysis
 Forecasting Techniques
 Queuing Models
 Simulation Modelling
 Analytics using Spreadsheets
 Data Visualization

Next

Module-IV: Class Setup Topics The course involves a hands-on, in-class learning, so attending each class, on time, and actively participating in problem solving on laptops in class are absolutely essential. Course requirements consist of developing, analyzing, and solving spreadsheet models of assigned problems and cases, and exams.

Next

Module-V: Target Audience The program is ideally suited for executives dealing with decisions using variety of data and want to enhance their spreadsheet modeling skills. Executives working as Business Analysts, Data Analysts, and Data Scientists would also benefit from this program. Topics Duration: 40 Hrs Course Fee: Rs 29,999 For corporate: INR 999 including GST Per Participant (Minimum 10 required) Faculty Dr. Santanu Mukherjee. Ph.D. from IIT Dhanbad.
Dr. Santanu has over 30 years of experience spread in multiple vertical and horizontal business domains across some of the industry leaders i.e. SAIL, CMC Ltd, Tata Steel, CRIS and Satyam. Moreover, he has been recognized as an accomplished teacher and researcher in the domain of management education for his ability to relate industry experiences with the management theories within a classroom. He is at present associated with Dynavision Digitech Private Ltd (Dygitech) as CEO.

Main Menu