The Office Tech Pro: Tips, Shortcuts and Time-Savers

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!"
A little perplexed by the new Pivot Table interface in 2007? Here are some tips to cope with the change.
Blue and underlined not what you want for your hyperlinks? Here are a few tips and tricks for including hyperlinks that look the way you want them to.
Use the best features of Access on your Excel workbooks and vice versa by using Microsoft Office interoperability features.
The Show/Hide button can say a lot about you as a Microsoft Word expert!
A forum reader reports a problem with Excel. The workbook window appears to be missing, though Excel indicates the file is open.
How to use Microsoft Outlook as a project management tool
What search engine should I use? Here's an introduction to the three most popular engines in the world. Google, Yahoo and Bing.
Vertical look-ups or the VLookUp function in Excel has eluded many formula writers. See how a VLookUp works exactly the same way your brain does when you have to look something up.
You got results you didn't expect, don't understand what you're supposed to click on next, want to do what you just did, but in way less time! A compass for intermediate and advanced Microsoft Office users.
Scrolling and mousing can not only be huge time-wasters, but if overused, can really injure you. Try these handy Excel keystroke shortcuts to save time, improve accuracy and reduce the possibility of injury!
Are you on Office 2007?
Are you self-taught? If so, then you're probably missing out on valuable, time-saving skills that are easy to acquire. Choose to learn more about the software you use everyday.
Sometimes it's hard to figure out what Excel is trying to tell you when it has an error. It's even harder when the error message doesn't know it's an error. We will look at three messages that look like errors that may not be and how to resolve them. #N/A, FALSE and circular cell reference warnings.
Error messages let you know something is wrong. BUT WHAT?! This article addresses 3 common Excel error messages, what they can mean and how to fix the problem.
The last installment of PowerPoint makeovers. This article guides you into the Slide Master to make changes that can be instantly populated throughout your presentation.
Attention 2003 PowerPoint Users! Last week we covered slide design and layout elements in 2007. This week, it's all about PowerPoint 2003. Learn how to take a presentaiton created from a Word outline, choose layouts and design for a polished and professional look.
Once you import a Word outline into applying appropriate slide layouts and the right design is the next order of business. This article addresses making these changes in Office 2007.
Sometimes importing Word outlines into PowerPoint doesn't yield the results we want. Being careful about the formatting techniques you use on the Word side of the equation will be your secret to success!
Have you ever “inherited” a PowerPoint presentation that was done by someone who wasn’t necessarily PowerPoint savvy? Here is a 3 step process for taking it and making it your own without retyping content or fighting with bad design and format choices.
Did you ever feel like you needed more help after getting help in Microsoft Office? There are tips and tricks to getting the right help fast, so you can get back to work.