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 14 of 16« First...10...131415...Last »
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.
If you have attended any of our recent webinars on Microsoft Office applications, you have probably heard me tout the value of using keyboard shortcuts as time savers and accuracy boosters. Another side benefit to navigating around your applications without scrolling is avoiding hand, wrist and elbow injuries which may result from repetitive strenuous motion, like excessive use of your mouse. Here are 3 great tips to save your body and mind while working in Excel.
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!
I get asked a lot if it still pays to hone your skills on Office 2003, with 2007 out now for 3 years and 2010 on the horizon. While the installed base of Office 2007 is going up all the time, there are still many organizations on previous versions. What I want to know from […]
My writing usually focuses on technical tips and tricks. But in all honesty, the best tip I can offer is to get trained. Most of us are self-taught in the office software products we use. Unless you are the type to read all your manuals thoroughly before touching the mouse or keyboard, it’s safe to […]
Excel error messages aren’t always terribly clear to us. We know we have a problem, but we don’t know where to go to start fixing it! In this and next week’s article we’ll examine 6 common errors in Excel and how they show up, including 2 error messages that may not be errors at all! […]
We’ve taken that old, ugly PowerPoint presentation and whipped into shape with respect to content and consistency. The layouts all look good. And, we’ve chosen an appropriate background and color set. We’re almost happy with the finished product except for a few font choices and the need for some additional slide layouts. We would also […]
There are three types of messages Excel gives us that aren’t technically error messages, but they are notifying us that something MIGHT be wrong. In this second half of my Excel Error Messages training, we’ll explore #N/A, FALSE and circular cell references. #N/A#N/A actually means no answer. The most common place you’ll see an #N/A […]
PowerPoint  makeover: Working with design and layouts for version 2003In recent weeks, we’ve explored the best way to transform an old, ugly presentation into an effective PowerPoint presentation. with a Word outline, and how to overcome one of the hurdles of using the method: one bullet per slide. This week we’ll take our plainly laid-out […]
Page 14 of 16« First...10...131415...Last »