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 ...

To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...

Handle millions of rows by loading queries into Power Pivot, building relationships, and creating measures for fast variance ...

is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers. After ...

Microsoft has announced some improvements to the way formulas work in Microsoft Excel, introducing a new capability called Dynamic Arrays, which was first announced last year, but only available to a ...

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.