Find Files Easily
Are you an organized person? Is everything at your fingertips? If so, good for you. I, unfortunately, am a bit more unorganized and can spend quite a bit of time looking for a specific Excel file. I have found that adding keywords to a file when I create it, can help...
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...
Sort Left to Right
Who knew how many different ways there are to sort? Let’s talk about changing the Sort Option Orientation. Typically you don’t have to change the orientation of sorting as the default works just fine. However, everyone in awhile, you have that one...
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...