Join Curt Frye for an in-depth discussion in this video Highlighting the top or bottom values in a PivotTable, part of Excel for Mac 2016: Pivot Tables in Depth.
- Companies of all kinds are interested…in their best sales people, their best customers,…and their best selling products.…Excel enables you to create…what are called "Top 10" conditional formats…to identify the top or bottom values…within a PivotTable.…I'll show you how to create these Top 10 formats…using the Top 10 workbook.…That's a sample file that you can find…in the chapter five folder…of your exercise files archive.…This PivotTable contains data…broken out by year, month, and room.…
A room type for a hotel.…So in 2014 I have Westminister rooms,…and scrolling down we have Oxford,…Picadilly, and Cambridge.…And then we repeat the same structure for the year 2015.…So I'll scroll back up to the top.…And let's say that I want to show the top five values,…to do that I would click any cell…in the body of the PivotTable…and then go to the PivotTable Analyze tab,…click Select, and click Entire PivotTable.…
Now, and I'll clear the PivotTable builder…so it's not in the way,…I'll click the Home tab,…click the Conditional Formatting button,…
Author
Curt Frye
Released
3/19/2016- Formatting data for use in a PivotTable
- Creating a new PivotTable
- Creating a Recommended PivotTable
- Connecting to external data sources
- Summarizing totals and other data fields
- Creating calculated fields
- Summarizing field data
- Sorting and filtering PivotTables
- Working with Excel slicers
- Formatting PivotTables styles and layouts
- Applying conditional formats
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 16s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 6s
-
Creating a PivotTable3m 12s
-
Pivoting a PivotTable2m 57s
-
Configuring a PivotTable3m 51s
-
Managing PivotTables4m 16s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field3m 13s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data3m 15s
-
Formatting slicers3m 44s
-
-
4. Formatting and Printing PivotTables
-
Applying a PivotTable style3m 30s
-
Creating a PivotTable style4m 32s
-
Printing a PivotTable3m 18s
-
-
5. Applying Conditional Formats to PivotTables
-
Conclusion
-
Next steps1m 46s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Highlighting the top or bottom values in a PivotTable