Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

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

Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday spreadsheet work.

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

Traditional RAG systems struggle bridging structured SQL databases and unstructured document collections (a challenge we call the modality gap), leading to incomplete reasoning and hallucinations.

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

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...