To address these issues and enhance the formula writing experience, Microsoft has developed a new tool called the Advanced Formula Environment (AF) for Excel 2019 and later versions.

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

Our visual guide helps you find the most popular commands on the Ribbon in Excel 2016 and 2019 for Windows, along with keyboard shortcuts for performing each action.