How-To Geek on MSN

How to use fuzzy matching in Power Query to clean up Excel data

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

Put Excel into Easy Mode by Implementing First Normal Form (1NF)

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.

Power Query Isn’t Required: New Excel Functions Handle Straightforward Sources Cleanly

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
How-To Geek on MSN

Stop wrestling with text in Excel: These 8 tools are game-changers

Fix "fake" numbers, strip hidden web spaces, and join text professionally using Excel's built-in legacy and modern tools.
ksn.com

EXCEL USERS REJOICE: Akkio Launches Chat Data Prep, the First Machine Learning Platform to Transform Data Using Ordinary Conversational Language

CAMBRIDGE, Mass., Jan. 18, 2023 (GLOBE NEWSWIRE) -- Akkio, the no-code AI company, today announced a new way to interact with data that brings the latest advances in machine learning (ML) to everyday ...

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

Microsoft updates for Excel in January 2026 introduce Agent Mode with Copilot, new import tools, clearer error messages, Power Query on Mac and Web, and Office Scripts automation to ease daily tasks.