Excel for Data Analysis and Visualization

Working with the Columns in a Pivot Table

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Not only can you categorise a Pivot Table in the rows, but you can also use the columns. All the options available to you on the Rows are also available in the columns.

This lesson shows you how to work with the columns in a Pivot Table and search for parts of a name, or search in the label or value filters, using the the Top 10 Option in the Value Filter to make sure that the Pivot Table doesn’t overwrite another pivot table, sort rows based on the words in the field itself (generally alphabetically), or one of the value fields.

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop