## How to Assign Work Using Evolutionary Engine?

Previously, I have made a brief introduction on the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use Evolutionary Engine to solve a problem in real life. 1....

## GRG Multistart and Evolutionary Excel Solver Engines [2 Case Studies]

Previously I have written an article on how to rate sports team using GRG Nonlinear engine, today I’d like to continue to discuss GRG Nonlinear engine in more details. 1. Understand GRG Nonlinear Engine...

## How to Make an Excel Add-in [Narrated with an Example]

So, you mastered VBA (or not) and automated that extremely complicated operation that consumes all your time. Let’s call your invention SuperFunction. But what would you do if your boss tells you to do...

## Excel Solver with a Case Study [Rate Your Sports Team]

Ratings are numerical representations of competitive strength which is directly comparable. It is often applied directly to predict the game outcome between any two teams. The Sports rating systems have been around for almost...

## Financial Planning with Excel Solver [2 Case Studies]

Most of us need to determine the monthly payment or the amount of money to be saved for retirement over life. It is not easy to do such kind of calculations manually. Fortunately, Excel...

## Use Excel Solver to Determine Which Projects should be Undertaken

Companies need to know which projects should be undertaken in order to produce greatest NPV (net present value) when there are limited resources. Applying Excel Solver can help solve this kind of problem. To...

## Solving Transportation or Distribution Problems using Excel Solver

It is well known that companies not only manufacture products at different locations but also ship their products to the customer at different locations. Distribution managers need to allocate and ship merchandise in the...

## Schedule Your Workforce using Excel Solver [4 Case Studies]

I have written an article on how to determine the optimal product mix using Excel Solver. Today, I’d like to discuss how to schedule workforce with the same method. Schedule a workforce is also...

## Using Excel Solver to Determine the Optimal Product Mixtures

In many situations, we may want to find the best way to do something. For example, companies often need to determine the amount of each product that should be produced during a month to...

## Breakdown of an Array Formula – Array Formula Basic Part 2

If you’re a regular follower of my blog, you know that I have started writing a series of articles on Excel Array Formula. In the first article, I have demonstrated what are arrays in...

## How to use Goal Seek in Excel 2016 [Solve 3 Problems]

If you know the result of a formula, but you are not sure which input value the formula needs to get that result, you can use the Goal Seek Command. Suppose that you want...

## What is an Array in Excel & how to work with it? Array Formulas Basic

Today, I will talk about the basics of Array Formulas. Most Excel users find it one of the hardest topics to understand in Excel. There are several articles online already on this topic. Then...

## What is and how to use paste special command in Excel

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across almost every Windows application. By pressing “Ctrl-V” or clicking “Paste”,...

## How to Use Scenario Manager in Excel [with Examples]

I have introduced you with how to do sensitivity analysis using data table in one of my previous posts – Sensitivity Analysis In Excel Using One or Two Variables Data Table. It is useful...

## Use of Offset Function in Excel [Offset – Match Combo, Dynamic Range]

Today I’d like to introduce you to Excel’s OFFSET Function with 3 real life examples. At first, I will describe the formula syntax and then I’m going to talk about how the OFFSET function...