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)

We'll use a dataset containing some names of fruits as Product and their Sales value of 4 months (January to April) to demonstrate how you can format Excel to ...

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

How to Import Data from Website to Excel with VBA Code: 2 Ideal Methods

Method 1 - Import Specific Data from Website to Excel VBA MsgBox STEPS: Go to the Developer tab from the ribbon. Click on Visual Basic from the Code ...

3 Easy Methods to Import Data from Word to Excel

Method 1: Import Only One Cell Example Model: STEPS: Copy the data from the Word file and then paste into our expected cell in Excel. Press Ctrl+V ...

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 the Format Function in Excel (With Suitable Examples)

Note: All the operations of this article are accomplished by using the Microsoft Office 365 application. Example 1 – Formatting the Number ...

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

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

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

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

How to Do Schedule Optimization for a Particular Workforce Using Excel Solver: 4 Methods

Method 1 - Calculating Minimum Number of Telephone Reservation Operators to Meet Labor Demands Look at the dataset before explaining the situation. It ...

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

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

Browsing All Comments By: Zhiping Yan

Advanced Excel Exercises with Solutions PDF