Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...

Merge lists even with typos and inconsistent names. Tune the similarity threshold, use a transform table, and audit results ...

Turn ranges into tables, add totals, filter instantly, and insert rows faster. These shortcuts make table work feel effortless.

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.

After a brief pause at the end of last year, Microsoft is back with its monthly feature recap, sharing what changed across its productivity apps in January 2026. And this time, the spotlight is on ...