Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
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
Section timings:
Sort basics: 0:45
Sorting by custom lists: 3:38
Multiple-Level sorting: 4:44
Sorting by color: 5:52
Sorting by icon: 7:42
Un-sort data: 9:12
🡻 Download the workbook here 🡻
https://www.xelplus.com/excel-sort-by-value-color-icon-own-list-how-to-unsort/
★ 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 ★★
Courses ► https://courses.xelplus.com/
🕮 Excel Resources I Recommend 🕮
https://www.xelplus.com/resources/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
Видео Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort канала Leila Gharani
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
Section timings:
Sort basics: 0:45
Sorting by custom lists: 3:38
Multiple-Level sorting: 4:44
Sorting by color: 5:52
Sorting by icon: 7:42
Un-sort data: 9:12
🡻 Download the workbook here 🡻
https://www.xelplus.com/excel-sort-by-value-color-icon-own-list-how-to-unsort/
★ 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 ★★
Courses ► https://courses.xelplus.com/
🕮 Excel Resources I Recommend 🕮
https://www.xelplus.com/resources/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
Видео Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Filter Basics (for quick data analysis)Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)Excel shortcut keys you SHOULD know!How to Filter in Microsoft ExcelLock Cells & Protect Excel Worksheet - EVEN by Cell Color!SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)How Power Query Will Change the Way You Use ExcelSearchable Drop Down List in Excel (Very Easy with FILTER Function)Return Multiple Match Results in Excel (2 methods)3 EASY Ways to Find and Remove Duplicates in ExcelExcel Header & Footer (& Quickly Copy to other Sheets)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)Click to Reveal in PowerPoint | Trigger an Animation When YOU NeedAdvanced Excel Filter (And, Or, Between conditions for criteria range)Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)MS Excel - Data SortingExcel's Find and Replace (surprising features)