Office.com results
Define and solve a problem by using Solver
Article Solver is part of a suite of commands sometimes called what-if analysis tools. With Solver, you can find an optimal value for a formula in one cell — called the...
Excel 2007
Project values in a series
Article Fill in a series that fits a simple trend, use functions to extend complex and nonlinear data, or perform regression analysis with the Analysis ToolPak Add-in.
Excel 2007
Use Goal Seek to find the result you want by adjusting an input value
Article If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For exam...
Excel 2007
How to do 40 different what-if analyses quickly
Article By Bill Jelen Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , whi...
Excel 2007
Switch between various sets of values by using scenarios
Article A scenario is a set of values that Microsoft Office Excel saves and can substitute automatically on your worksheet. You can create and save different groups of ...
Excel 2007
Using Solver for financial planning
Article Learn how to use the Solver add-in for Excel to help with your financial planning.
Excel 2007
Using Solver for capital budgeting
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
Calculate multiple results by using a data table
Article In Excel 2007, a data table is a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas.
Excel 2007
Introduction to what-if analysis
Article By using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various resul...
Excel 2007
Using Solver to solve transportation or distribution problems
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
Using Solver to determine the optimal product mix
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
Using Solver to schedule your workforce
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
An introduction to optimization with the Excel Solver tool
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
Analyze business results with Excel 2007
Article Microsoft Office Excel 2007: Data Analysis and Business Modeling By Wayne L. Winston Wayne L. Winston is a professor of Decision Sciences at Indiana University’...
Excel 2007
Using Solver to rate sports teams
Article This article was adapted from Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L. Winston. Visit Microsoft Learning to learn more about ...
Excel 2007
Use the Analysis ToolPak to perform complex data analysis
Article Develop complex statistical or engineering analyses, for example regression analysis, by using the Analysis ToolPak in Microsoft Excel.
Excel 2007
Perform What-If Analysis with the Excel 2007 Solver Tool
Article Learn how to perform "what-if" analysis with the Excel 2007 Solver tool.
Excel 2007
Back into an answer using Goal Seek
Article Use the Goal Seek command to determine the size of a loan you could take based on the amount you budgeted. This example is an excerpt from MrExcel’s book.
Excel 2007
Didn't find what you were looking for?Search all of Office.com