by Nate Moore | Jan 16, 2013 | Pivot Tables
The first time you see what I’ll show you in Excel Video 324, you might think Excel has a bug. If you delete data in your Pivot Table because a name changed or you fixed some incorrect data, you’ll still see the name in the drop down manual filter list, even though...
by Nate Moore | Jan 14, 2013 | Pivot Tables
Watch for two display tips in Excel Video 323. The first tip is helpful if you used to use Pivot Tables in versions of Excel prior to Excel 2007. Now that I’m familiar with the Pivot Table Field List, I don’t use the Classic Pivot Table layout any more, but it was...
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...