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

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

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

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