Learn how conditional formatting rules applied to PivotTables adapt to layout changes, but not always predictably, as you add additional fields to the PivotTable.
- [Instructor] Excel's pivot table capability…is a great tool for analyzing data.…On this worksheet called pivot table data,…I've got a list of over 900 rows here.…It's not in any particular order, nor does it need to be.…We want to come up with some good quick summary totals here…and then consider the layout and make some changes,…and we can use conditional formatting…in a pivot table as well.…If you have not worked with pivot tables,…I think what you're about to see…is going to be enlightening,…and if you have worked with pivot tables,…I think you'll see that the addition…of conditional formatting can make some real difference…as you're presenting the data to others.…
This list has no empty rows or columns in it.…Let's use it as the source for pivot table.…Insert tab in the ribbon, left button, pivot table.…Often you'll put a pivot table in a separate sheet.…I'm going to put it on this existing worksheet,…clicking the button down here,…click on the location panel,…I'll click on cell I1, and okay.…And we're on our way.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows