Excel provides several useful tools for sharing your actual workbooks, rather than just the information they contain. You can tell Excel to save or open workbooks in formats accept- able to other spreadsheet programs. You can direct Excel to save your workbooks on a net- work drive and then make the … [Read more...] about Sharing Workbook Files in Excel
Using Excel
Using OLE with Excel
Microsoft Windows itself provides a powerful and easy-to-use tool for sharing data known as OLE, or Object Linking and Embedding. With OLE, you can transfer data between Excel and other Windows’ programs, as described in the paragraphs that follow. How OLE Works In order to make sense of OLE, it’s … [Read more...] about Using OLE with Excel
Optimization Modeling with Solver in Excel
Excel’s Solver tool lets you solve optimization-modeling problems, also commonly known as linear programming programs. With an optimization-modeling problem, you want to optimize an objective function but at the same time recognize that there are constraints, or limits. While this abstract … [Read more...] about Optimization Modeling with Solver in Excel
Simple Modeling with Goal Seek in Excel
You can use the Goal Seek command to determine which input value for a formula pro- duces a specified formula result. Goal Seek, then, lets you quantify what needs to happen in order to achieve some specified result. Rather than supplying a set of formula inputs and letting Excel calculate the … [Read more...] about Simple Modeling with Goal Seek in Excel
What-If Analysis with Scenario Manager in Excel
Data tables, as discussed in the earlier sections of this chapter, let you perform what-if analysis when you change one variable and explore the effect on a small handful of formulas or when you change two variables and explore the effect on a single formula. But this approach doesn’t work except in … [Read more...] about What-If Analysis with Scenario Manager in Excel
What-If Analysis with Data Tables in Excel
Excel lets you easily create simple data tables that show how changing a formula input affects the formula result. You can, for example, build simple one-variable data tables that show how changing a single input value affects one or more formulas. And you can also create more com- plicated … [Read more...] about What-If Analysis with Data Tables in Excel