Define and solve a problem by using Solver - Microsoft Support
Learn how to use Solver, a Microsoft Excel add-in program, to find optimal values for a formula in one cell subject to constraints on other cells. See examples, steps, options, and tips for linear and nonlinear problems.
STDEV function - Microsoft Support
Learn how to use the STDEV function in Excel to estimate standard deviation based on a sample of data. Find out the syntax, arguments, formula, and examples of this function.
Calculate multiple results by using a data table
A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the …
Change the source data for a PivotTable - Microsoft Support
Learn how to modify the range of data that a PivotTable uses, or change the data source to a different Excel table, cell range, or external data source. Follow the steps and examples for Windows, Web, or Mac.
Macro Error - Microsoft Support
The Macro Error message appears when there is an error in the macro that you were running. The specified method cannot be used on the specified object for one of the following reasons: An argument contains a value that is not valid.
Introduction to What-If Analysis - Microsoft Support
Learn how to use Excel tools to perform what-if analysis, which is the process of changing the values in cells to see how they affect the outcome of formulas. Compare scenarios, data tables, goal seek, solver, and forecasting methods with examples and links to help topics.
Automatically number rows - Microsoft Support
Learn how to add sequential numbers to rows of data in Excel by using the fill handle or the ROW function. Find out how to display, hide, or update the fill handle and the numbering sequence.
VLOOKUP function - Microsoft Support
Learn how to use VLOOKUP to find values in a table or a range by row in Excel. See examples, tips, common problems, and best practices for this function.
DELTA function - Microsoft Support
This article describes the formula syntax and usage of the DELTA function in Microsoft Excel. Description. Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs.
GAMMAINV function - Microsoft Support
This article describes the formula syntax and usage of the GAMMAINV function in Microsoft Excel. Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST (x,...), then GAMMAINV (p,...) = x. You can use this function to study a …
TODAY function - Microsoft Support
Learn how to use the TODAY function in Excel to return the current date as a serial number or a date format. See examples of how to calculate intervals, ages, and days of the week with the TODAY function.