Latest Posts

How DAX Works. DAX Data Types & Operator. Check & Handle Error.

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

How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart

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

How to pull/extract data from a website into Excel automatically?

In this article, I shall show you how to pull / extract or get data from a website into Excel automatically. This is one of the most used Excel ...

Sparklines in Excel (Insert, Change, & Modify to Show Data Trends)!

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

Separate, Split & Remove Substring & Number from Text with Excel Functions & VBA

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

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

How to Import Data from a Website to Excel?

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

How to create a database in Excel (make in 8 easy steps)

Don't know how to create a simple database in Excel? In this article, I will show how you can make a database in Excel in just simple 8 steps. Do ...

Import Data (Sentence, Paragraphs, Tables, Comments) from Word to Excel

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

Top Excel Functions and Features for Management Consultants

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

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

Top 20 Excel Limitations 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 ...

Deal with Sequencing Problems Using Excel Solver!

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

Using FORMAT & TEXT Functions in Excel (68 Easy Examples)

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

How to Assign Work Using Evolutionary Engine?

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

ExcelDemy
Logo