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, […]
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?
Get your questions answered from our Microsoft Certified Trainer Melissa P. Esquibel. Here are some of her answers on how to navigate Outlook 2010:
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, […]
Q. Can you animate SmartArt in PowerPoint?
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 […]
Q. How do you create a project folder and then make tasks under that folder?
Q. How can I work with multiple time zones in Outlook?
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 […]
Q. I used to use a button called Select Visible Cells in Excel 2003. I can’t find it anywhere in Excel 2007. Help!