Custom Sorting in Excel: sorting your data by season and by zodiac symbol

/in /by

Let’s go back to some basics. There’s a lot of cool, brand new stuff in Excel. But I still see basic goofs committed by longtime professionals. Recently I saw a lot of graphs that showed values in the order:
1. Afternoon
2. Evening
3. Morning
4. Overnight

That alphabetical order makes no sense based on what we know about real life and how a day works. 😵‍💫

In this video, we’re going to review Custom Sorting in Excel. Specifically:
– Sorting students by season/session
– Sorting your list of friends chronologically by their zodiac signs.

In this video I show you how to create a Custom List 2 ways:
1. the basic way in the Sort dialogue box and,
2. by importing a list that’s too big to type.

Also! You get to see XLOOKUP used with icons as the lookup values. 🥳

#CustomSorting
#exceltutorial
#ExcelOnFire

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2