Microsoft Excel 2021365 - Beginner to Advanced - The SORTBY Function

The video tutorial explains the differences between the sort and sort by functions in Excel. It demonstrates how to use the sort by function to sort data based on different criteria, such as the number of five-star reviews or genre. The tutorial uses a data set of well-known books to illustrate sorting techniques, including sorting by multiple columns. The video emphasizes the flexibility of the sort by function in organizing data without needing to display the sorting criteria in the output table.

What is the significance of the optional arguments in the sort by function?

How does the sort by function allow for sorting on multiple columns?

Explain how to sort by genre and then by one star reviews in the sort by function.