Select Page

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

Excel Video 23 Grand Totals and Custom Lists

Excel Video 23 is the second part of our coverage of the Pivot Table options menu. Most of the time, you’ll want to include grand totals in the rows and columns of a Pivot Table, but if you’ve got data like PSA scores, total PSA scores may not be meaningful. Here’s an...

Excel Video 22 Pivot Table Options, Part 1

Excel Video 22 starts another set of videos. Part 1 shows you where the Pivot Table Options menu is and covers the first tab, Layout & Format. These formatting options are helpful when you’re formatting a Pivot Table to print, when you’ve got a lot of filters at...