On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

The number format drop-down in the Home tab of Excel's ribbon is expanded, and Text is selected. A two-way lookup in Excel using INDEX and XMATCH to return the profit earned by an employee in 2021.

You can now click the drop-down arrow in cell B9 to select a valid game number, safe in the knowledge that even if you add extra columns to your table, CHOOSECOLS and the named range in data ...