Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses
Sorting is super easy in Excel! You'll learn how to sort by values (ascending, descending), how to sort alphabetically & much more:
1. Sort multiple columns in Excel
2. Sort based on custom lists (including user defined sort order)
3. Exclude ranges from the sorted list
4. Sort by cell color
5. Sort by cell icon (conditional formatting result)
6. How to UN-Sort your data to get back to the original sort order
⬇️ Download the workbook here: https://pages.xelplus.com/sort-unsort-file
What You'll Learn:
- Basic Sorting Techniques: Understand how to sort data numerically and alphabetically.
- Custom List Sorting: Create and apply your own sorting preferences to reflect specific organizational needs.
- Color and Icon Sorting: Dive into advanced sorting options based on cell colors and conditional formatting icons.
- Multi-Level Sorting: Implement multiple sorting criteria for detailed and organized data analysis.
- Preserving Original Data Order: Learn the trick to maintain your original row order using a simple helper column.
00:00 How to Sort and Un-sort Data in Excel
00:45 Sort basics
03:38 Sorting by custom lists
04:44 Multiple-Level sorting
05:52 Sorting by color
07:42 Sorting by icon
09:12 Un-sort data
Links to related videos:
Check out the Excel Basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
How to use Excel Filter: https://youtu.be/wMlTDXPEjag
My Online Excel Courses https://www.xelplus.com/courses/
️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel