Skip to content

Category: How To

How to block everyone who likes a tweet on Twitter

I am a relatively active Twitter user. One of the things I do in order to keep Twitter a fairly enjoyable place, is to actively use the Block feature. I usually leave it at blocking individual users, but some tweets are simply so nasty that I don’t only want to block the user that tweeted (twote?) the tweet, but also anyone who likes it.

Leave a Comment

Calculating percentage change in Excel

If you do a lot of work in Excel, odds are you’ve needed to calculate a percentage change. Luckily, Excel does this for you quite readily if you simply apply a basic formula of (New Value - Old Value)/Old Value. There is, however, a pitfall that you’ll not get the values you expect if the cell where you’re entering the value is not set to percentage formatting. Hence, here’s a step to step way to make the calculation:

Leave a Comment

Creating habits to separate work-time from off-time

Since March of last year I have, for the most part, been working from home. While we were able to work out the kinks in keeping connected to the rest of the team relatively quickly, I’ve found shutting off work-mode to be a bit harder. I find myself wanting to check stuff in the evenings, working longer days (and not just because the work needs to get done), and generally being mentally “at work”, even when I’m patently not at work.

Leave a Comment

Tools for account evaluation on Twitter

I am a relatively active Twitter user, and enjoy the many discussions I have with people of varied points of view and experiences on the site. One of the things I don’t enjoy, is the inevitable trolls and bots. Luckily, there are a number of tools out there that evaluates an account or tweet. I have found the following to be particularly useful:

Leave a Comment

Finding all groups without a manager in a specific OU in AD

Last week, I showed you how you can easily find the OU to use when looking for the members of a specific OU. Today, I’d like to show you how I use that information. The background was that we use AD groups to control access to network shares. In order for IT support to know who is authorized to approve requests for access to these shares, we use the Managed By tab, assigning the owner of the network share as manager:

Leave a Comment

Finding the full OU path of an AD OU

Using PowerShell, I was building a script to identify a subset of the groups in a given organizational unit (OU). As you may know, these are built up of subsections with the prefixes CN (common name) and DC (Domain Component). In order to have the script run successfully, you need to specify the OU using the full path, which looks something like this: CN=Users,DC=Fabrikam,DC=com.

Leave a Comment