- The built-in pivot table style gallery contains…a lot of good color schemes…but they are by design somewhat generic.…When you want to create your own pivot table style…to reflect your personal aesthetic…or your company's graphic art guidelines…you can do so using the new pivot table quick…style dialogue box.…I'll show you how to create a custom style…for your pivot table in this movie.…My sample file is the create style workbook…and you can find it in the chapter four folder…of your exercise files collection.…To create a custom pivot table style click any cell…within a pivot table…and then on the pivot table contextual tab of the ribbon,…move your mouse pointer over the in-ribbon gallery…for pivot table styles, click the more button…and then go down to the bottom of the gallery…and click new pivot table style.…

Doing so displays the new pivot table quick style dialog box…and here you can define the elements of your style.…First, I will type a new name for the style…in the name box, so I'll type company standard 2016…

Resume Transcript Auto-Scroll

Author

Released

8/17/2016

PivotTables are one of the most powerful data analysis tools in Microsoft Excel. Learn how to use PivotTables to summarize, sort, count, and chart your organization's data in Excel for Mac 2011. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. He shows how to build PivotTables from single or multiple data sources (including external spreadsheets and text files), add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to share your work by printing PivotTables and saving them as PDFs.