You are here

Decision Making Using Excel

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

Venue: Rigsum Institute, New Campus (behind Hotel Pedling)

Seats: 24

 

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.

Topics:

  • 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, charts

This workshop is being offered following the success of the first workshop in Nov, 2008.

 

When: 
Thursday, March 12, 2009 - 09:30 to Saturday, March 14, 2009 - 16:00