User Posts: Zhiping Yan

In this article, you will learn how to format an Excel spreadsheet for printing. I'm sure these tips will help print your data more professionally. With ...

READ MORE +

Last time, I made an introduction on how to import data into PowerPivot, create PivotTable/PivotChart using PowerPivot. In that article, I also elaborated ...

READ MORE +

Pivot table is useful 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. For ...

READ MORE +

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

READ MORE +

Excel provides many functions that can be used to manipulate strings. These functions are very useful especially when you have to clean data. This article ...

READ MORE +

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

READ MORE +

It is well known that World Wide Web contains huge useful data. However, we have to import the data into Microsoft Excel before doing any kind of analysis. ...

READ MORE +

In our daily working life, we may need to import data from a Word file into an Excel file. In most cases, we would like to copy the text from Word file and ...

READ MORE +

Microsoft products are truly amazing tools for management consultants who need to do data analysis and make a presentation before clients. And Microsoft Excel ...

READ MORE +

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

READ MORE +

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

READ MORE +

It is well known that sequencing problems are notoriously difficult to solve. There are two kinds of sequencing problems:  traveling salesperson problem and ...

READ MORE +

In this article, you will learn how to use Excel format function and text function with 68 examples. These examples will clear your idea about these two ...

READ MORE +

Previously, I have made a brief introduction on the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use Evolutionary Engine ...

READ MORE +

Previously I have written an article on how to rate sports team using GRG Nonlinear engine, today I’d like to continue to discuss GRG Nonlinear Multistart and ...

READ MORE +
Browsing All Comments By: Zhiping Yan