by Nate Moore | Jan 28, 2010 | Pivot Tables
This is one of those videos that may take a minute to load. Excel Video 28 is an extended example of how to use a Pivot Chart. There are a couple of ideas demonstrated that I hope you’ll find helpful. We look at E&M codes by the coding level (the last digit of...
by Nate Moore | Jan 26, 2010 | Pivot Tables
I hope by now you’re a fan of the power and flexibility of Pivot Tables. Now that you’ve seen some of the things Pivot Tables can do, imagine a chart or graph in Excel tied to the Pivot Table so that any time you add a column, change a filter, or update your Pivot...
by Nate Moore | Jan 25, 2010 | Pivot Tables
We talked about grouping data in prior videos, but there’s another grouping trick that will come in handy. When Excel sees you’re grouping dates, it offers a number of ways to group the dates, such as by month, quarter, and year. When Excel recognizes you’re grouping...
by Nate Moore | Jan 20, 2010 | Pivot Tables
Excel Video 25 wraps up our discussion of the Pivot Table Options Menu by discussing the Printing tab and the Data tab. The Printing tab has three pretty straight-forward check boxes that control whether to print the expand/collapse buttons on a printed Pivot Table...
by Nate Moore | Jan 19, 2010 | Pivot Tables
Excel Video 24 walks through the Display tab of the Pivot Table Options menu. There are a couple of highlights worth mentioning. Watch the video to learn what a contextual tooltip is and how to turn them on or off. For those of you who have used Pivot Tables before...
