Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

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

Автор: Leila Gharani

Загружено: 2018-10-11

Просмотров: 338435

Описание:

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

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

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(10) { [0]=> object(stdClass)#6191 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "FRiFfKb_B_A" ["related_video_title"]=> string(60) "Create SMART Drop Down Lists in Excel (with Data Validation)" ["posted_time"]=> string(19) "7 лет назад" ["channelName"]=> string(13) "Leila Gharani" } [1]=> object(stdClass)#6164 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "M6AvvNQ9vf4" ["related_video_title"]=> string(34) "How to SORT Data in Excel | 7 Tips" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> string(12) "Chris Menard" } [2]=> object(stdClass)#6189 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "a3-nkc_VUF0" ["related_video_title"]=> string(123) "Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!" ["posted_time"]=> string(21) "5 дней назад" ["channelName"]=> string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ" } [3]=> object(stdClass)#6196 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "wMlTDXPEjag" ["related_video_title"]=> string(45) "Excel Filter Basics (for quick data analysis)" ["posted_time"]=> string(19) "7 лет назад" ["channelName"]=> string(13) "Leila Gharani" } [4]=> object(stdClass)#6175 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "VqQACB_69SQ" ["related_video_title"]=> string(70) "Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)" ["posted_time"]=> string(19) "7 лет назад" ["channelName"]=> string(13) "Leila Gharani" } [5]=> object(stdClass)#6193 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "RXSH2UiDc5g" ["related_video_title"]=> string(49) "NEW Excel Drop-Down Lists That Adapt to Your Data" ["posted_time"]=> string(27) "9 месяцев назад" ["channelName"]=> string(19) "MyOnlineTrainingHub" } [6]=> object(stdClass)#6188 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "Rm4y5UqauRw" ["related_video_title"]=> string(47) "Excel LAMBDA - HOW & WHEN you Should use it" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> string(13) "Leila Gharani" } [7]=> object(stdClass)#6198 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "_2whgXh8Cxw" ["related_video_title"]=> string(80) "Функция ВПР excel за 5 минут ► VLOOKUP in Excel for 5 minutes" ["posted_time"]=> string(19) "5 лет назад" ["channelName"]=> string(58) "Университет Алексея Полянского" } [8]=> object(stdClass)#6174 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "GX01Lh2IU68" ["related_video_title"]=> string(113) "ОТКУДА В АНГЛИЙСКОМ СТОЛЬКО КОСЯКОВ - и как понять исключения?" ["posted_time"]=> string(21) "5 дней назад" ["channelName"]=> string(36) "Virginia Bēowulf · English Studies" } [9]=> object(stdClass)#6192 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "bky4L7VbAuM" ["related_video_title"]=> string(137) "Задание на собеседовании по математике в Harvard University слабо решить Can You solve This" ["posted_time"]=> string(25) "2 недели назад" ["channelName"]=> string(31) "Дмитрий Компанец" } }
Create SMART Drop Down Lists in Excel (with Data Validation)

Create SMART Drop Down Lists in Excel (with Data Validation)

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

Excel Filter Basics (for quick data analysis)

Excel Filter Basics (for quick data analysis)

Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)

Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)

NEW Excel Drop-Down Lists That Adapt to Your Data

NEW Excel Drop-Down Lists That Adapt to Your Data

Excel LAMBDA - HOW & WHEN you Should use it

Excel LAMBDA - HOW & WHEN you Should use it

Функция ВПР excel за 5 минут ► VLOOKUP in Excel for 5 minutes

Функция ВПР excel за 5 минут ► VLOOKUP in Excel for 5 minutes

ОТКУДА В АНГЛИЙСКОМ СТОЛЬКО КОСЯКОВ - и как понять исключения?

ОТКУДА В АНГЛИЙСКОМ СТОЛЬКО КОСЯКОВ - и как понять исключения?

Задание на собеседовании по математике в Harvard University слабо решить Can You solve This

Задание на собеседовании по математике в Harvard University слабо решить Can You solve This

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]