One of the most useful situations for linking Office files is when you want an up-to-date Excel file to appear when a user opens a Word file.
Open the file with the source, such as an Excel spreadsheet, select the data you want to include and click the copy button.
Open the destination file, such as the report you're creating in Word, and place your cursor where you want the data to appear. From the Edit menu, select Paste Special, then Paste Link.
As long as both files remain on the same computer system, changes in the Excel file automatically will appear in the Word document.
In newer versions of Word, when you type some kinds of data—names, dates, addresses, etc.—a faint dotted line appears below the information. Pass your cursor over top and the "smart tag action button," a small "i" inside a circle, appears.
Left-click on that button to activate actions you usually would open other applications to accomplish.
If a name exists in your Contacts, you can automatically insert the person's address.
With an address, you can click to display a map or get driving directions.
Click on the tag for a date to see your Outlook calendar or schedule a meeting.
If the information you want exists somewhere else in Office, look for a way to access it directly.
In Microsoft Outlook: Beyond E-mail to E-fficiency, you'll learn how to:
- Organize files using colors, categories, alerts, e-mails and flags
- Reduce typing with drag-and-drop techniques
- Create notes so your workflow won’t be interrupted
- Transfer those notes among contacts, e-mails and your calendar
- Sort your mail within Outlook
- Get the most out of your calendars
- Set up the Tickler System, Project Tracking System and Work Distribution System to help keep you on track
- And much more!
- 10 Secrets to an Effective Performance Review
- Tip Card: Business Management Daily's Favorite Keyboard Shortcuts
- Asking for a Raise: 10 Tips for Making Your Pitch
- Obesity discrimination is common — and against the law
- Passing the 'duties test': new exemption definitions
- The Dirty Dozen: Manager mistakes that spark lawsuits