Phone: (303) 682-1460
Send E-Mail to: theofficewiz@prodigy.net

Training/Software Services
Office Administration and Organization
Legal Secretarial Services
Desktop Publishing
Policies/Fees
Client Testimonials
Home
Click here to see the qualifications of
The Office Wiz

COURSE DESCRIPTION FOR
PERSONALIZE YOUR BUSINESS COMMUNICATIONS AND REPORTS USING MICROSOFT OFFICE

DESCRIPTION

This is the ideal class for any self-employed or business professional who wants to reduce office costs and increase productivity. Discover the powerful information sharing capabilities of Microsoft Office. This class is instructor-led with plenty of hands-on activities. You can also bring your own files to experiment with. Learn to:

  • Create mailing labels in Word using data from Excel.
  • Design your company's graphical envelopes for a cost-effective office solution.
  • Use a graphic theme in your Office documents.
  • Design personalized business cards in Word.
  • Analyze and chart Access data with Excel.

LENGTH

One four hour session.

PREREQUISITES

You should be familiar with the software packages included in Microsoft Office (specifically Excel, Word, PowerPoint and Access). You must also have a good understanding of basic Microsoft Windows, file management and personal computers.

SPECIFIC CLASS CONTENT

Lab Activity 1: Whip up some mailing labels with Excel data
Begin with a spreadsheet
Create the main document
Open the data source
Add merge fields to the main document
Merge the data
Print the labels

Lab Activity 2: Create custom envelopes with Word
Create a graphic
Add the graphic to an envelope
Save the envelope as a template
Enter the delivery address

Lab Activity 3: Create a graphic theme for Office documents
Save a slide as a graphic
Use a graphic in Excel as a chart background
Use a graphic in Word as a page border

Lab Activity 4: Design business cards with Word
Prepare the graphic
Create the text box
Enter and format the text
Combine the elements
Use Word's Label feature to set up the card document
Print the cards

Lab Activity 5: Build an Excel chart to show off your Access data
Choose your file
Use Access' Analyze It With MS Excel feature
Use Excel's AutoFilter and Chart features

NECESSARY SOFTWARE AND HARDWARE

  • An IBM or compatible equipped with Office 97 (or higher).
  • A printer (optional). However, you must have an installed printer driver to use Print Preview.

OTHER MICROSOFT OFFICE CLASSES

  • Mini Power Sessions:
    --Boost Your Communication Skills Using Microsoft Office
    --Take Advantage Of Templates In MS Office 2000


page updated January 2006