Learning new Microsoft Office tricks in "just a minute"
When going through my list of reading material from Twitter, I found a link to an article by Rob Woodgate titled What are Notes in Outlook and How Do You Use Them? I didn’t know that was buried in Outlook, and it’s a pretty cool way to keep “sticky notes” in Outlook for easy reference. Here’s how it works…
When you have an Excel, Word, or PowerPoint file open that has been shared in SharePoint Online or OneDrive, there’s an easy way to see when and who updated the file using the Version History icon in the Ribbon Bar. You can also easily see the actual file in earlier versions. Here’s how…
Unlike Word, Excel does not have a Watermark feature that you can select from a menu. However, there is a way to get a watermark effect in Excel, and it’s ideal for spreadsheets that have confidential information. Here’s how you do that…
I heard about the Move to OneDrive feature a while back, and I’ve been waiting for it to show up in my Office 365 tenant… and now it’s there! When you have the OneDrive sync client installed, are using Windows File Explorer, and right-click on a file, you have an option to *move* it to OneDrive without having to drag and drop. Here’s how that works…
OK… I have been looking forward to this feature rolling out for a VERY long time! I apparently have the latest updates to my Outlook client now, as this morning I saw the Insights add-on icon in the Ribbon Bar. To me, this is one of the most valuable uses of machine learning in Office 365 to help you stay on top of your Inbox and Calendar. Here’s what I saw this morning on my first visit to Insights…
I recently had a question from someone asking if there was a way to take a column of names in Excel that were in all upper-case and convert them to proper case. In Word, it’s just a menu option, but that feature doesn’t exist in Excel. However, you can get there with an Excel formula. Here’s how…
I’m used to sorting columns in Excel, as that’s one of the main things you do. But I never really thought about sorting content in a Word document, as it (in my mind) is just unformatted “stuff.” But, you *can* sort a list of content in Word, and it’s pretty slick. Here’s how…
This probably doesn’t bother anyone else like it bothers me… If I have a message in my Inbox that’s unread and I delete it (or if I have a rule that routes certain messages directly to the Deleted Items folder), it still shows as unread in my Deleted Items folder. And since I have my folders set to show the number of unread messages, I always have a number next to the Deleted Items folder that’s completely meaningless to me… and it annoys me. Yes, I’m old, so get off my lawn…
This tip shows you how to have any message (read or unread) that’s moved to the Deleted Items folder to be marked as read…
If you’re old like me, words like “policeman” and “fireman” just want to roll off your tongue, as that’s what you grew up with. But today’s communication often requires a more gender-inclusive word selection like “police officer” or “fire fighter.” Microsoft Word has an option that will allow you to do grammar checks for that very scenario. Here’s how to activate that…
One Minute Office Magic 