A quick example of how to use the SUMIF function in Microsoft Excel.
[More]
Sometimes if you're using OneDrive for Business, you can get two quick links in your explorer window - one is named "OneDrive" and the other is "OneDrive - Business" or something similar. They will both take you to your OneDrive library, so the duplicate can be removed.
[More]
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]
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]
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]
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]
So you're an Office 365 administrator and you've granted yourself, or someone else, "Full Access Permissions" to another user's mailbox — either in Exchange Management Console or in Exchange Admin Center in the Office 365 Portal. You did this because you needed to access the user's mailbox to receive something or work on an issue.
[More]