How-To Geek on MSN

How to use dynamic array functions in Microsoft Excel

Functions like FILTER, SORTBY, UNIQUE, XLOOKUP, and VSTACK transform static grids into real-time data systems.
YouTube on MSN

I transformed Excel with 10 key skills

In this video, we explore 10 essential Excel skills for the Modern Analyst to elevate Excel from a basic spreadsheet to a ...

9 Common Excel Myths You Need to Stop Believing Today

Stop believing outdated Excel rules and learn how to optimize spreadsheet performance using Power Query, helper columns, and ...
TechRepublic

How to combine values from a column into a single cell using Microsoft Excel’s Power Query

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s Power Query ...
TechRepublic

Pull data into Microsoft Excel with Web queries

Web queries offer a handy way to import data from selected tables into a worksheet–but Excel isn’t as accommodating as it should be, especially when it comes to parameters. These tricks will let you ...
GIZBOT

From Agent Mode to Power Query: Microsoft Details New Excel Features Rolled Out in January 2026

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