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 consistent from one analysis to the next. Watch for how to set styles, how to band rows and columns, and how to create your own Pivot Table Style if you need something different than one of the default styles.
Another way to customize your spreadsheet’s colors and fonts is to change the workbook theme. Themes will give you a whole new set of Pivot Table colors and fonts to choose from. If you haven’t played with themes in Excel, take a minute with Excel Video 212. You’ll be glad you did.
