Category: Tips & Tricks

  • Notepad++: the Macro recorder

    In my last post, I detailed how I solved the challenge of finding all the group members of a set of groups containing more than five hundred groups. While the Powershell script was very effective, I needed one more tool in order to really make quick work of it all; Notepad++.

  • Powershell: A script to find all members of several groups refined

    One of the scripts that I use most often is the one I wrote about back in September of 2019. Usually, I only run it for up to ten or so groups, so it’s not a big problem to simply swap out the group name, rince and repeat. Recently, however, I needed to run it […]

  • Powershell: Add user to multiple groups

    A while back, I had a user that had to be added to a large number (150+) of active directory groups. Rather than doing so manually, I spent a little time looking up how to automate it, and created a script to help me do it. Here’s how I constructed it:

  • Top 15 Excel shortcuts

    As I’ve described elsewhere, I use Excel a fair amount. To this end, keyboard shortcuts are very useful. Here are some I find to be very useful:

  • Powerpoint: Remove presentation notes

    As part of my job, my role as head of my union local, and as a board member in my shooting sports club, I give presentations on a relatively regular basis. Whenever I do so, I usually share my slides so that people can refer back to them later on. I do not, however, share […]

  • PowerShell: Troubleshoot network connectivity

    A while back, a customer contacted us because they were having problems connecting to Amazon WorkSpaces. This led me to dig into a PowerShell command which was new to me; Test-NetConnection. In its simplest form, the command simply checks your network connectivity:

  • Find WLAN password from the command line

    If I’ve been there once, I’ve been there a thousand times; I’ve connected to a wireless network with my computer, but want to connect with my phone, too. The only problem is that I don’t know what the WLAN password is. Luckily, you can find the password to networks you’ve connected to using the command […]

  • Excel: Allow dividing formulas to fail gracefully

    I’m sure I’m not alone in having had this happen: I was using Excel to make some quick calculations, and got #DIV/0!-errors for some rows because one of the fields I’d been dividing by was empty. Sometimes you don’t have all the information you need for every single row, but you still want to have […]

  • Paste text without formatting

    I recently had a long term collaboration with a number of colleagues, where part of what we did was produce, edit, and agree upon finalized versions of text. We applied various formatting such as color, cursive, and bold to track the status of specific text blocks. At the end of it all, we needed to […]

  • Excel: Format cells based on content

    As a union steward, one of the many things I do on a regular basis is evaluate key indicators of the company financials. I do this by plotting a few numbers from the accounting reports into Excel, and then run them through some standardised analysis to identify the performance of key indicators. These indicators are […]

  • Excel: Automatically set width and height

    If I’ve been there once, I’ve been there a thousand times; I’ve got a spreadsheet in excel with varying widths and heights that don’t fit the data. Now, sure, you could go in and correct it manually – but that’s not only boring, it’s a pain it the behind. Luckily, there are keyboard shortcuts to […]