Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using Custom Lists

The video tutorial covers sorting data in Excel pivot tables. It begins with basic sorting techniques, such as sorting by the sum of profit, and progresses to more advanced methods like creating custom sort orders. The tutorial explains how to manually rearrange items and use custom lists for consistent sorting across multiple pivot tables. It provides step-by-step instructions on setting up and applying custom lists, ensuring data is organized according to specific needs.

What changes does the teacher make to the pivot table before sorting the data?

Describe the process to sort data by the sum of profit in a pivot table.

How can you set a specific sort order for products in a pivot table?

What steps are involved in creating a custom list for sorting in a pivot table?

Explain how to apply a custom sort order to a pivot table after creating it.