By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-sort-sortby/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Learn how to use the SORT and SORTBY functions in Microsoft Excel to return dynamic spilled arrays of sorted values. You'll learn how to sort single rows and columns as well as entire tables; how to change the sort order; and how to sort by multiple values.

Chapters
00:00 Topic list
00:41 Sorting a Single Column using SORT
02:06 Sorting a Single Column using SORTBY
03:05 Creating Named Ranges
05:08 Sorting a Single Column by Another Column
06:01 Returning Multiple Columns
08:24 Changing the Sort Order
09:44 Sorting by Multiple Columns
11:19 Sorting Columns instead of Rows

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!