RRI Function

by | Feb 13, 2017 | Excel, Financial Functions, Functions

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

DATEVALUE Function

by | Oct 5, 2016 | Date functions, Functions

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

by | Aug 18, 2016 | Functions, Text Functions

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

GETPIVOTDATA Function

by | May 31, 2016 | Functions, Misc Functions, Pivot Tables

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

AGGREGATE Function

by | May 20, 2016 | Functions, Misc Functions

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