More than six years ago, I wrote a post, detailing how I could identify users’ Active Directory group memberships. While the method I detailed certainly works, it isn’t as simple as it might have been. Having recently found myself needing to perform that very same task again, I decided to revisit this topic, to show how I did it this time around.
Category: Tips & Tricks
I need to calculate what percentage one number is of another on a relatively regular basis. Luckily, it is relatively easily done using functions in Excel. Here’s how:
While analysing an Excel sheet the other day, I needed to combine two columns so that I could get names in the format
firstname lastname (the list had been provided as
lastname,firstname). As it happens, doing so is relatively easy. You do it on a cell by cell basis, by using basic excel commands.
I recently learned of a nifty little trick for users of Google’s Workspace services (i,e. Docs, Sheets, Slides, Forms etc.): You can start a new document, spreadsheet, slide deck and so on from the address bar of your web browser. Simply enter the appropriate command (below) into the address bar, hit return, and watch as it unfolds:
Search engines can be a great way of finding what you’re searching for. Using them to their fullest extrent, however, requires a bit of knowledge about how to structure your searches. These examples are some that I use on a regular basis:
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.
Since starting to use Microsoft Teams, I’ve been encountering an issue when calling in to meetings; when joining a meeting, I’d get a loud buzzing on top of the meeting audio. Said buzzing was reminiscent of dial tones of yore. Digging into it a bit, I found that the buzzing ceased when I exited Skype for Business. Looking further, I was able to solve the issue by disabling the dial tone in sound settings. Here’s how:
A little while ago, I needed to simulate the File Explorer presentation of a network share in order to illustrate a point to a very non-technical customer of mine. Luckily, this is very easily accomplished through the use of either the
net use command line commands.
A pet peeve of many users of Outlook is the fact that deleted messages that were unread when being deleted are counted in Deleted Items. Like the behavior when going from one unread email to another in the Reading Pane, there is a setting for this. Here’s how to change the behavior:
Like many others, my work days are – to some extent – made up of meetings with others. It’s not uncommon for these meetings not to have an assigned meeting room, and I find it annoying that Outlook asks me if I want to enter a meeting location: