'How to' Microsoft Office 2003 | Tips for Microsoft Office Applications

Courses

Business Support Services

Office 2003 Tips

Help and How-to for Microsoft Office Word 2003

Answer Box: Print mailing labels in Word
Explore some of the trickier issues that can arise when you're creating labels.
Answer Box: Numbers don't merge right in Word
Your mail merge appears to be working just fine, but suddenly you notice that prices, dates and other numbers don't look right in your merged documents. Learn how to avoid this particularly costly problem.
Add or delete a page in Word
In Word, you can add pages when you need them or to remove any extras.
Word mail merge: A walk through the process
Take it one step at a time: The end-to-end story for mail merge in Word 2003.
Compare documents side by side
Not sure what changed? No revision marks anywhere? You can open up two versions and scroll through them together.

Help and How-to for Microsoft Office Excel 2003

Analyze data with PivotTable reports
After you have built a PivotTable report, you can rearrange it to view your data from alternative perspectives.
Analyze XML data in Excel
Merging and analyzing financial data can be a thorny task when data (such inventory data, tax data, and purchase orders) are maintained in different programs. Learn more about using Extensible Markup Language (XML) for putting structured data into a text file that other programs can read.
Creating custom functions
Although Microsoft Excel includes a multitude of built-in worksheet functions, chances are it doesn't have a function for every type of calculation you perform. Learn how you can create your own functions.
Let Excel be your calculator
Instead of reaching for your calculator, use Excel to do the math!
Raise a number to a power
Want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies? Learn how to raise a number to a power by using the "^" operator or the POWER function.

Help and How-to for Microsoft Office Access 2003

How Access converts between Access and SharePoint data types
Find out how the different Access and SharePoint data types interact when transferring data from one to the other.
Automate publishing a report snapshot to the Web
Snapshots are a convenient way to distribute Access reports via the Web. Learn how to automate the process by using a macro.
Demo: Share your data with your team
Watch this demo to see how Access can help you collaborate with the people in your group.
Demo: Create an Access database from an Excel workbook
Are you spending too much time on managing your data in Excel workbooks? Maybe it is time to import your data into an Access database.
Specify where you want scroll bars in a text box or other control
Exercise your option to place scroll bars where you need it on your forms or reports.

Get Microsoft PowerPoint 2003 Productivity Content with RSS on Office Online

Draw a flowchart
See how you can use AutoShapes to create and format a basic flowchart.
Twelve-month timeline
Chart the progress of your project with this twelve-month timeline graphic template.
Presentation for project post-mortem
Prepare to present the results of your project with this post-morten template.
Add music, songs, or sound effects to a slide show
Spice up your presentation by adding sounds. In this article, you'll learn how to insert songs or sound effects and how you can control when they play.
Employee orientation presentation
Begin your new employees' careers off well with this orientation slideshow template.

Help and How-to for Microsoft Office Outlook 2003

A program is trying to access e-mail addresses you have stored in Outlook
Are you getting prompted about a program accessing your e-mail addresses? Find out what this is all about and why Outlook is alerting you.
Demo: Automatically reply to messages while out of the office
If you use a Microsoft Exchange e-mail account, you can choose to have the Out of Office Assistant automatically notify people who send you an e-mail message that you are unavailable.
Create a custom contact field
You can add a custom field to your contacts to track about anything you can think of.
What are those symbols in my calendar display?
Wondering what those symbols are on your calendar? Here's the complete guide to each symbol.
Change the background color of your calendar
Ready for something different? Change the background color of your calendar.

Productivity content for Project 2003

Connect with other Project users
Tap the collective wisdom of other Project users on Facebook, Twitter, blogs, discussion groups, and more.
Understanding project management basics (book excerpt)
Review the basics before you begin managing your project. In this book excerpt, Teresa S. Stover leads you through an overview.
Find out if your project is on track using baselines
To track a project, you must have something to track against. The baseline plan contains the original estimates against which you can track your project's actual progress.
Save an interim plan
After you save a baseline plan and begin updating your schedule, you may want to save an interim plan periodically as a snapshot of your progress.
Create a milestone
A milestone is a reference point marking a major event in a project. Adding milestones in Project 2003 is a key skill that will help you as you manage your project.

Outlook Blog : Annik Stahl