Fix Outlook Multiple Windows

Outlook is a terrific email/calendar/contact application - there are many others out there, but personally I haven't found one I like better (yet!). However, once in a while I have multiple windows open in Outlook - for example I'll have one window for my Inbox open, another for my Calendar and even sometimes one for my Contacts. Sometimes these windows get "stuck" and even though you close them all, when you re-open Outlook the next day, all the windows open instead of just one. Fortunately, there is an easy fix for this issue... [More]

Excel Checking List from Another List

This is similar to my last blog post where I explained how to filter a list in Excel based on another list. This time, the task is more straightforward - we just want to identify if an item in one list is present in another list. I find I use this technique quite often when using Excel (especially during data migrations). [More]

Excel Filtering a List Based on Another List

I've been doing some data migration recently for a customer and I've run into a few situations where I have a big list of Customer ID numbers (plus the other associated fields like Name, Address, Email, Phone, etc) and I have a smaller list of Customer ID number that I'm interested in. Using Advanced Filtering in Excel, I can get to just the records I'm interested in. [More]

Fixing Office 365 Ribbon Toolbars

After a recent update to Microsoft Office 365, I was surprised to see the Office Toolbar/Ribbon behave weirdly when I tried to pin it. Previously, when I pinned it, it would just stay on the screen in the format it was in. However, after the update, pinning the Toolbar resulted in it completely changing - and it became bigger and (in my opinion) less useful. It turns out the issue is related to some Touch settings in Office! [More]