Excel Formulas

7 Easy Ways to Use Comma in Excel Formula

In our daily life sometimes we require to deal with a very large dataset where the number entry can also be very large. If they are too large ...

3 Quick Ways to Replace Text After Specific Character

Every now and then we may find ourselves in a situation where we want to replace a text with some specific character or word. We sometimes need to ...

4 Ways to Find and Replace Blank Cells in Excel

In Excel, you can use Find and Replace feature to find a specific value or text string in your workbook. You have two options: find the search item ...

How to Calculate Turnaround Time in Excel Excluding Weekends

Calculating turnaround time can be an easy task for a small range of people. But when we want to do so for a large dataset, we need the help of ...

5 Easy Ways to Add Comma in Excel to Concatenate Cells

When data from multiple cells are gathered into another cell altogether is known as the Concatenation of cells. Generally, concatenation is done with ...

2 Easy Ways to Add Thousand Separator in Excel Formula

Sometimes we need to add thousand separator (,) in Excel formula. In this scholarly, I will show you how you can add thousand separator (,) in the ...

How to Compare Two Cells in Different Sheets with Excel Formula

Sometimes we need to find out, highlight or eradicate duplication in the same sheet. If duplications are in the same worksheet it is easier to ...

4 Ways to Compare Two Columns in Excel for Missing Values

Sometimes we need to compare two columns in Excel for missing values. In this article, we will show you how to compare two columns in Excel for ...

4 Easy Ways to Calculate Percentage in Excel Based on Cell Color

Sometimes we have to calculate the percentage of a certain value from the total value. It can be a certain sell value of a product from all the ...

2 Ways to Calculate Future Value When CAGR is Known in Excel

Sometimes we have to estimate the forecast value of something based on some currently available data. In the planning stage of a city, we have to ...

Create and Download Late Payment Interest Calculator in Excel

When we take loans from a bank, we have to repay that loan with an interest after a certain period. This article will show you in stages to create ...

6 Ways to Forecast Growth Rate in Excel

You can use historical time-based data to forecast growth rates if you have it. When you make the forecast, Excel generates a brand-new worksheet ...

ExcelDen
Logo