July 05, 2019
Dynamic arrays in Excel with Python and xlwings
July 15, 2017
The days of Ctrl-Shift-Enter and You can't change part of an array are finally over! Say hello to the new dynamic arrays that Microsoft has now (July 2019) rolled out to a broader user base: their Office 365 subscribers who are on the monthly channel.
Tired of Excel's VLOOKUP? Use SQL queries on Excel ranges!
October 17, 2016
If you have the free xlwings Excel add-in installed, you can query your data using standard
SQL statements, like this:
Unit Tests for Microsoft Excel
September 23, 2016
Many (business) users use Excel to create full blown applications. However, unlike applications developed by professional
software developers, Excel tools fall short of most software development practices that are considered minimal standards.
This introduces risks that can lead to reputational damages and substantial financial losses (remember the
How to fetch Market Data in Excel like a Pro
Get market data from Quandl and other data providers directly via cell formulas: