Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Microsoft recaps Excel’s June 2026 features, including Copilot personalization, more file support, workbook rules, and ...

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

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

Spreadsheet apps like Microsoft Excel and Google Sheets are used worldwide to organize and analyze data, but getting the right information into them isn’t always straightforward. Businesses often need ...

Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot component that works with the Shiny web framework and is compatible with R and ...