The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

In a support page, Microsoft notes that because the function uses AI, it can provide incorrect responses. As such, Microsoft ...

Add articles to your saved list and come back ... Both Solares and Gaitain give the humble IF function their vote for “Best Supporting Actor”, describing it as Excel’s “drama queen” and “foundation of ...

Learn how to use Excel’s XLOOKUP function to simplify data retrieval, save time, and master spreadsheets with this quick beginner’s guide.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

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

If you want to learn more functions and formulas in Excel, we also have guides on how to count distinct values in a table and how to add bold text in formulas. Our latest guide shows you how to use ...

The best way to search for multiple criteria in Excel is with the XLOOKUP function, and this guide will show you how to properly use it.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Microsoft is expanding Excel with new regex modes for XLOOKUP and XMATCH. AI-powered Copilot assists in creating regex patterns.