• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+
The Office Tech Pro

The Office Tech Pro

A Microsoft® Certified Trainer, Melissa Esquibel combines her 25+ years experience in information technology with a background in training, technical writing and business risk analysis. Her goal: To take you from “No, how?” to “Know how!”

Page 2 of 912345...Last »
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

by on December 17, 2014 10:50am
in The Office Tech Pro

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

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.

Melissa Esquibel points out some common Excel blunders.

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.

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!

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

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.

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.

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

Especially effective for videos you create from your PowerPoint presentations, rolling titles are easy to add with a little bit of know-how.
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.
With Headers/Footers you get easy Page Numbers. With your document in Print Layout view (default), double click at the top of the page to access the header. Do the same at the bottom of the page to access the footer.
If you’ve ever worked for hours on a workbook one day, then destroyed it with a few poorly planned changes the next, you’ll appreciate these tips on how to protect your work with cell locking, worksheet and workbook protection.
Page 2 of 912345...Last »