Introduction to Management Science

Appendix B

1

2

Tips for Using Microsoft Excel for Modeling

• Anatomy of the Microsoft Excel Window• Working With Workbooks

3

Tips for Using Microsoft Excel for Modeling

• Naming and adding worksheets• Using worksheets with solver– Model must be confined to a single sheet– The solver information is saved with the sheet– Separate sheets can contain separate models– Copy the whole worksheet rather than just the

relevant cells to copy models

4

Tips for Using Microsoft Excel for Modeling

• Working with cells– Selecting cells– Entering or editing data, text, and formulas into

cells– Moving or Copying Cells– Filling cells– Relative and absolute references– Using range names– Formatting cells