Need a formula for your Excel spreadsheet in a flash? Try ChatGPT. In this guide, we'll show you how to write Excel formulas using ChatGPT.

By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

DGET has only three arguments, making it much more straightforward to use than other Excel lookup functions. The DGET function is an old-school tool!