Excel Flash Fill on names

I’m sitting in a training session today, and I saw the trainer do something in Excel that I didn’t know was possible… Flash Fill can complete columns of names based on other columns. Here’s how…

Inserting multiple blank lines in an Excel spreadsheet

This is a really simple tip that I wish I had known about sooner, instead of copy and pasting blank rows for an Excel spreadsheet. Instead of just inserting a single blank row, you can easily insert multiple blank rows by highlighting the number of rows you need. Here’s how…

Transferring your Skype phone calls to another phone

If you’re a person who gets a number of phone calls on your work number, you may want or need to have those calls transferred to another number for some period of time. Maybe you have an errand to run outside the office, and you want the number to go to your cell phone. Or maybe you’re out of the office for an extended period of time, and you want someone else to field your calls. Here’s how you can make that happen in your Skype settings…

Using the Search function in OneDrive

One of the advantage of having your personal files in OneDrive is that you have the capabilities of the Office 365 search engine when it comes to finding data. You’re not just restricted to searching for file names, either. The search indexes the content of the files, and gives you a powerful search experience. Here’s how you can use it to find your data quickly…

Updating your Skype presence based on what you’re actually doing

Sandra shared a cool tip with me today. You know how when you have a meeting on your Outlook calendar and it ends early, your Skype presence indicator shows that you’re still in the meeting until it actually ends on the calendar? There’s a setting in Skype that allows the presence indicator to actually show based on what you’re doing, not just on what your calendar *says* you’re scheduled to be doing. Here’s how you set and/or change it…

Running a PowerPoint presentation in Kiosk Mode

Let’s say you’re running a booth at a conference, and you’d like a PowerPoint slide show to run continuously and automatically. Or… perhaps you’re giving a presentation, and you want a “pre-show” slide deck to run continuously while everyone is coming in and finding their seats. You can do this by running a PowerPoint file in Kiosk Mode. Here’s how that works…