LEN Function
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
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
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 a Loan Payment & Creating an Amortization Schedule
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...