The Office Tech Pro

Unclutter Your View with Categories

If you use Categories in Outlook to identify and classify priorities or the type of work you have to do, you can work in a much less cluttered view of your Inbox. After categorizing your new items, click on the column heading called Categories.

3 things NOT to do in Excel

Melissa Esquibel points out some common Excel blunders.

Annoying Visual Aids in Word (and why you might want them)

Markup from Track Changes First of all, know that whether or not you see editing markup tracked with Track Changes, it’s there. It may show up when exporting to other programs like Adobe. The only way to actually get rid of the markup is to acc...

Selection Pane Magic in PowerPoint

There’s a little-known tool in PowerPoint called the selection pane. From the Home tab in the Drawing group, locate the Arrange drop down button. Choose Selection Pane at the bottom of the list. The order in which the objects are listed is also the front to back order of the layers. The top most item is at the top of the “stack.” The little eye icons on the right of each layer will make it visible or hide it. This makes it much easier to work with multiple objects that are layered on top of each other and revealed by animation.

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.