Have you ever found yourself endlessly dragging formulas across rows or columns in Excel, only to realize there’s got to be a better way? Maybe you’ve spent hours creating helper columns or ...

Most people are still using Excel like it’s 2010 with functions like INDEX MATCH, SUMIFS, or VLOOKUP. In this video, we’ll explore 5 NEW Excel functions that can replace numerous old ones, allowing ...

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’s new Copilot function in Excel lets users generate, analyze and explain data directly from cell formulas, marking a major step toward full AI integration within spreadsheets. Microsoft’s ...

Microsoft is testing a new TRIMRANGE function in Excel which is designed to delete empty rows from the edges of a range. Microsoft is once again allowing members of its Microsoft 365 Insider program ...

Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Stop updating Excel manually. Discover how to use dynamic array formulas to create self-updating reports and dropdown lists ...

Share on Facebook (opens in a new window) Share on X (opens in a new window) Share on Reddit (opens in a new window) Share on Hacker News (opens in a new window) Share on Flipboard (opens in a new ...

Microsoft has added some new cut and paste improvements for people that access the Excel spreadsheet app on the web, including some new ways to drag and drop data in rows or columns. Microsoft is ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Excel’s newest Copilot integration finally delivers the data intelligence Microsoft promised years ago, transforming how users clean, organize and understand information within their spreadsheets. Way ...