Select Page


Lesson 12 demonstrates a couple of formatting tricks to make your Pivot Tables look really good. Excel has set up a variety of Pivot Table styles in the Design toolbar that make it easy to select any of a variety of formats for your data. If you’ve used styles in the past or in other Office products, you’ll recognize that all of the examples in the video are based on the default Office style. If you want to see more style options that will change these Pivot Table design options, select Themes on the Page Layout tab of the Office 2007 ribbon. Play with the other design options, as well as row and column headers/bands, to get the look you want. There’s no reason impressive data can’t look impressive, too. I’m willing to bet these formatting options are a little more robust that what your practice management software offers.