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
Released
3/19/2016- Name the option you use to limit the data that appears in a PivotTable.
- Explain how to create a PivotTable after clicking a cell in the data set.
- List the steps needed to see the sum of reservations on a PivotTable.
- Recall how to return all the data to the body of a PivotTable.
- Name the contextual menu that allows you to create new PivotTable style.
- Determine the category of the Format Cells dialog that lets you change the decimal places and the money symbol.
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013: Managing and Analyzing Data
with Dennis Taylor2h 2m Intermediate -
Excel 2013: Data Validation
with Dennis Taylor1h 5m Intermediate -
Excel for Mac 2016 Essential Training
with Curt Frye6h 23m Beginner -
Setting Up a Database in Excel 2013
with Dennis Taylor49m 17s Intermediate
-
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
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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