Just in case modern-day spreadsheets don't already have enough functions for you, I learned that both Microsoft Excel and Google Sheets have added the ability to define your own custom functions, even without having to learn a new programming language. If you can express what you want your function to do in terms of standard … Continue reading Easily write your own custom functions in Excel and Google Sheets with LAMBDA
Tag: Excel
Solving the the case of the 6cm man with assertive programming
Liam Thorp, political editor of the Liverpool Echo, was recently surprised to receive an invite to receive a Covid-19 vaccine. Whilst the UK does seem to be numerically ahead in absolute terms of many (but not all) other countries when it comes to at putting first-doses into people, we're still at the stage where only … Continue reading Solving the the case of the 6cm man with assertive programming
New chart types coming in Excel 2016
As far as I can recall, it has been many many years since a new chart type of significance has found its way into an Excel update. However for the 2016 release we're getting some new treats, as seen in this presentation from Scott Ruble. Several of those chart types are versions of what could already be done in … Continue reading New chart types coming in Excel 2016
Why version 9 will {FIX} Tableau for me (and workarounds in the mean time)
Excitement builds within the dataviz world as the next version of Tableau gets close to launch, supposedly within the next 60 days. It has many new features, which data geeks and other fans can see an preview being dripped out piece by piece in the Tableau blog, and summaries elsewhere, but one has really caught my attention, … Continue reading Why version 9 will {FIX} Tableau for me (and workarounds in the mean time)