Latest Posts

Excel IF Function with 3 Conditions

In this tutorial, we will be working on the nested if function in Excel. We will analyze the If function with 3 conditions in Excel. Here we will see ...

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

How to Make Excel Spreadsheet Bigger when Printing (Easy steps)

Printing in an efficient way creates a lot of positive impacts on the mother environment and your office balance sheet. So, I always inspire people ...

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

Excel conditional formatting based on another cell text [5 ways]

In this article, we will be familiarized with an interesting topic which is "Excel Conditional Formatting Based on Another Cell Text". Excel ...

How to Find Duplicate Values in Excel using VLOOKUP

In this article, we will see the process on how to find duplicate values in Excel using VLOOKUP. We will also see the processes on how to use VLOOKUP ...

Excel Reference Cell in Another Sheet Dynamically

In this article, we will discuss an important topic which is how "Excel reference cell in another sheet dynamically". Here we will refer to a ...

Solving equations in Excel (polynomial, cubic, quadratic, & linear)

Excel has many features that can perform different tasks. Besides performing different statistical, financial analyses we can solve equations in ...

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 Make a Pie Chart in Excel (Only Guide You Need)

A pie chart is made of slices that form a circularly shaped graph to represent numerical data of an analysis. Pie charts are difficult to draw as ...

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 Split Cells in Excel (The Ultimate Guide)

If you want to extract the information from one cell into two or multiple cells splitting the cell is required. Splitting cells also provide better ...

Calculate The Difference between Two Dates in Excel

There might be a lot of reasons that you need to calculate the number of days between two dates in excel or the number of weeks, months, and years ...

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

How to Use Compound Interest Formula in Excel

Compound interest is the interest that's calculated both on the initial principal of a deposit or loan and on all previously accumulated interest. In ...

ExcelDemy
Logo