Excel Formulas Archives

Formula to Remove Blank Rows in Excel (5 Examples)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Formulas

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Formulas

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)

Jan 12, 2022 Excel Basics

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)

Jan 11, 2022 Excel Basics

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)

Jan 11, 2022 Excel Formulas

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)

Jan 13, 2022 Excel Formulas

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)

Jan 10, 2022 Excel Formulas

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)

Jan 10, 2022 Excel Formulas

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

Jan 9, 2022 Excel for Finance 2

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)

Jan 10, 2022 Excel Formulas

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)

Jan 9, 2022 Advanced Excel

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)

Jan 10, 2022 Excel Basics

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)

Jan 11, 2022 Advanced Excel

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