Excel Zebra stripe formatting
Home -> Conditional Formatting -> New Rule =MOD(ROW();2)=0
Thoughts on building a library – Part 2
In Thoughts on building a library I introduced you to the concept of a personal library. In this part I will guide you through some issues I had with sorting and cataloging my library Categories After buying a ton of books over the last couple of years, I hadn’t figured out yet how to categorize…
Keyboard shortcuts for signals in the macOS terminal
When working with a terminal / console in unixoid systems like Linux or macOS you may have encountered a command like CTRL + C to terminate a running process. There are a few more: Signal Control character SIGINT CTRL + C SIGTSTP CTRL + Z SIGINFO CTRL + T
Introduction to Jupyter Notebook
JuPyteR Do You know the feeling of being already late to a party when encountering something new? But when you actually start telling others about it, you realize that it is not too common knowledge at all, e.g. Jupyter Notebooks. What is a Jupyter notebook? In my own words: a browser-based document-oriented command line style…
Useful Outlook Settings
Being “forced” to use Outlook at work, I use the following configuration: Disable Popups Options -> Mail -> Message Arrival Default Reminder -> 5mins Options -> Calendar -> Calendar options -> Default reminders Activate Week Number Options -> Calendar -> Display options -> Show week numbers in the month view Enable Calendar in Mail View…
Excel Flash Fill
From time to time you have annoying things to do which you cannot avoid e.g. split names into surname and last name. Here comes the flash fill feature: Given you have the full names in column A Go to cell B1 and enter the last name Go to B2 Go to tab “Data” Click Flash…
My most used keyboard shortcuts in Windows 10
Motivation As you become more experienced as a developer you will start to work on becoming more efficient instead of only being effective. Keyboard shortcuts are a great way to achieve tasks quicker. Shortcut Action Ctrl + X/C/V 🙂 Alt + Tab Switching between programs Ctrl + Tab Switch between tabs in programs Win +…
PB SwissTool Ratchet Screwdriver
I pity the fool who hasn’t got a tool! After buying cheap tools all my life I’ve decided that I became too old for 5€ screwdriver. Our working student Michael Jäger introduced me to the brand PB Swiss Tools. They have lifelong guarantee on their tools and have some nice ideas like colorcoding their bits…
Find your mouse pointer on Windows 10
Many software developers use a multi monitor setup with two or three screens at 24 inches or more. Some folks like video editors even use giant curved screens with more than 34 inches. Thus it sometimes can become painful to find your mouse pointer on such big screen estate. On Windows 10 you can change…
Tesla P100D test drive
One item crossed off my bucket list – I drove a Tesla Model S P100D!