This month’s column explains how the new AI tool known as ChatGPT can help with challenging Excel tasks such as creating PivotTables and writing macros.

You can use it to write Excel formulas, too, and the best part is that it's very straightforward. We'll walk you through the step-by-step process of how to make Excel formulas with ChatGPT.

Since 2023, Microsoft has offered Copilot to certain Microsoft 365 users. Here are the best ways to use the company's AI tools with Excel.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.