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… Continue reading Excel: Allow dividing formulas to fail gracefully

Use browser profiles for more efficient operations

One of the complicating factors of my job is that I need to use the same tools, with different user credentials, often at the same time. For example, most of the companies I and my colleagues support use services that have some sort of integration with Microsoft Azure. As a result, I need to log… Continue reading Use browser profiles for more efficient operations

Hide recipients in Outlook meeting bookings

Like so many of you, I arrange a fair number of meetings for various purposes. Among these are the ones I arrange for the members of my union local in my capacity as its head. Now, EU – and thus also Norwegian – data protection law clearly categorizes union membership as one of the numerous… Continue reading Hide recipients in Outlook meeting bookings

Free text search in ADUC

A critical component to successfully closing a lot of the tickets I handle at work is the ability to search for – and find – Active Directory User, Computer, and Group objects. In about eight of ten instances, I’m able to do so using the standard search types (searching for Users, Contacts, and Groups or… Continue reading Free text search in ADUC

A further metric for support

I have previously written about key metrics for support departments – and I stand by everything I said then. I have, however, come to the conclusion that another metric should be placed under consideration. A quick recap, however, of the metrics I proposed then, as well as what they are intended to measure:

Longer answers are better support

When working tech support, it is often tempting to give short answers to a ticket, in order to get on to the next ticket. This tendency is particularly problematic when responding in the negative to a request. Though understandable, we should fight this tendency. I have three specific reasons why it’s important, but I would… Continue reading Longer answers are better support

Microsoft Teams: Dial tone when calling in to meeting

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… Continue reading Microsoft Teams: Dial tone when calling in to meeting

Outlook: Mark deleted messages as read

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: