Learn how to sort data using Excel’s dynamic SORT and SORTBY functions. In this video, we’ll go over how to sort data using SORT and SORTBY, break down each function's arguments, how to return valuable data insights using SORT, advantages of using these functions, how to advance sort data by multiple columns using SORTBY, and more! After watching this tutorial, you will never want to sort data manually ever again.
In this tutorial, we’ll cover these use cases:
-How to sort data using SORT
-How to return top 5 sales using the SORT and TAKE functions
-How to sort data using SORTBY
-How to sort data by multiple columns using SORTBY
Excel’s SORT function allows you to sort data based on an indexed column within the data set. The SORTBY function allows you to sort data based on another array. SORTBY also allows you to perform an advanced sort by sorting data by multiple different arrays. These functions open a whole new world of opportunities when analyzing data within the worksheet.
📖RESOURCES
- Download the workbook and follow along: excel-dictionary.com/pages/yo...
🤓SHOP EXCEL DICTIONARY
- COURSES: excel-dictionary.com/collecti...
-GUIDES: excel-dictionary.com/collecti...
-MERCH: excel-dictionary.com/collecti...
-TEMPLATES: excel-dictionary.com/collecti...
📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: www.excel-dictionary.com/subs...
📺SUBSCRIBE
-Subscribe to never miss a video: / exceldictionary
🕰️TIMESTAMPS
‘0:00 Intro
‘0:30 How to sort data using SORT
‘1:49 SORT function advantages
‘2:23 Return top 5 sales using SORT & TAKE
‘2:37 How to sort data using SORTBY
‘3:45 How to sort data by multiple columns using SORTBY
‘5:04 SORTBY function advantages
‘5:15 Wrap up
#excel #exceltips #tutorial
Негізгі бет STOP Sorting Data in Excel like this…. Do this instead.
Пікірлер: 8