### Resource Allocation Model in Excel Using Solver

In this article, you will learn how to build a resource allocation model in Excel using the solver. Our motto is always making the best use of ...

### SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...) SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example says ...

### If Excel doesn’t show the Solver command

This article is part of my series: Excel Solver Guide (Easy and Step by Step). You can access Solver by choosing Data ➪ Analysis ➪ Solver. Sometimes ...

### How to solve simultaneous linear equations in Excel using Solver

In this blog post, I will show you how to solve simultaneous linear equations in Excel using solver add-in. You can also use Excel Matrix functions ...

### Excel Solver with a Simple Example (Step by Step)

In this article, we're going to use a simple example to introduce you to the Solver technique, and then in the next article, we'll present some ...

### Goal Seek in Excel 2013 – How to Use Guide

In this tutorial, you will learn single-cell goal seek in Excel 2013. I have used a "mortgage loan" example to demonstrate the whole process. Goal ...

### Reverse What-If Analysis in Excel

In this series of articles: What-If Analysis in Excel, we have discussed what-if analysis— the process of changing values of input cells to observe ...

### How to Do Scenario Analysis in Excel (with Scenario Summary Report)

How to do scenario analysis in Excel? How to generate/create a scenario summary report using the Excel scenario manager feature? You will learn all ...

### How to create a one variable data table in Excel

In this article, I am going to explain how to create a one-variable data table in Excel. Data tables are important parts of the Excel What-If ...

### Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important is the last row of the data containing, say, the ...

### Types of What-If analysis in Excel 