The 2019 version of Excel contains a wide assortment of new and improved features and capabilities. Here's a look at 12 of those upgrades.

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.

While functions are typically used for computational purposes, they can also be used to change a spreadsheet's overall look. Here's an example using Excel's MOD function.

A cluttered Excel sheet can be a nightmare—extra spaces, inconsistent formatting, random text everywhere. But with the right functions, you can clean it up in seconds and make your data actually ...