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