• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Melissa P Esquibel

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.

{ 0 comments }

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.

{ 0 comments }

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.

{ 0 comments }

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.

{ 0 comments }

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.

{ 0 comments }

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!

{ 2 comments }

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

{ 0 comments }

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

{ 0 comments }

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! [...]

{ 0 comments }

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

{ 0 comments }

Page 20 of 22« First...10192021...Last »