您選擇的商品

Data Tables in Microsoft Excel

Kyle Maclean; Lauren E. Cipriano; Gregory S. Zaric;

商品編號:9B16E017
出版日期:2016/06/30
再版日期:2016/07/04
商品來源:Ivey
商品主題:Management Science
商品類型:Note
涵蓋議題:Excel;spreadsheet;modelling;analytics
難易度:4 - Undergraduate/MBA
內容長度:22 頁
地域:
產業:
事件年度:

The purpose of this note is to illustrate the use of Data Tables in Microsoft Excel. Data Tables are commonly used for performing sensitivity analyses, sometimes called “What If?” analyses, and for preparing data for graphs. Data Tables can also be used to enable a Monte Carlo simulation in a spreadsheet in more advanced models. The technical note includes practice exercises and their solutions, and a supporting Excel workbook for students.

教學手冊:
補充材料: