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