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

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

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

Have you ever felt like importing data into Excel is more complicated than it needs to be? Below My Online Training Hub walks through how Microsoft’s latest Excel functions, `IMPORTCSV` and ...

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

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

Don't let Excel move on without you.

Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

Overview:Excel books support long-term learning compared to short tutorials that explain quick data-centric tasks.Books ...