Highlight selected row in Excel
Nov 10, 2022Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color… Read more
Does a date fall on a weekend?
28 Oct 2022In this article I explain how you can find out based on a date whether it is in… Read more
Convert JSON array to table in Power BI
26 Oct 2022Suppose you have a JSON file that looks like this and you want to import it as a table into Power BI: This… Read more
The best housing for the Raspberry Pi
20 Oct 2022The best way to protect your Raspberry Pi is to mount it in a case. Just like the… Read more
Keyboard shortcuts for filters in Excel
15 Oct 2022Microsoft Excel is ideal for performing operations on large amounts of data. One of the useful features within Microsoft… Read more
Add Shelly 1PM WiFi switch in Domoticz
March 30, 2022The Shelly 1PM is a compact switch that you can not only use as a switch, but also to… Read more
F5 key in Excel
March 13, 2022The F5 key in Excel is a bit of a neglected child within Excel. The possibilities behind this test are very useful,… Read more
AutoSum in Excel
17 January 2022If you regularly work with Excel, it often happens that you have to add columns or rows of numbers. And… Read more
Create Dynamic Range in Excel
January 4, 2022For example, in Excel you can easily fill a drop-down list with data using a range. If in the… Read more
Tado geolocation via Domoticz
December 22, 2021We have been in possession of Tado thermostatic taps for about a year and I can say that we… Read more