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 […]
I get asked this one a lot! How do I highlight an entire row when a particular cell contains a certain value? For example, if the total sales for the year are under $2,000, highlight the row in red. The secret is to use a formula to determine which cells to format. In fact, that […]
What happened to colors in Outlook 2007 and Outlook 2010? If you’re confused about color, you’re not alone. If you went from 2003 to 2007 and 2010, you know they seem to keep moving the simple tools you used to use to color code emails and other Outlook items. Colors are a great tool to […]