This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

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 ...

Microsoft recently announced exciting updates for Microsoft 365 Insider users. On June 28, the company invited users to test two new functions in Excel: TRANSLATE and DETECTLANGUAGE. These new tools ...

Microsoft is adding a COPILOT function to Excel, letting you use natural language prompts inside formulas to analyze, summarize, and categorize data.

The new TRANSLATE function in Excel allows users to dynamically translate text into over 100 languages. This function can be particularly useful for ...

New 2024 Microsoft Excel Spreadsheet Functions Key Takeaways : Proficiency in Excel is essential for effective data management and analysis.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

From lookup functions to multi-part formulas, I wish I knew about these Excel formulas earlier because they make me feel like a data wizard whenever I use them.