Microsoft recaps Excel’s June 2026 features, including Copilot personalization, more file support, workbook rules, and PivotTable fixes.
Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday ...
PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change ...
Microsoft added reusable Skills, new financial data connectors, and traceability features to Copilot in Excel, built specifically for finance teams.
Power Query and Power Pivot help Excel users manage large datasets more efficiently. Power Query focuses on cleaning and preparing data, while Power Pivot handles analysis and reporting. Together, ...
DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular ...
SlothDB is a from-scratch C++20 embedded SQL database in active development. Same model as DuckDB and SQLite: query Parquet, CSV, JSON, Arrow, Avro, SQLite, and Excel files directly with SQL, ...
Today is Microsoft's March 2026 Patch Tuesday with security updates for 79 flaws, including 2 publicly disclosed zero-day vulnerabilities. This Patch Tuesday also addresses three "Critical" ...
Structured references in Excel often get a bad reputation for being overly complex, but this perception usually stems from misunderstanding their purpose and functionality. Unlike traditional cell ...