Join 400,000+ professionals in our courses here 👉 [ Ссылка ]
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: [ Ссылка ]
🔑 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: [ Ссылка ]
How to use Excel Filter: [ Ссылка ]
★★ My Online Excel Courses ★★ [ Ссылка ]
➡️ Join this channel to get access to perks: [ Ссылка ]
👕☕ Get the Official XelPlus MERCH: [ Ссылка ]
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: [ Ссылка ]
🎥 RESOURCES I recommend: [ Ссылка ]
🚩Let’s connect on social:
Instagram: [ Ссылка ]
LinkedIn: [ Ссылка ]
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
