You are here

Decision Making Using Excel

Instructor: Galit Shmueli, Ph.D. Associate Professor of Statistics, University of Maryland.

Venue: Druk School computer lab (Above hospital)

Seats: 19

Summary: Data is an essential part in project planning and decision making. This workshop, intended for top level management & decision makers, will show how Excel can be used effectively for quantifying uncertainty, managing risk, and understanding and presenting data. Participants will actively use Excel throughout the workshop.

Pre-requisite knowledge: Basic knowledge of Excel. This workshop is intended for top management and decision makers.


  • Excel in Business
  • Long term project planning (NPV, demand curve, optimization, diversification)
  • Quantifying uncertainty & risk management (Expected values, variability, correlation, portfolios)
  • Data management (organizing data effectively)
  • Data summarization & presentation (summary statistics, effective tabulation & aggregation, Simpson's paradox, effective data visualization)
  • Excel functionalities: statistical & economic functions, one-way & two-way tables, pivot tables, scenario manager, solver add-in, data analysis add-in, charts
Thursday, November 20, 2008 - 09:30 to Friday, November 21, 2008 - 16:30