I am a firm believer that VBA is the easiest programming language in the world to learn, thanks to Excel’s macro recorder. Ideally consumed in a dual monitor environment, you can set up the Visual ...

"Aibi-san, even if I press the refresh button and go make a cup of coffee, it's still spinning when I get back." Last autumn, an accounting manager at a client company came to me with this complaint.

This article is not about ethics, privacy, security, ownership, or corporate governance — I am going to circumvent all of this here by using some made-up data relating to supermarket sales: Here, I ...

Easily create SQL queries and execute them on a database. For an example on how to use this library with data objects, see the VBA-Drupal-Library. For other examples on using the library, refer to the ...

It’s not a bubble; it’s a disrupter. Like it or not, artificial intelligence (AI) is transforming the finance sector at a pace that is difficult to either keep up with or maintain. Meanwhile, on Sept.

If you’ve ever asked yourself, “Should I learn VBA or SQL for finance?” you’re not alone. Every year, thousands of finance students and young analysts waste months learning tools that don’t age well ...

Excel as we know is a spreadsheet tool and over the years, it has transformed into a crucial tool in data analysis. Although there are many more specialized programs for use in data science such as ...

Run DuckDB inside Excel VBA: pandas-style analytics via in-process SQL + native C bridge. High-speed Range/Array ingestion, Parquet/CSV/JSON I/O. This project analyzes the IMDB movie dataset using ...

Logos of Microsoft Access and SQL on a blue background.Interesting Engineering MS Access is a popular desktop database application that allows users to store and manage large amounts of data. However, ...