


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