Below is an excerpt from our Excel Time Value of Money course written by Joseph Helstrom,CPA. RRI RRI is a new function that was introduced in Excel 2013. It returns the equivalent interest rate for the growth of an investment. The inputs required are the number of...

Excel has a number of date functions. Unfortunately, they don’t all work if Excel treats the date as text. When working with downloaded data, sometimes the date must be converted from text to a format recognized by Excel. One method is to use the...

LEN Function – Counting Characters in a Cell LEN() is one of those functions that you wonder about. LEN is a text function and depending upon what you are doing it is so useful. It counts the number of characters in a cell. I use it all the time if I want to...

I am in the process of updating my Pivot Table course and decided that I take another look at the GetPivotData function. GET PIVOT DATA is an Excel function that pulls data from your pivot table. I personally don’t use it because if you hide a field you referenced...

The AGGREGATE Function The AGGREGATE function is a very powerful function for summarizing an array of data. It combines 19 different ways to summarize data into one function! While it is a powerful function, my favorite reason for using AGGREGATE is its ability to SUM...

Computing the Periodic Payment for a Loan Excel Financial Function Computing the periodic payment is probably the most used Excel financial function simply because it is something everyone uses.Let’s walk through an example.You want to purchase a car and finance...