Delete empty rows in Excel
December 14, 2021Suppose you have a long list of data that contains a number of empty rows or cells. The empty rows… Read more
Category: Excel
Rainfall radar in Excel with JSON
November 2, 2021The possibilities in Excel are virtually unlimited. You can even create your own rainfall radar and process the data in a… Read more
Convert Unix Timestamp to Excel Date
October 19, 2021What is a Unix Timestamp? A Unix timestamp is the number of seconds that have passed since January 1, 1970 midnight. Here are… Read more
Apply leading zeros in Excel
October 14, 2021Introduction Excel is a handy program that you can use not only for working with numbers, but also for… Read more
Add macro to context menu
October 11, 2021If you often use a certain macro, it can be useful to add it to the… Read more
Remove password protection from Excel file
13 May 2021Excel files have the option to provide them with password protection. I use it once in a while. For example to… Read more
VLOOKUP vs INDEX
5 May 2021Vertical search The VLOOKUP() function allows you to search a table or range for a specific value. For example on… Read more