The Office Tech Pro

Four Things a Nightmare Excel Workbook Taught Me

If you’ve ever inherited a workbook that has been passed down from several individuals without a lot of Excel knowledge who had a very definite idea of what they wanted, but not how to get it in the best way possible, learning opportunities abound. Here are the biggest lessons that came out of a real whopper …

Taming SharePoint Document Management

One of the hardest things to do is to get people to put things in the right places. Even when you had “sub-sub-sub-sub” folders on your network drive, people still put things in the wrong spots. With the Content Organizer feature activated in your Document Center site, all they will ever have to do is upload their documents into a Drop-off library. SharePoint does all the routing based on content type and other parameters you set up. Here is how it works.

Bullets in Tables

I had a great question on the Office Technology Today Answer Center free subscriber webinar. How do you manage bullet points in tables? Well, the answer wasn’t terribly easy, but it is doable.

4 Rumors About Windows 8/8.1 (and why they are untrue!)

Windows 8 boots up within 10 seconds and shuts down just as fast. All of my applications run just fine on it and much,much faster than they used to. To shut it down, click the power button in the upper right corner of your Start screen. Like shortcuts? Windows key, U, U works well. Plus, you can work with it exactly how you worked with Windows 7. Really! Read on …

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...