• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

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 4 of 14« First...34510...Last »
I got this question in a SharePoint class this week: How can I take the email addresses out of an email with a huge “To:” line and create a list for SharePoint? Well, here’s how to do it. 1. Create a blank worksheet in Excel, then switch to the Outlook email with the addresses you [...]
If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, [...]
Are you planning a big meeting with lots of moving pieces: Catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data from Outlook to do that? Well here’s how you can. In a meeting where you were the meeting organizer, in the Show group on the Meeting tab, [...]
Want to set up your own desktop theme in Windows 7? If you’ve changed your desktop theme in Windows 7 to one of the available Aero Themes, you might notice that the picture used for your desktop background changes every so often. What you might not know is that you can control how often those [...]
I recently heard a train-the-trainer presenter refer to all animations and transitions as unnecessary fluff and distractions. While I agree that animation beyond basic slide transitions can be distracting, I do think there is a place for well-placed advanced features in your PowerPoint. Here are my basic guidelines: Have a purpose for the pizazz – [...]
You’ve plugged in the values for a PMT (payment) function to determine how much the payment will be only to find that the payment is a bit too much for your budget. You could keep plugging in numbers until you get the right answer, find out the exact answer in a couple of clicks with [...]
Microsoft hit it out of the park with Quick Steps in Outlook 2010. On the Home tab, in the Quick Steps group, you’ll find several out-of-the-box Quick Steps. Reply and Delete will help you tame unwieldy email threads by choosing to reply and then delete the e-mail to which you are responding. By default, it [...]
Are you using SharePoint 2007 or 2010 as a glorified file server? There are many opportunities to make SharePoint do some heavy lifting beyond just keeping your files organized. One such opportunity is the actual creation of a complex document like a procedures manual. Using a template called a Document Workspace in SharePoint. The basic [...]
Some people ask why I keep teaching these applications? “Don’t I get bored?” Not with great questions like these! One of the following questions I had solved awhile back for my own use. The other two started out as “I don’t know, let’s see…” An attendee at a webinar recently asked, “Can I show Sum, [...]
I want to right align part of a line. For example, in a resume the company name might be flush with the left margin, but the dates of employment should be flush with the right. How do I do that? Make sure your ruler is turned on. On the View tab, in the Show group, [...]
Page 4 of 14« First...34510...Last »