Data Analysis with Excel Archives

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

Sep 20, 2021 Data Analysis with Excel

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)

Sep 15, 2021 Data Analysis with Excel 9

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!

Sep 13, 2021 Data Analysis with Excel 2

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

Sep 13, 2021 Data Analysis with Excel 11

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

Sep 15, 2021 Advanced Excel 5

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]

Sep 15, 2021 Data Analysis with Excel

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

Sep 13, 2021 Data Analysis with Excel 1

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

Sep 13, 2021 Data Analysis with 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)

Sep 13, 2021 Data Analysis with Excel

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…)

Jun 5, 2021 Data Analysis with Excel

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

Sep 12, 2021 Data Analysis with Excel

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

Sep 12, 2021 Data Analysis with 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?

Apr 7, 2021 Data Analysis with Excel

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

Sep 12, 2021 Data Analysis with 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!

Sep 12, 2021 Data Analysis with Excel

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can ...