Zhiping Yan

About author

I am from China and this photo was taken in a classical garden. There are many similar gardens in China, attracting a lot of visitors every year, especially in spring and summer. I was major in Biotechnology. But I took a job as a SAS programmer because I prefer programming. Besides SAS, I also learned Excel VBA in my spare time. It is fantastic to be able to manipulate data, files and even to interact with the internet via programming. This will save me a lot of time. I am keen to learn new things.

Latest Posts From Zhiping Yan

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 (2 Suitable Cases)

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)

How to Do What-If Analysis Using Scenario Manager in ExcelIn this article, we’ll learn five quick and suitable steps on how to use scenario manager in Excel. ...

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

 

 

ExcelDemy
Logo