Do you ever get merged cells errors? While merged cells can give your table and worksheet titles a nice appearance, they can cause problems with calculations if they appear within your tables and ranges. There is an alternative that will give you the same look, but without the complications of merged cells. Just as you [...]
Did you ever want to send emails to a group of contacts, but wanted them all to receive individually addressed emails, rather than being part of a distribution group or a huge list of addressees? Well, you can, by doing a Mail Merge in Outlook. Most people associate Mail Merge with Word. And while you [...]
Do you know how a good pair of shoes always feel better after you’ve worn them for awhile. They feel better because they’ve adjusted to your feet. When things are adjusted to the way you work, you just work better! And, so it is with your Microsoft Office applications. In Word there are a few [...]
Stop counting on your fingers and toes to do date math! Use these Excel tips to calculate past due dates, follow-up dates and other tedious time calculations.
Capture phrases, paragraphs or objects to use over and over in Word and Outlook.
Starting in Outlook 2007, Microsoft has re-invented categories to include color and the application of that color across the various types of Outlook items. How can you use them?
In PowerPoint ® 2010, we now have the ability to generate a Windows Media Video (.wmv) file. These instructions assume you have completed the first 4 steps. Write your script using Microsoft Word. Outline your presentation (topics and bullets) Import into PowerPoint and attach to a Theme Import graphic elements or create them with SmartArt [...]
If your organization does not use SharePoint, which enables sharing of files and file libraries, instruct anyone who wishes to share your templates to open them from a network drive.
Ctrl + ` (Hint: Look for the tilde “~” symbol) This keyboard shortcut reveals all the formulas on a worksheet. Changing cells before you know what they do is always risky. If after you reveal all your formulas, you then format those cells with a certain highlight color, when you turn the reveal feature off [...]
When there are many cooks in the kitchen on a document, it’s best to track and control what changes are made and by whom. Microsoft Word 2007 offers the tools you’ll need for this on the Save as dialog box and the Review tab. Here are just a few suggestions for controlling and tracking what [...]