I find it extremely frustrating when someone books an hour for a meeting by default, but yet they only have about 10 minutes of material they need to cover. Instead of playing havoc with your (and others) calendar, you can set your default meeting length to something shorter. Here’s how…
Working with the Excel Fill Handle
One of the cool things about working with Excel is the ability to click on the Fill Handle in the lower right corner of a cell, and then drag it to auto-fill values based on what’s in the original cell. However, it can be frustrating to figure out whether it’s going to copy the value or auto-fill based on the next value in the sequence. Here’s a brief overview on how you can get it to copy or fill based on what you need, regardless of what Excel wants to do for you automagically…
Filtering Outlook email via Ribbon Bar options
Unless you’re a search ninja, you’re likely to only type in a search term in the Outlook search bar, and hope for the best. However, there are a number of other options you can use that are found in the Ribbon Bar. Here’s where to find them…
Making quick video recordings in OneNote
Let’s say you want to create a quick video of yourself, either to let your team know something, or perhaps just as a reminder to yourself to take care of some items. OneNote has a basic video recording function built in, and it’s perfect for those basic types of videos (not screen captures… just whatever your vidcam is picking up). Here’s how it works…
Outlook’s reminder when you forget your email attachment
Admit it… we’ve all done it. We craft a wonderful email that tells the recipient(s) to look at the enclosed or attached file, and then we send it… without the attachment. Outlook can help you avoid that email faux pas in a number of cases, and here’s how you do it…
Sending an Outlook email with CTRL + ENTER keyboard shortcut
I know a number of my readers are keyboard wizards, and they would prefer do most/all functions using keyboard shortcuts rather than the mouse. I just learned this shortcut today… sending an Outlook email using the CTRL + ENTER shortcut…
Spellcheck just got better in Word and Outlook
So today I was typing up something in Outlook, and I (like normal) misspelled a word. I right-clicked on the word with the red squiggly line, and got a lot more information than I expected…
Adding an In Folder column to your Outlook Inbox
A colleague passed along a cool tip on how to easily see what folder an email is in, especially when you’re doing a search. Here’s how you add an In Folder column to your Inbox in Outlook…
Generating random numbers in Excel
On Twitter this weekend, I found a cool link on how to generate random numbers in Excel. Considering I normally use a random number generator site to do this, I thought it was a pretty cool tip.