power query

If your Power BI reports still use the Intune Data Warehouse beta connector, Microsoft says you must move them to Intune connector v2 or the OData Feed connector before the retirement finishes after a gradual rollout beginning in late April 2026. Reports created after November 2025 already use...

Microsoft Excel still does several important jobs better than Google Sheets in 2026: it runs as a full desktop spreadsheet offline, handles larger local workbooks, includes native Power Query and Power Pivot workflows, and offers built-in what-if analysis tools for forecasting and decision...

Microsoft’s January 2026 Excel update is one of the most consequential monthly refreshes in recent memory: Agent Mode moved out of limited previews and into broader availability on desktop, the full Power Query experience landed in Excel for the web, Microsoft introduced lightweight...

Microsoft’s Copilot has moved well beyond chatty sidebar suggestions and is now a full-fledged productivity engine inside Excel, capable of writing formulas in plain English, importing and cleaning data, building dashboards, running Python analysis in the cloud, and even planning and executing...

Microsoft’s latest push turns Excel from a formula tool into a task‑oriented assistant that can plan, build and validate multi‑step solutions inside workbooks — generating formulas, creating PivotTables and charts, running Power Query transforms, and even inserting Python analysis based on a...

Microsoft’s recent Excel updates bring four practical changes this December that aim to speed data work, tighten collaboration, and — unsurprisingly — fold AI more deeply into everyday spreadsheet tasks. The headline items are expanded Agent Mode with live web search and optional Anthropic...

Opening a JSON file on Windows 11 is usually a two‑minute task — but doing it safely, with the right tool for reading, editing, validating, or importing data, requires deliberate choices. The quick options are Notepad for a plain‑text look, Visual Studio Code or Notepad++ for syntax‑aware...

AI is turning Excel from a gatekept specialist tool into a practical, learnable application—one where novices can move from confusion to confident analysis in a fraction of the time previously required. Overview The last two years have seen a rapid infusion of generative and context-aware AI...

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

Microsoft’s latest Excel headlines have been dominated by bold AI stunts — Copilot, on-cell generative functions and natural‑language formulaing — but one of the oldest, most reliable features in the spreadsheet deserves a second look: PivotTables. Used judiciously, PivotTables remain the...

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

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

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

Microsoft Excel users are enjoying a wave of innovation as August 2025 ushers in five noteworthy features designed to supercharge productivity, bolster data integrity, and bridge long-standing gaps across platforms. From automation and compatibility improvements to sweeping enhancements in data...

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