0 Items
Select Page

## How to Use Pivot Tables to Streamline Your Work

What are pivot tables and how do they work?  The short answer: pivot tables enable you to summarize, analyze, explore and present key findings. By analyzing data in detail, you can spot trends and discover unanticipated findings. A few examples of pivot table...

## Find & Select Constants

I just discovered this little timesaver and thought I would share it with you. Okay, to be honest, my husband told me about it. Suppose you have an Excel spreadsheet and you have a number of product codes all in one row and need to break them out. You can do text to...

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