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

[Editor’s Note: This is an introduction to DAX (Data Analysis Expression). The author has covered from very basic like how DAX works, DAX data types, DAX operator. At the end of the article, she...

## 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 limitations. For example, you can only...

## How to extract data from website to Excel automatically?

Extracting data (data collection and update) automatically from a web page to your Excel worksheet might be important for some jobs. Excel gives you the opportunity to collect data from a web page. Yes,...

## Sparklines in Excel – How to Insert, Change and Modify to Show Data Trends

[Editor’ Note: This article (written by Zhiping Yan) will guide you completely on Sparklines in Excel. You will learn how to insert, and modify sparklines. She has also covered how to use Excel conditional formatting...

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

[Editor’s Note: This is a guide on how to separate, split & remove substring & numbers from text using Excel Functions and VBA. Examples of substring functions are CHAR, FIND, LEFT, LOWER,  MID, PROPER, REPLACE, RIGHT,...

## 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 or the relationship between the taste of bread and oven temperature.  However,...

## Best Online Excel Training for Basic & Advanced Users with Certification

“Note: Are you a basic Excel user? Or an advanced level user? And searching for the best online Excel courses? And don’t want to spend the top dollars on the training? You’re at the...

## 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 analysis. There are two methods that you...

## Create Database in Excel in 8 Easy Steps

Want to create database in Excel? Do you find MS Access as complex tool to use as a database? Read this article. How to create database in Excel Unfortunately, they don’t teach the hardcore...

## 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 Word file and then...

## 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 Microsoft Excel is no doubt one the most important tools for management...

## Solve sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines

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 several approaches and found that Excel Solver is...

## 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 may get us frustrated when using Excel. Today...

## 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 problem and shop scheduling problem.  Today I’d like to introduce on how to...

## TEXT and FORMAT Functions in Excel [68 Examples]

Sometimes, we need to format or manipulate data the way what we want. Here is what we generally do. If you right click on the worksheet, the context menus will be prompted. By clicking...