## Excel Dynamic Named Range [4 Ways]

Excel Dynamic Named Range is one of the Excel features that not so many Excel users know about. This text will make Dynamic Named Ranges closer to you. In the further lines, hints and...

## What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you can use them to build complex Excel formulas. Here...

## Exponential Notation in Excel & How to Turn Off Auto Scientific Notation!

This article will at first introduce you with the scientific number system and number precision definition. Then you will know about the highest and lowest number limitations in Excel. At the end of the article,...

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

In today’s labor market, it has become necessary to have as many skills as possible. One of the most important and useful skills that is required for most positions is excel and not just...

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