Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using a Custom List

The video tutorial explains how to sort data using custom lists in Excel. It begins by introducing the concept of custom sorting, which allows users to sort data in a specific order beyond the default A-Z or Z-A options. The tutorial then guides viewers through creating a custom list by typing the desired order in a blank cell and setting it up in Excel's advanced settings. It also covers how to import existing lists and apply them to sort data. Finally, the video demonstrates using the custom list as a sort order and confirms that deleting the original entries does not affect the custom sort order.

What is the purpose of using a custom sort in data management?

Describe the steps to create a custom list for sorting.

How can you import a custom list from cells in a spreadsheet?

Explain how to apply a custom sort order to your data.

What happens to the sort order if you delete the entries from the custom list?