by Nate Moore | Feb 4, 2013 | Pivot Tables
Excel Video 329 introduces Pivot Chart Field Buttons. I’ll describe what Pivot Chart Field Buttons are and when they might be helpful. With each version of Excel, Microsoft seems to rotate whether or not Pivot Chart Field Buttons are on or off by default. Once you...
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...