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.

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.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Screenshot by Maria Diaz/ZDNET What you need: Using ChatGPT to write an Excel formula requires access to Microsoft Excel or Google Sheets, as these formulas can be used for both applications.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.