Data Analysis with Excel Archives - Page 2 of 5

How to Create a Data Table in Excel (7 Ways)

Feb 27, 2022 Data Analysis with Excel

In this article, you will have an idea about how to create a data table in Excel easily. Creating a data table in Excel is an important feature of ...

How to Perform the What If Analysis with Data Table in Excel

May 19, 2022 Data Analysis with Excel

In this article, we’ll illustrate the use of the What If Analysis with data table and how it is useful to make financial decisions. Download the ...

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

Nov 4, 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)

Mar 14, 2022 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!

Mar 14, 2022 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

Mar 2, 2022 Data Analysis with Excel 12

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

Mar 6, 2022 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]

Feb 22, 2022 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

Mar 2, 2022 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 1

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

Nov 17, 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 ...