Excel Formulas

Formula to Remove Blank Rows in Excel (5 Examples)

Having blank rows in a Microsoft Excel worksheet is a common scenario. Most of them are unnecessary and they consume more spaces that increase the ...

Mortgage Calculations with Excel Formula (5 Examples)

In Microsoft Excel, calculating a monthly mortgage payment has become a typical task for most modern folks. The fixed periodic payment and the ...

How to Calculate Due Date with Formula in Excel (7 Ways)

In Excel, we can easily calculate the due date of a project by using the DATE formula, EDATE Function, YEARFRAC Function, and WORKDAY Function. ...

How to Use COUNTIFS with Date Range in Excel (6 Easy Ways)

Often while working in a dataset, we need to find, calculate, or match anything based on a certain condition. In this article, we demonstrate how to ...

How to Use IF Formula with Dates (6 Easy Examples)

While working in Microsoft Excel, there are various formulas to make our work easier. IF formula is one of them. It has a wide range of applications ...

How to Use COUNTIF Between Two Numbers (4 Methods)

Sometimes while working in Microsoft Excel we need to count cells between two numbers. We can do this with the COUNTIF function. The COUNTIF function ...

How to Calculate Interest on a Loan in Excel (5 Methods)

While working with borrowed loans, we have to calculate the amount of interest or capital that we have to pay for that loan. We can easily calculate ...

Formula for Monthly Compound Interest in Excel (With 3 Examples)

Calculating interest is a common task in banking, NGOs, and other financial organizations. We can do it very quickly and easily in Excel by using ...

Simple Interest Formula in Excel (With 3 Practical Examples)

Whether you run your own business or manage your personal finance, or do corporate jobs, Simple Interest (SI) is an important topic for you. You can ...

A Daily Compound Interest Calculator in Excel (Template Attached)

Compound interest generates your money to develop quickly. It makes a sum of money increase at a more rapid rate than simple interest because you ...

Calculate Future Investment Value with Inflation, Tax and Interest Rates

If you want to calculate future investment with inflation and nominal interest rates, then there is an essential article on How to calculate future ...

How to Calculate Weighted Moving Average in Excel (3 Methods)

Weighted Moving AverageĀ is one form of moving average that can be used to smooth out time-series data to reduce the effects of random, short-term ...

How to Use Excel INDIRECT Range (8 Easiest Ways)

The INDIRECT function (a Lookup & Reference function) is used to return the reference specified by the text string. This function is used to get ...

How to Calculate Total Percentage in Excel (5 Ways)

A percentage is a number or ratio expressed as a fraction of 100. Today, in this tutorial, I will be showing how you can calculate the total ...

How to Use Indirect Address in Excel (12 Examples)

In this article, you will get to know some of the examples of indirect address in Excel. By using an indirect address, you will be able to refer to ...

ExcelDemy
Logo