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.
Category: How To
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:
Like many people, I have gone from not having any face masks other than PPE for chemical exposure to having a small collection of the things for use when I’m out and about. That’s all well and good, but wearing them means that I have to use my code to unlock my iPhone, which gets annoying.
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.
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:
A few years ago, I wrote about the workflow I have for video editing. One thing I did not touch upon was the fact that a not insignificant amount of my raw footage comes from GoPro cameras. As anyone who has used GoPro cameras will be able to tell you, the file naming convention they use is annoying as heck.
One of the features in Safari that I use a fair amount is called reader mode. Simply put, it strips an article of extraneous content (such as ads), and allows me to focus on the article itself. Here’s how you use it:
As anyone who has been using iPhones for a while can tell you, one of the most time consuming parts about getting a new iPhone is downloading all the apps. Some apps are more important than others, and it would be nice if there was a way to tell the iPhone which apps to prioritise. As it turns out, you can. Here’s how:
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:
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: