Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

## Text to Columns in Excel (Split Column, Text, Date, …)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in Excel. Like you can split the columns of your ...

## How to Create Pivot Tables for Meaningful Data Analysis!

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

## 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 elaborated on how to insert data slicers, how to ...

## 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 handle as many as ...

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

## How to use Goal Seek in Excel 2016 [Solve 3 Problems]

If you know the result of a formula, but you are not sure which input value the formula needs to get that result, you can use the Goal Seek Command. Suppose that you want to pay off your mortgage ...

## How to Use Scenario Manager in Excel [with Examples]

I have introduced you with how to do sensitivity analysis using data table in one of my previous posts – Sensitivity Analysis In Excel Using One or Two Variables Data Table. It is useful but it only ...

## One and Two Ways (Variables) Sensitivity Analysis in Excel!

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

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

## 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 a histogram chart to ...

## Running Average: How to Calculate Using Excel’s Average(…) Function

In this post, you will learn how to calculate running average of a data set using Excel's Average(...) function. A business generates huge amount of data every year. Most of the data are related ...

## Use Scatter Chart in Excel to Find Relationships between Two Data Series

In this post, you will learn how to find out the relationships between two or more data series using Scatter Chart in Excel. You know, business data analysis has so many goals. One of the goals is ...