Blog

February 4, 2021

What Makes Excel's Lambda Functions so Awesome (and what doesn't)?

Posted by Felix Zumstein

In December 2020, Microsoft announced Lambda Functions as a new Excel feature. Lambda functions are an exciting way to define custom functions (a.k.a. user-defined functions) by only relying on Excel formulas, without having to use VBA or writing an add-in. In this blog post, we’re going to see how Lambda Functions work and why they are so awesome. It’s not all roses though: we’ll also look at the current limitations of Lambda Functions and how to solve some of them. Currently, Lambda Functions are only available to Microsoft 365 subscribers on the Beta Channel. To see if you can already use them, start typing =LAMBDA in a cell and if Excel suggests the function name, you are all set. Would you rather lean back and watch the gist of it in a video? Here you go:

Read More...

June 3, 2020

5 Python Libraries for Reporting and Factsheets

Posted by Felix Zumstein

Python is a popular tool for all kind of automation needs and therefore a great candidate for your reporting tasks. There is a wealth of techniques and libraries available and we’re going to introduce five popular options here. After reading this blog post, you should be able to pick the right library for your next reporting project according to your needs and skill set.

Read More...

July 5, 2019

Dynamic arrays in Excel with Python and xlwings

Posted by Felix Zumstein

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.

Read More...

July 15, 2017

Tired of Excel's VLOOKUP? Use SQL queries on Excel ranges!

Posted by Felix Zumstein

If you have the free xlwings Excel add-in installed, you can query your data using standard SQL statements, like this:

Read More...

October 17, 2016

Unit Tests for Microsoft Excel

Posted by Felix Zumstein

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 «London Whale»).

Read More...

September 23, 2016

How to fetch Market Data in Excel like a Pro

Posted by Felix Zumstein

Get market data from Quandl and other data providers directly via cell formulas:

Read More...

xlwings Newsletter

We help you excel with Microsoft Excel, see Past Issues.