Outlook: Problems opening and organizing calendars

On a relatively regular basis, I find my days packed with appointments, reminders, and meetings. At other times, I need to organize a meeting, or talk to a colleague, and need to check their availability. For these reasons, and others, I’m an active user of digital calendars. Anything that happens during the work day is… Continue reading Outlook: Problems opening and organizing calendars

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

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… Continue reading Excel: Automatically set width and height

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… Continue reading Calculating percentage change in Excel

Outlook: Mail merge

I have previously written about one of my many responsibilities; contacting users whose login credentials have shown up in breach lists. While the pertinent results of the breach files are delivered to me in a flat file, I use Excel’s Text to Columns feature to separate logins (usually email addresses) from the password. While this… Continue reading Outlook: Mail merge