Data Analysis with Excel Archives

Data Table Not Working in Excel (7 Issues & Solutions)

Jan 12, 2022 Data Analysis with Excel

Undoubtedly, a data table is a useful tool for updating, sharing, and analyzing data effectively. But sometimes we face issues that hamper working ...

Scenario Analysis in Excel: A Guide with 2 Sample Cases + Template

Jan 11, 2022 Data Analysis with Excel

In Microsoft Excel, analyzing scenarios is one of the crucial tasks. We consider it as a part of data analysis. Scenario analysis means comparing ...

Example of Excel Data Table (6 Criteria)

Jan 13, 2022 Data Analysis with Excel

In Excel, we apply basic to complex formulas. Depending on the scenario the use of the formula’s changes. In case you have any formula dependent on ...

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

Jan 9, 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

Jan 9, 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)

Oct 17, 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!

Nov 10, 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

Oct 12, 2021 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

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]

Jan 11, 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

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