# Category: Data Analysis

## How to Make a Pie Chart in Excel & Add Rich Data Labels to The Chart!

A pie chart is used to showcase parts of a whole or proportions of a whole. Charts are visual representations of data that can summarize large data sets and are useful for engaging one’s...

## Best 7 Books on Financial Modelling Using Excel

Where do financial modelers work? The world of finance can be a very complex place that at times is quite tricky to navigate. One has, for example, millions of financial transactions being processed a day....

## Best 39 Excel Book for Advanced Users [Ultimate Resource]

So, you know your SUM formula, you also know how to use the COUNTIF function. In addition, you are the go-to person at your office, when basic or intermediate level Excel help is needed....

## Best 40 Excel Books for Data Analysis & Business Modeling

[Note: My this blog post contains the best 40 Excel books for data analysis and business modeling. I’ve also listed here the best books for financial & scientific data analysis, data visualization, SQL and...

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

## 15 Best Basic & Advanced Online Excel Training Courses!

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