User Posts: Zhiping Yan
1
How to Format Excel to Print (13 Simple Tips)
0

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

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

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

0
How to Import and Use Data into Power Pivot in Excel
0

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

0
Sparklines in Excel (A Clear Overview)
0

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

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

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

0
Multiple Regression Analysis with Excel
0

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

0
How to Import Data from a Website to Excel?
0

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

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

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

0
Top Excel Functions and Features for Management Consultants
0

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

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

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

0
22 Limitations of Excel That Might Frustrate You
0

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

0
Deal with Sequencing Problems Using Excel Solver!
0

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

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

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

0
How to Assign Work Using Evolutionary Engine?
0

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

0
How to Use Excel Evolutionary Solver (With Easy Steps)
0

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
ExcelDemy
Logo