Outlook Calendar Attendance Tracking

I learned a really cool little trick today entirely by accident. When I send out a meeting invite to a large group of people, I get a lot of a responses which I usually just delete. However, today I double-clicked and opened up one of the responses (instead of just viewing it in the Reading Pane).

Cleaning spaces and line feeds in Excel

A while back, a colleague pinged me and asked if there was a way to remove line feeds from an Excel spreadsheet. I didn’t know of a good way to do it, but I came up with a hack-ish solution using Find and Replace.  Unfortunately, I didn’t know about the Trim and Clean functions at the time.

Saving all the images in a PowerPoint presentation

Let’s say that you have a PowerPoint PPTX file which has a number of images that you’d like to repurpose for some other reason. Maybe you want them for another presentation, or you want to include them in a SharePoint site or Word document. You could go to each page, right-click on the image, and save it locally… over and over and over.

OR…

You could use this technique to find all the images in one place, and then copy/paste the ones you want to use.

Blocking Junk Mail in Outlook

Into each Inbox some Junk Mail must fall… and we get to play Whack-A-Mole to try and get rid of it. Here are a couple of options for getting junk mail out of your inbox and into your Junk Email folder…

The Properties Pane is back in Office ProPlus

When we first started upgrading to Office ProPlus (aka Office 2016), we were excited and happy… until someone noticed that the Properties Pane for things like Word, Excel, and PowerPoint documents was no longer visible. Needless to say, this made some of our customers “not very happy”.

Somewhere along the way, Microsoft fixed that problem in the Office clients, and now you can once again see and access the properties. Here’s how you do it…

Using AutoText in Word Quick Parts

When you’re in Word, you often have to use certain blocks of text in many different documents. Instead of typing the same content over and over (or using copy and paste from something like Notepad), check out the Quick Parts AutoText feature instead…