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

A new Excel design approach, dubbed the '10% rule,' advises showing only the most essential 10% of a workbook to users while hiding the rest. By separating data, logic, and output layers, and using ...

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

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

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