Rock your resolutions. Take the Dummies challenge and you could WIN $1,000! Get Started.
How to Import Delimited Text Files in Excel 2013
How to Run the Excel PivotTable Wizard
How to Enter a Function in Excel with the Function Command

Set Up and Define Problems in Excel's Solver Add-In Utility

Click the target cell in the worksheet or enter its cell reference or range name in the Set Objective text box.

Next, you need to select the To setting. Click the Max option button when you want the target cell’s value to be as large as possible. Click the Min option button when you want the target cell’s value to be as small as possible. Click the Value Of option button and then enter a value in the associated text box when you want the target cell’s value to reach a particular value.

blog comments powered by Disqus
How to Use the Correlation Analysis Tool in Excel
How to Perform Analyses of Variance in Excel
How to Query an External Database in Excel
How to Use the Custom AutoFilter on an Excel Table
How to Use the Covariance Analysis Tool in Excel
Advertisement

Inside Dummies.com