# Category: Functions

## How to use the TODAY() and NOW() Functions in Excel

The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April...

## How to Use the FORMULATEXT Function in Excel

The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula and...

## How to Count the Frequency of Text in Excel!

Have you ever wondered how to count the frequency, i.e the number of times a specific text appears, in a range in Excel? We have already seen how to use the different COUNTING functions...

## The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function and the COUNTBLANK Function. The COUNT...

## How to calculate depreciation in Excel with 5 functions?

An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation or country which will yield future economic benefit. Accountants list assets on balance sheets, in...

## Nominal Interest Rate vs. Effective Interest Rate Excel Formulas

There are different types of interest rates and it is prudent for every investor or potential investor to know the differences between interest rates. The nominal interest rate is the simplest of the interest...

## The FVSCHEDULE Excel Function

We have already seen how to use the FV (Future Value) Function to calculate the future value of an investment with a constant or fixed interest rate, in a previous tutorial. Let’s remind ourselves...

## How to Use the Excel MIRR Function

We have already seen how to use the IRR (Internal Rate of Return) Function in a previous tutorial. The IRR Function is used to calculate the internal rate of return for a series, of...

## IRR versus XIRR Excel Functions [Tutorial]

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 flows do not have to be even, though...

## Calculating the Rate an Investment Achieves Using the RRI Function

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 calculate NPV and XNPV and the difference...

## NPV versus XNPV Excel Functions Tutorial

The NPV (Net Present Value) Function is used to calculate the net present value of an investment by evaluating a provided discount rate, a series of future payments (negative values) and income (positive values)....

## The PV, FV and PDURATION Excel Functions Tutorial

The PV Function, FV Function, and PDURATION Function are all extremely useful financial functions. The Present Value (PV) Function is used to calculate the present value of a loan or an investment using a...

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

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

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

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. We are going to see how to...

## How to Use the Database Functions in Excel

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...