


SUBTOTAL() and AGGREGATE() -TimeSavers
Many people are only aware of the Subtotal icon and have never looked at the Subtotal function itself. After all, the icon, lets you add, average and count a list so who needs more? Well if you are one of the people who subtotal data a lot then you may want to look at...
Using TRUNC()
This is an excerpt from our Excel CPE course – Must Know Excel tips Tricks and Tools for CPAs. TRUNC() No Decimals If you don’t want the pennies in your calculation you can use =TRUNC(), short for TRUNCATE, or =INT(), short for INTEGER, to turn your data into...
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...