Here are a couple of tricks in Office 2003 to increase your productivity right now!
Link data between two files in Office:
If you want data from an Excel spreadsheet to appear and automatically update in your Word document, start by opening both documents. In the Excel document
(source document), copy the data you want to show in Word. In the Word document (destination document), place the insertion point where you want the linked
data to appear. Choose Edit, Paste Special. Select Paste link, then select the desired format from the As list to the right. Click
OK. Now when you update the data in that Excel spreadsheet, it will automatically update in your linked Word document!
Colorize your email messages: If you want email messages from
your boss, clients or coworkers to stand out in your Inbox, you can set a rule to automatically apply a color to them. Click once on a message from the
desired person, then click the Organize icon (or select Tools menu / Organize). When the Ways to Organize Inbox pane opens at
the top, click on Using Colors at the left side of the pane. Select your parameters - for example, Color messages from Sharon Root in Blue … then
click on Apply Color. Voila, all the messages you receive from me will show up in blue so you can find them quickly and easily. You have your choice of
16 colors, including some that can be used to de-emphasize (like gray), as well as emphasize (like red) certain messages.
New! Excel VBA Level 2 class
We've added a new Level 2 course for those who have taken
our Excel VBA Level 1 class. Both classes are taught by our world-class Excel expert Shane
Devenshire, who loves sharing his exceptional knowledge of Excel with you. Excel VBA Level 1 is on May 9 & 16. The new Level 2 class is on June 9 & 10.
Student Testimonials
“Maria was very complete and concise. A pleasure to learn from.”
“Great teacher, easy to follow, explained things well.”
“Proceeded at a pace that kept everyone engaged.”
“Spent time on breaks assisting with unique problems.”
“Wonderful training! Very clear & informative.”
“We have worked with Project on several different occasions; there were always gaps. Rebekah is a fantastic instructor and was able to fill in all of the missing pieces.”
We offer a wide range of services to improve your productivity:
- Public Enrollment Classes
- Corporate Group Classes
- Personal Tutoring and Executive Coaching
- Consulting & Design Services (macros, templates,
databases, project management, presentations, web design, graphics)
- Technical Programming Services
Let us empower you and your employees to improve your
productivity with individual or group training at great prices! Please call us at (408) 261-2600 or email sharon@computermagictraining.com. Be sure to visit
us at www.computermagictraining.com for more information & on-line registration!
|