by Nate Moore | Jan 30, 2013 | Pivot Tables
Watch Excel Video 328 to see how easy it is to chart Pivot Table data with Pivot Charts. A Pivot Chart is an Excel chart linked to a Pivot Table. You’ll find all of the chart types and features you’re used to with charts conveniently linked to a Pivot Table. If you...
by Nate Moore | Jan 28, 2013 | Pivot Tables
Now that you’re familiar with subtotals in Pivot Tables, Excel Video 327 takes subtotals to a whole new level. Watch how we can turn one subtotal into several subtotals and show the sum, count, average, maximum and/or minimum values as part of a subtotal. You need to...
by Nate Moore | Jan 23, 2013 | Pivot Tables
Watch Excel Video 326 for four ways to tweak what your Pivot Table looks like. We’ll walk through several examples today of some Pivot Table layout choices like adding a blank row after each subtotal, whether or not grand totals are used, and where subtotals are...
by Nate Moore | Jan 21, 2013 | Pivot Tables
Your CPA friend can’t teach you very much about style, but he can show you how to change Pivot Table styles in Excel Video 325. There are a bunch of preset styles to customize the way your Pivot Table looks. Styles are a great way to make your Pivot Tables look...
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...
