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]