Data Analysis with Excel

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

In Microsoft Excel, using Advanced Filter with multiple criteria allows us to add different logics and functions to execute a wide range of ...

Excel formula to compare two columns and return a value (5 examples)

In this article, I will show you several techniques of using Excel formula to compare two columns for matches and return a value. Your necessity ...

VLOOKUP Formula to Compare Two Columns in Different Sheets!

If you have two big columns and you want to compare them, you can use Excel’s VLOOKUP function. In this article, I will show how you can use VLOOKUP ...

Using Excel to get data from another sheet based on cell value

Getting data from another spreadsheet based on a cell value might be quite useful for some projects and reports. In this short article, I will show ...

How to Merge Two Cells in Excel without Losing Any Data

In this article, I will show you several tricks that you can use to merge two cells in Excel without losing data. Using Excel’s Merge & Center ...

Remove duplicate rows based on two columns in Excel [4 ways]

Removing duplicates is a very important part of any kind of data analysis. And your duplicate occurring can be quite different from others. So, ...

How to Compare Two Columns in Excel Using VLOOKUP

There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare/find matches in two columns in excel using ...

How to Calculate/Find Mean and Standard Deviation in Excel

The variance, standard deviation and mean deviation are closely related to each other. In this article, you will get to know how to calculate ...

How to Calculate Variance in Excel (Easy Guide)

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the ...

Calculate Depreciation in Excel (Straight Line, Double Declining…)

An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation, or country which will yield future ...

Best 40 Excel Books for Data Analysis & Business Modeling

Analyzing data, taking the business decision based on the data has become the core part of a business. Genius data analysts (with the help of ...

How to calculate Average, Median, & Mode 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 ...

How to use Goal Seek to find an input value?

Goal seek is part of the What-If Analysis set of data analysis tools, in Excel. A user can evaluate the input value needed, to produce the desired ...

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

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

ExcelDemy
Logo