Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
Play lesson

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

5.0 (0)
9 learners

What you'll learn

This course includes

  • 5.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere