Melissa P Esquibel

Q. This SUMIFs formula keeps getting an error that says, “The formula you typed contains an error.” Here’s what I wrote: -SUMIF(C2:C278,>1000). What is causing the error?

{ 2 comments }

Get your questions answered from our Microsoft Certified Trainer Melissa P. Esquibel. Here are some of her answers on how to navigate Outlook 2010:

{ 6 comments }

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, […]

{ 0 comments }

Q. Can you animate SmartArt in PowerPoint?

{ 0 comments }

If you design diagrams with layered objects, especially with animation, it can be a bit frustrating to keep things stacked the way you like as you make changes and add movement. Here are a couple of tips to keep your sanity with layered objects. The Selection Pane Reveal the selection pane by clicking on the […]

{ 0 comments }

Q. How do you create a project folder and then make tasks under that folder?

{ 0 comments }

Q. How can I work with multiple time zones in Outlook?

{ 0 comments }

Just about everything you need with regard to changing your view in Outlook can be found on the View tab in Outlook 2010. Here’s a little tour through the View ribbon. Current View In this group you’ll find 3 handy buttons. Have you assembled a view that met a specific need, but now just want to […]

{ 0 comments }

Q. I used to use a button called Select Visible Cells in Excel 2003. I can’t find it anywhere in Excel 2007. Help!

{ 2 comments }

Q. What are some of the differences between Office 2007 and Office 2010? We’re thinking of upgrading, but don’t know what the benefit would really be.

{ 2 comments }