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 Format Excel to Print (13 Simple Tips)

In this article, you will learn how to format an Excel spreadsheet to print. I’m sure these tips will help print your data more professionally. You can print ...

DAX Data Types and Other Aspects (Checking & Handling Errors)

DAX (Data Analysis Expressions) is used as a formula expression language in Analysis Services, Power BI, and Power Pivot. DAX data types and formulas contain ...

How to Import and Use Data into Power Pivot in Excel

PivotTable is a useful tool when we want to analyze or slice data to gain important insights. It is the main way to analyze data. But it also has limitations. ...

Sparklines in Excel (A Clear Overview)

It is well known that we can draw a chart easily in Excel. But is it possible to graphically summarize data in a single cell? The answer is “Yes”. And the ...

How to Use Substring Functions in Excel (Types and Examples)

Usually, we need to work with substring functions in Excel. This is a guide that will let you how to separate, split, and remove substrings and numbers from ...

Multiple Regression Analysis with Excel

Simple regression analysis is commonly used to estimate the relationship between two variables, for example, the relationship between crop yields and rainfalls ...

How to Import Data from Website to Excel with VBA Code

The key advantage of importing data from a website to Excel is the ability to routinely evaluate data in Microsoft Office Excel without having to continuously ...

How to Import Data from Word to Excel (3 Easy Methods)

Often while working with Excel, we need to import data from different sources. These sources may include Word files which is another commonly used software for ...

Top Excel Functions and Features for Management Consultants

For management consultants who must conduct data analysis and give presentations to clients, Microsoft products are truly incredible resources. And without a ...

Sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines [Sol]

Almost two weeks ago, Jagadeesh asked me if I can explain how to solve the sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines. I ...

22 Limitations of Excel That Might Frustrate You

Excel is obviously one of the most important products in the world. It is very helpful in managing, analyzing data. But there is also something that may get us ...

Solving Sequencing Problems Using Excel Solver Solution (2 Suitable Examples)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default Excel ...

How to Use Format Function in Excel (with Suitable Examples)

In Microsoft Excel, we need to format the values of any cells to get proper readability and a good outlook. Besides using the available built-in command in the ...

How to Assign Work Using Evolutionary Solver in Excel (with Easy Steps)

An evolutionary solver can help you to assign work. By default, you don’t get the solver option in your Microsoft Excel. You have to enable the solver option ...

How to Use Excel Evolutionary Solver (With Easy Steps)

In this tutorial, I am going to show you how to use the Evolutionary solver in Excel to solve complex optimization problems. You can use this solver in ...

Browsing All Comments By: Zhiping Yan

Advanced Excel Exercises with Solutions PDF