How to SORT data on single & multiple criteria in Excel? (Covers SORT & SORTBY functions)

Sort operation is one of the most fundamental operations in Excel.

Yet there are so many options of Sort, which are not so widely known. In this video, we will cover most of them, including sorting fundamentals and custom sort.

Besides the utility, we will also look at the SORT and SORTBY functions. These functions enable you to sort your data based on single or multiple criteria, providing you with a powerful tool for enhancing your data analysis skills.

The ability to sort data using functions helps you perform complex operations and automations, which would be otherwise not possible depending only on the sort utility.

🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:13 - Using Sort for a single criteria - by selecting a single value
01:27 - Using Sort for a single criteria - by selecting a column
02:48 - Sorting on multiple criteria
04:59 - Sorting data using the SORT function
05:56 - Sorting data on multiple levels using the SORTBY function

▶️ Other videos that may interest you
How to SORT data on Months and how to create a CUSTOM SORT list? (Windows and Mac)
https://www.youtube.com/watch?v=iP2ij6SBOWI

✅ Subscribe to our Channel to level up your Excel skills faster
https://www.youtube.com/@analyticssuccess?sub_confirmation=1

⬇️ Download the file used in the video
https://www.qling.net/11174/files/66c0797c01fd8_1723890044_sort-xlsx.zip

💻 Courses offered by us

Learn more about our Excel Masterclass course
https://yt.qling.net/excel-masterclass

Explore all courses
https://yt.qling.net/courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
https://yt.qling.net/excel-shortcuts

🗂️ Access all our templates and E-Books
https://yt.qling.net/templates-and-ebooks

🤝 Connect with us

LinkedIn: http://www.linkedin.com/company/qling1
Facebook: http://www.facebook.com/learnatqling
Instagram: http://www.instagram.com/learnwithqling
Pinterest: http://www.pinterest.com/learnatqling/
Get in touch: https://quiz.qling.net/get-in-touch/

#analyticssuccess, #SortDataExcel, #ExcelTips, #ExcelFunctions, #SortAndSortBy, #MicrosoftExcelTutorial, #DataOrganization, #ExcelProductivity, #SpreadsheetSkills

Видео How to SORT data on single & multiple criteria in Excel? (Covers SORT & SORTBY functions) канала Analytics Success