The intent of this note would be to illustrate the use of Information Tables in Microsoft Excel. Info Tables are popular for performing sensitivity analyses, sometimes called "What If?" evaluations, and for preparing data for graphs.
Data Tables can also be used to empower a Monte Carlo simulation in a spreadsheet in more advanced models. The technical note consists of training exercises and their solutions along with a supporting Excel workbook for pupils.
PUBLICATION DATE: July 04, 2016 PRODUCT #: W16417-HCB-ENG
This is just an excerpt. This case is about TECHNOLOGY & OPERATIONS
Related Case Solutions & Analyses:
Business Processes & Operations
eLance.com: Preventing Disintermediation
Applications of Business Analytics in Healthcare
Global Knowledge Management at Danone (A) (Abridged)
Microsoft IT India
Changing the Game of Outsourcing – the Microsoft OneFinance Case
Global Diversity and Inclusion at Royal Dutch Shell (B): The Impact of Restructuring
Electronic Medical Records System Implementation at Stanford Hospital and Clinics
Open Text Corporation
Operations Management: An Introduction to Process Analysis
