Select Page

Excel Video 28 Pivot Chart Example

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

Excel Video 27 Introduction to Pivot Charts

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

Excel Video 26 Grouping Numbers in 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...

Excel Video 25 Printing and Data Options

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

Excel Video 24 Pivot Table Display Options

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