Excel Formulas Archives - Page 88 of 90

XIRR vs IRR – How to Calculate IRR and XIRR in Excel

Mar 3, 2022 Excel for Finance

The IRR (Internal Rate of Return) function is used to calculate the internal rate of return for a series, of given periodic cash flows. These cash ...

Calculating the Rate an Investment Achieves Using the RRI Function

Mar 3, 2022 Excel for Finance

We have already seen how to use the PV Function, the FV Function, and the PDURATION Function in a previous tutorial. We have also seen how to ...

Excel Financial Function Tips – NPV vs XNPV

Jun 5, 2021 Excel for Finance 2

In this tutorial, you will learn how to calculate the net present value using Excel's NPV and XNPV Functions. The NPV (Net Present Value) Function ...

How to Use FV, PV and PDURATION Functions in Excel

Jun 5, 2021 Excel Formulas 1

The PV Function, FV Function, and PDURATION Function are all extremely useful financial functions. Excel PV Function Syntax The Present Value (PV) ...

How to Use the CONVERT Function in Excel and creating a BMI Calculator template

Jun 5, 2021 Excel Formulas

The CONVERT function is an extremely useful and relatively unknown Excel function. It converts a number from one unit of measurement to another unit ...

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

May 9, 2022 Advanced Excel 6

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. ...

How to Use Excel Database Functions DGET, DAVERAGE, & DMAX

Jun 5, 2021 Excel Formulas

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve ...

INDEX MATCH vs VLOOKUP vs DGET Excel Functions (Comparison)

Jun 5, 2021 Excel Formulas 7

Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – we will compare INDEX MATCH vs ...

How to Use the Excel DAYS Function with a Practical Example

Mar 2, 2022 Excel Formulas 2

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, ...

How to Use Wildcards in Excel?

Jun 7, 2021 Advanced Excel

In this article, we shall see how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and the tilde "~" can ...

How to calculate Average, Median, & Mode in Excel

Nov 17, 2021 Data Analysis with Excel

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then ...

How to Find Unique Values in Excel & Detect Duplicates

Jun 5, 2021 Advanced Excel

In this article, we are going to analyze how to find unique values in Excel. Duplication of values in Excel can occur in a single column or across ...

How to Find Correlation between Two Variables in Excel

May 25, 2022 Data Analysis with Excel

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the ...

Text to Columns in Excel (Split Column, Text, Date, …)

Jun 7, 2021 Advanced Excel

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in ...

Excel If Function with Multiple Conditions (Nested IF)

Oct 27, 2021 Excel Formulas 8

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...