Excel Templates Xls Format by dsh90311

VIEWS: 59 PAGES: 6

More Info
									Session 1C: Excel Review

         Dr. Frank Selto
           CURISES
 Cost and Managerial Accounting
Objectives
•   Efficient spreadsheet design and use
•   Self-documentation
•   Consistent format
•   Flexibility
Self Documentation
•   Sources of data
•   Modeling assumptions
•   Variable definitions
•   All clearly and easily accessible
•   Why?
Consistent Format
• Ease of use and communication
• Separate data entry section (or sheet)
  – ONLY place that data entry occurs
• Separate model analyses sections (or
  sheets)
  – Contain ONLY cell references and formulas
  – E.g., = B2*B3
Flexibility
• Ease of manipulation for
  – What-if or sensitivity analysis
  – Scenario analysis
• Ease of data and model revision
Examples
• Simple example
• ..\Excel templates\1.38.xls

								
To top