User Posts: Zhiping Yan
0

## How to Use Excel Solver to Rate Sports Team (With Easy Steps)

This tutorial will demonstrate how to use an excel solver to rate sports team. Ratings are numerical representations of competitive strength which is directly ...

0

## How to Create Financial Planning Calculator in Excel

In this article, I will show you two ways to create a financial planning calculator in Excel. Most of us need to determine the monthly payment or the amount of ...

0

## How to Use Excel Solver to Determine Which Projects Should Be Undertaken

This tutorial will demonstrate how to use excel solver to determine which projects should be undertaken. Companies need to know which projects should undertake ...

0

## Solving Transportation or Distribution Problems Using Excel Solver

In this article, we will discuss 2 cases for solving transportation or distribution problems using the Excel Solver. It is well known that companies ...

0

## Schedule Optimization in Excel (Detailed Analysis)

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 the workforce along with ...

0

## How to Calculate Optimal Product Mix in Excel (with Easy Steps)

In many situations, you may want to know how to calculate the optimal product mix in Excel. For example, companies often need to determine the amount of each ...

0

## How to Use Goal Seek in Excel (5 Suitable Examples)

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. In this ...

0

## How to Use Paste Special Command in Excel (5 Suitable Ways)

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

0

## How to Use Scenario Manager in Excel (with Easy Steps)

I have introduced you to how to do sensitivity analysis using a data table in one of my previous posts – Sensitivity Analysis In Excel Using One or Two ...

0

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

0

## One and Two Variables Sensitivity Analysis in Excel (2 Examples)

The article shows how to perform one and two variable sensitivity analysis in Excel. Sensitivity analysis studies how different sources of uncertainty can ...

0

## Practice Excel Indirect Function with 3 Case Studies

Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief introduction to the ...

0

## How to Make a Control Chart in Excel (2 Easy Ways)

Control charts are widely used to monitor process stability and control. In this article, I will show you how to make a Control Chart with Excel VBA and ...

Browsing All Comments By: Zhiping Yan Advanced Excel Exercises with Solutions PDF  