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

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...

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

This is the Power Query Custom Connector for DuckDB. Use this to connect to a DuckDB database in memory, from a local file or on MotherDuck with Power BI and Excel. Installing How to use with Power BI ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

Microsoft’s power analytics tool can do a lot more than help you visualize your data. From AI-powered insights to integrating curated data into other apps and services, here’s how to make the most of ...

There are multiple ways of how to get data from API to MS Excel, but we are going to focus on the simplest option (including video tutorial) for non-technical people: ...