power query

  1. Ha Dang Wins the UK Excel Championship, Heads to Las Vegas World Final

    Ha Dang's victory in the inaugural UK Excel Championship turned a quiet London livestream into a high-pressure showcase of spreadsheet speed, logic and fluency — and it means the Leeds-based accountant will represent the United Kingdom at the Microsoft Excel World Championship in Las Vegas this...
  2. COPILOT in Excel: AI as a native formula for smarter spreadsheets

    Microsoft has quietly folded generative AI into Excel’s calculation engine with a native worksheet function — =COPILOT(...) — that accepts plain‑language prompts, reads cell ranges as context, and returns live, spillable outputs directly into the spreadsheet grid. Early previews show it can...
  3. Master Power Query in Excel: Turn Messy CSVs into Repeatable Data Pipelines

    I had been ignoring Power Query for years, treating Excel like a calculator with a few handy formulas—until a messy, cross‑vendor CSV pile forced me to learn the tool everyone always brags about. What started as a tedious weekend of copy‑pasting and find‑and‑replace turned into a few well‑chosen...
  4. August 2025 Excel Update: Auto-Refresh PivotTables, Unicode Improvements & Cloud Data Integration

    Microsoft Excel users are entering a new era of productivity this August, as fresh features arrive across Windows, Mac, and the web—moving the world’s leading spreadsheet platform ever closer to a seamless, modern, and highly collaborative experience. These updates, mainly available to Microsoft...
  5. Exciting Excel 2025 Updates: AI, Power Query, Python & More

    Microsoft Excel, arguably the most battle-tested spreadsheet tool used by number crunchers far and wide, has been continually evolving for decades like your favorite pop culture sequel. The latest updates announced for 2025 carry the momentum of significant gains made in 2024—putting a spotlight...