You’ve plugged in the values for a PMT (payment) function to determine how much the payment will be only to find that the payment is a bit too much for your budget. You could keep plugging in numbers until you get the right answer, find out the exact answer in a couple of clicks with [...]
Microsoft hit it out of the park with Quick Steps in Outlook 2010. On the Home tab, in the Quick Steps group, you’ll find several out-of-the-box Quick Steps. Reply and Delete will help you tame unwieldy email threads by choosing to reply and then delete the e-mail to which you are responding. By default, it [...]
Are you using SharePoint 2007 or 2010 as a glorified file server? There are many opportunities to make SharePoint do some heavy lifting beyond just keeping your files organized. One such opportunity is the actual creation of a complex document like a procedures manual. Using a template called a Document Workspace in SharePoint. The basic [...]
Q. Can I do a more complex search in Outlook than just a few keywords or sorting by columns?
Q. Why don’t tasks automatically set reminders?
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?