How to export contacts from Outlook 2003, 2007 and Outlook Express
Posted on June 6, 2008 - Filed Under MS Office Tips | 88 Comments
Want to learn how to export contacts from Outlook? I work at an office where there are three versions of Office installed on employee computers: Office 2007, Office 2003, and Office 2000! And when people switch computers, I usually end up having to export their email and their contacts to a different computer, which has a different version of Office installed.
And if you create multiple contact folders in Outlook, then you have to export each one of those individually. I’ll show you how to export contacts in these different versions of Outlook.
Microsoft Word: AutoText and AutoCorrect
Posted on June 5, 2008 - Filed Under MS Office Tips | 5 Comments
AutoText and AutoCorrect are features that can save you lots of time and lots of frustration – if you go to the trouble of learning how to use them. There’s no better time than now to get started. Let’s take a quick look at some of the more endearing features of both, with the hope that you’ll take up the reins and try some additional tricks with these features.
AutoText is a great time saver when documents require boilerplate text (disclaimers, general liability language, etc.). Copying and pasting is inefficient, and it may find you copying and pasting names or other data that you meant to leave out.
Metadata: Microsoft’s Underworld
Posted on June 1, 2008 - Filed Under MS Office Tips | 2 Comments
Many users of Microsoft Word have heard talk about something called metadata, a mysterious compilation of data that reveals previous versions of a document, who worked on the document throughout its history and the various dates when the article was edited. Some treat these rumors with about as much credibility as others regard UFO’s. A brief look will help explain what it is and how to eliminate it.
Revealed at Last: Keyboard Shortcut Secrets from MS Word
Posted on May 12, 2008 - Filed Under MS Office Tips | 5 Comments
Keyboard secrets. Students used to trade them in college like a more sophisticated version of baseball cards. Microsoft Word has long been suspected of keeping an immense log of shortcut keys, written in longhand and available only to Bill Gates. This legend is slowly losing its cachet, however – it’s time to reveal at least a teaser on those fabled secret shortcut keys.
Link to specific slides in other PowerPoint presentations
Posted on May 7, 2008 - Filed Under MS Office Tips | 3 Comments
Have you ever wanted to link your power point presentation to another one? What if you could link it to a specific slide in the other presentation? What if you could link it to a Word or Excel document as well (and specify exactly which part of the document you want to open)? Well, it can be done – and I’m here to tell you how.
To start with, you will need to have your power point presentation as well as the other file that you want to link to. In this example, we will be linking two power point presentations together and jumping immediately to Slide 2 on the second presentation.
Master Excel Tables with AutoFilter and Subtotal
Posted on April 9, 2008 - Filed Under MS Office Tips | 3 Comments
How much of Microsoft Excel are you using? I thought so. Get ready because we’re stepping it up another notch. Excel is a powerful but often underutilized tool. Many of us use it every day to plan and track budgets, analyze marketing data, and occasionally to do more important things such as manage the office March Madness pool. Several Online Tech Tips posts have already covered clever but unfamiliar functions like VLOOKUP and SUMIF. Now it’s time for another round of Outrageous Excel Tips!
