Download
1 / 4
60 likes | 194 Views
Introduction to Management Science. Appendix B. Tips for Using Microsoft Excel for Modeling. Anatomy of the Microsoft Excel Window Working With Workbooks. Tips for Using Microsoft Excel for Modeling. Naming and adding worksheets Using worksheets with solver
E N D
Introduction to Management Science Appendix B
Tips for Using Microsoft Excel for Modeling • Anatomy of the Microsoft Excel Window • Working With Workbooks
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
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
