# Category: Data Analysis

## How to Use the Database Functions in Excel

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...

## How to Use Wildcards in Excel?

Wildcard characters such as the asterisk “*”, question mark “?” and the tilde “~” can greatly extend searching, counting, and addition functionality in Excel.  Excel wildcards can be used with functions such as AVERAGEIF,...

## The Difference between Average, Median and Mode and How to Calculate Each in Excel

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then dividing by the count of...

## Detecting Duplication and Finding Unique Values in Excel – Pro Tips

Duplication of values in Excel, can occur in a single column or across multiple columns and rows in Excel. It is often necessary to eliminate duplication, for correct data analysis and data integration purposes....

## How to Find Correlation between Two Variables in Excel

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the relationship between two variables, as well as whether or not there is a...

## Split one column into multiple columns in Excel [Text to Columns]

When you design your database to store information in it, you have to remember one thing very carefully. Your every column should have a minimum amount of data in it. Related: Create Database in Excel in...

## How to Create Pivot Tables that Provide Meaningful Data Analysis & Insights

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can quickly structure and re-structure the Pivot Table, by dragging and...

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

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

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

## Sensitivity Analysis in Excel Using One or Two Variables Data Table

Sensitivity analysis studies how different sources of uncertainty can affect the final output in a mathematical model. Recently one of my friends borrowed money from a bank to buy a house. And I was...

## Excel Advanced Filter [Multiple Columns & Criteria, Using Formula & with Wildcards]

I was performing keyword analysis for one of my new projects using SemRush.com, a competitive analysis tool. Actually, I was checking for how many keywords a website was ranking in Google. Domain authority, website...

## Stock return analysis using histograms & 4 skewness of histograms

A histogram is a widely used way to summarize a large data set. Creating a histogram using Data Analysis ToolPak is very easy. My this blog is aimed to show you how you can use...

## Forecasting in Excel Using FORECAST Function & Auto Fill Handle Tool

This article is aimed to show you two forecasting methods that you can use to forecast in Excel. If you own or operate a business, this is a common scenario that you are worried...