Excel Solver Guide (Easy and Step by Step)

This article contains a list of articles that explains this topic step wise. Follow the steps given in these articles systematically to solve complex problems using Excel Solver.

The following are two real-life problems we all have faced at one point of time.

Mathematical Problem:

4x+ y– 2z= 0
2x– 3y+ 3z= 9
–6x– 2y+ z= 0; Find out the values of x, y, and z.

As a student, you might have come across mathematical problems like the one above.

Business Problem:

Suppose you run a company that produces three products: Product A, Product B, and Product C. Your company’s profit profile will be similar to the table shown below:

From the table above, it is clear that, in order to maximize the profit, you should produce only Product C as it generates the highest per-unit profit. However, let’s add some more conditions for producing those products.

1. The production capacity of your company is 500 units per day.
2. Your company has to produce 100 units of Product A as your company has that amount of order.
3. Your company has to produce 80 units of Product B.
4. And the sales of Product C is on the lower end, so your company is not interested to produce more than 50 units of Product C per day.

You might face a dilemma in determining the production levels of Product A and Product B when the production of Product C is limited to 50 units or less.

In such scenerios, you can use the Excel Solver add-in.

Step by step guides on Excel Solver

The following are some step-by-step tutorials that will guide you on how to use Excel Solver in order to solve the problems similar to the above:

1. How to Use Solver in Excel (Solving Linear Programming Problems)!
2. A simple Solver example in Excel.
3. Solving simultaneous linear equations in Excel using Solver.
4. Minimizing shipping costs in Excel using Solver.
5. Allocating Resources in Excel using Solver.
6. Optimizing an investment portfolio using Excel Solver.
7. Excel Solver with a Case Study [Rate Your Sports Team]
8. Solving equations in Excel (polynomial, cubic, quadratic, & linear)

If you follow the above tutorials precisely, you will be able to solve a huge number of mathematical and business-related problems using Excel Solver.