by Nate Moore | Jan 9, 2013 | Pivot Tables
Excel Video 322 addresses a project I’m currently working on for one my clients. For reporting purposes, this practice cuts off their month two or three business days before the end of the calendar month. When you group dates in Pivot Tables, you can group by January,...
by Nate Moore | Jan 7, 2013 | Pivot Tables
The next time you need a complex filter in your Pivot Table, remember this trick from Excel Video 321. We’ve discussed manual filters, label filters, and value filters in these Excel Videos. The filters are great, but normally you can only use filter at a time. If you...
by Nate Moore | Dec 19, 2012 | Pivot Tables
If you haven’t been frustrated by the Pivot Table behavior we’ll discuss in Excel Video 320, you probably will be at some point. If you’ve created the perfect Pivot Table and have it formatted to precisely fit one page, you might be frustrated when you refresh your...
by Nate Moore | Dec 17, 2012 | Pivot Tables
Excel Video 319 has several ways to adjust the layout of your Pivot Table. If you have several columns in your Pivot Table and you’d like to center your column label over those columns, you need to spend a few minutes in the Pivot Table Options menu. That same Options...
by Nate Moore | Dec 12, 2012 | Pivot Tables
If you need to create a series of filtered Pivot Tables quickly, Excel Video 318 has a trick for you. If you’ve created a Pivot Table and now want to show a filtered Pivot Table to each of your 8 doctors or for each of your 3 practice locations, Show Report Filter...
by Nate Moore | Dec 10, 2012 | Pivot Tables
Excel Video 317 is a collection of several tips from the Pivot Table Options Menu to make your life easier. The first tip is how to quickly remove all filters. Be careful to clear filters, not clear all. Clear all will clear your entire Pivot Table without an undo...
