Make Excel evaluate your data for you.

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

If Excel is showing formulas instead of results on your Windows PC, check the cell format, turn off the 'Show Formulas' ...