Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...

When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the information, if you want to sort it alphabetically. Instead, you can use the ...