Latest Posts

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 ...

Minimizing shipping costs in Excel using Solver

This article is part of my series: Excel Solver – A Step by Step Complete How-to-use Guide. In this example, we're going to find alternative options ...

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 Two Variable Data Table in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. In this article, we're going to create a ...

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 ...

Performing manual what-if analysis in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. A manual what-if analysis doesn’t require too much ...

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

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. Excel can handle much-sophisticated models than the ...

A What-If example in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. You can create dynamic models in Excel. This is one of ...

ExcelDemy
Logo