Excel Formulas

5 Ways to Generate Random Number Between 0 and 1 in Excel

In this lesson, I'll demonstrate 5 Ways to generate random number between 0 and 1 in Excel. Moreover, these techniques will enable you to solve the ...

10 Ways to Put a Comma After 3 Digits in Excel

For better representation of data, we often need to use commas to break sentences and numbers. Numbers are usually separated by commas to represent ...

How to Calculate Average Percentage Change in Excel

You may want to calculate the average percentage change in Excel to determine the growth or decline of your company annually or to predict the ...

5 Ways to Calculate 7-Day Moving Average in Excel

From Operational Management to Demand Planning, Stock market to Small businesses everywhere one thing in common, is the Moving Average Calculation. ...

5 Ways to Remove Blank Rows Using Formula in Excel

In this lesson, I'll demonstrate 5 different approaches to remove blank rows using formula in Excel. Moreover, these techniques will enable you to ...

5 Examples to CONCATENATE If Date Becomes Number in Excel

Data can take many forms in Excel, including text, numbers, synonyms, etc. Excel's CONCATENATE function merges the values of multiple cells into a ...

Calculate Displaced Moving Average with Formula in Excel

We will cover the specifics of the Displaced Moving Average (DMA) in the Excel formula for this topic. DMA is a variant of the Simple Moving Average ...

6 Approaches to Remove Space After a Number in Excel

We often have to work transferring a lot of data from external sources to a spreadsheet. In doing so, our data can get mixed up with some unwanted ...

2 Approaches to Calculate Interest Between Two Dates in Excel

In this article, we will calculate the interest between two dates in Excel. We need to calculate interest for many purposes, such as bank loans, ...

6 Solutions If VLOOKUP Returns #N/A When Match Exists in Excel

In this lesson, I'll demonstrate 7 reasons and solutions why VLOOKUP returns #N/A even though a match Exists in Excel. Moreover, these techniques ...

7 Ways to Concatenate Multiple Cells with Space in Excel

Excel data can take various forms, including text, numbers, synonyms, etc. The CONCATENATE function in Excel combines the values of multiple cells ...

3 Quick Steps to Calculate Credit Card Interest in Excel

In this article, I'll show you three excellent methods for how to calculate credit card interest in Excel. Furthermore, these strategies will allow ...

ExcelDen
Logo