The Office Tech Pro

Those are the breaks! Or not! Removing breaks from documents

Did you just inherit a mess of a document with hard breaks all over the place? Did you know that you can just do aMicrosoft Word find/replace to get rid of them? Try this!

Charting Data from Multiple Worksheets or Workbooks

This can be a sticky wicket if you’ve ever inherited a workbook that has charts linking data from several locations. Until you know how its put together, you either don’t change anything, or change one thing and watch all of it fall apart...

Party Favor with PowerPoint

If you have a treasure trove of photos from the office or work site with which you’d like to create slideshow for your holiday gathering, it’s easy to do in PowerPoint.

Problem Step Recorder

Did you just do the most amazing thing on your computer, but sure you’ll never remember it again? Try the Problem Step Recorder (PSR) in Windows 7.

Automate Worksheet Views

If you have a workbook that everyone views a little bit differently, you can automate it, so that everyone just has to click their own button. Even if you are the only one who uses it, but you use it differently for different purposes, this solution would work, too.

3 Cool Things about SharePoint in Office 365 Enterprise Editions

If you’ve recently implemented or are thinking about implementing SharePoint in your new Office 365 environment here are a few things that I think are definite improvements.

3 Habits to Get Into for a Clean Outlook Machine

Say Yes to Archive! When the Archive prompt comes up, just say Yes! You probably don’t realize it, but when Outlook archives an email, it just goes to a separate file structure which is still accessible from the Navigation Pane. This process keeps your Inbox and regular folders clean, neat and current, while still allowing you to easily access your older ones.

The Zip Code Conundrum

In Excel, when you have a 0-first digit zip code, it usually shows up as only the last four digits. So, take a Massachusetts zip code like 02201. If you just type that into an Excel cell it comes up 2201. You could type an apostrophe in front of it, but then it would appear left justified like all other text. There are several alternatives.

Beyond Filtering: Advanced Filter Techniques

Here is the problem … You are trying to filter using multiple AND and OR criteria in Microsoft Excel or one or more columns in your list have more than 10,000 unique items (think employee numbers, serial numbers, transactions).

Dramatic Slide Backgrounds

Did you ever see a slide whose background was a photo that took up the whole slide? Perhaps it was washed out like a background with bullet points in the forefront. Or, maybe the photo was the main message and was accompanied by just a few words. It looks slick, but it’s really easy.