## Optimizing an investment portfolio using Excel Solver

This article is part of my series: Excel Solver – A Step by Step Complete How-to-use Guide. In our this example, we're going to demonstrate how to use Solver to get maximum return from an investment ...

## Resource Allocation Model in Excel Using Solver

In this article, you will learn how to build a resource allocation model in Excel using solver. Our motto is always making the best uses of available resources with the highest output.This ...

## SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax SUMPRODUCT (array1, , , ...)SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example say that components (A2, A3, A4, B2, B3, and B4) of Array1 ...

## If Excel doesn’t show the Solver command

This article is part of my series: Excel Solver – A Step by Step Complete How-to-use Guide. You can access Solver by choosing Data ➪ Analysis ➪ Solver. Sometimes it may happen that this command ...

## 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 our this example, we're going to find alternative options for shipping materials keeping total shipping ...

## 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 (MMULT, MINVERSE) to solve linear equations. That ...

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

In this article, we're going to use a simple example to introduce you to Solver technique and then in next article, we'll present some complex examples to explain what this feature can do for you. ...

## 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 Seek feature is one way to do Reverse What If ...

## Reverse What-If Analysis in Excel

In our 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 the results on other dependent cells. This ...

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

How to do scenario analysis in Excel? How to generate scenario summary report using Excel scenario manager feature? You will learn all these crucial data analysis topics in this article.So, let's ...

## 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 Excel What-If Analysis feature to perform the sensitivity analysis of a ...

## 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 explanation. In fact, the example we have used in the ...