About 400 results
Open links in new tab
  1. Define and solve a problem by using Solver - Microsoft Support

    Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell—called the objective …

  2. Load the Solver Add-in in Excel - Microsoft Support

    The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel.

  3. Use Excel as your calculator - Microsoft Support

    Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature …

  4. Using Solver to determine the optimal product mix

    Oct 14, 2025 · Use Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix.

  5. PMT function - Microsoft Support

    How to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.

  6. Introduction to What-If Analysis - Microsoft Support

    By using Solver, you can find an optimal value for a formula in one cell—called the target cell—on a worksheet. Solver works with a group of cells that are related to the formula in the target cell.

  7. SLOPE function - Microsoft Support

    This article describes the formula syntax and usage of the SLOPE function in Microsoft Excel. Description Returns the slope of the linear regression line through data points in known_y's …

  8. XIRR function - Microsoft Support

    This article describes the formula syntax and usage of the XIRR function which returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

  9. SUMPRODUCT function - Microsoft Support

    The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays. The default operation is multiplication, but addition, subtraction, and division are also possible. …

  10. LINEST function - Microsoft Support

    The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.