Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort

Описание: Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

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...

🔑 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:    • Excel Introduction - Learn Excel Basics  
How to use Excel Filter:    • Excel Filter Basics (for quick data analysis)  


★★ My Online Excel Courses ★★ https://www.xelplus.com/courses/

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ 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:   / lgharani  
LinkedIn:   / 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