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

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

### How to Create Pivot Table Data Model in Excel 2013

So far, we have focused exclusively on pivot tables that are generated from a single table of data. The Data Model feature has brought additional ...

### How to create a pivot table report in Excel

You can convert a huge table of data into an attractively printed report using a pivot table. The following figure shows a small portion of a pivot ...

### A Pivot Table Example in Excel with Real Data

We are going to work with a pivot table example in this section. We shall learn some useful ways to work with pivot tables. The following figure ... 