Click here to jump to the top of the page
 
Elert & Associates Training Division
Click here to register for or join a virtual class
E&A Home Page   About E&A   Contact Us
Click here to go to the Training Division's home page. Click here to go to the Training Division's home page.
Click here to learn more about our Instructor-Led Training. Click here to learn more about our Instructor-Led Training.
Click here to view our course catalog. Click here to view our course catalog.
Access
Excel
Integrating Microsoft Office
PowerPoint
Word
Project
Outlook
Click here to learn more about our 90 Minute Workouts Click here to learn more about our 90 Minute Workouts
Click here to learn more about the many different delivery options we offer. Click here to learn more about the many different delivery options we offer.
Click here to learn about the many different services we offer. Click here to learn about the many different services we offer.
Click here to learn more about our virtual classroom. Click here to learn more about our virtual classroom.
Click here to learn more about our courseware. Click here to learn more about our courseware.

Microsoft Office XP

All of the courses in this curriculum are 90 Minute Workouts®. Click a course title below for more information. (Note: Office 97, 2000, 2003, and 2007 courses are also available.)

Shared New Features
Word, Excel, & PowerPoint New Features
Drawing, Clip Art, & Word Art
Charting in Word & PowerPoint
Integrating Word, Excel, & PowerPoint
Organization Charts & Diagrams
Reviewing & Collaborating Electronically
Tips & Shortcuts
 
Note: These courses focus on features common to the three primary Microsoft Office applications (Word, Excel, and PowerPoint) and on integrating these applications. For courses specific to each application, see our Word, Excel, and PowerPoint curricula.
 

Office XP Shared New Features

Objective:
Learn common features new to the Office XP applications (Word, Excel, and PowerPoint 2002).

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable and familiar with Office 97 or 2000 applications.

Course Description:
Are you upgrading from Office 97 or 2000 to Office XP? Do you need to learn which features are new and enhanced in Word 2002, Excel 2002, and PowerPoint 2002? This class focuses on the new features that are common throughout Office XP, helping you remain productive and efficient as you get accustomed to the new versions of these familiar applications.

Attend this course if you want to:

  • Understand the new Task Panes in Office applications.
  • Customize the menus and toolbars for the way you work.
  • Identify and use Smart Tag buttons (e.g., the Paste Options button, AutoCorrect Options button, and Smart Tag Actions button).
  • Resize the Open and Save As dialog boxes.
  • Customize the Places Bar in the Open and Save As dialog boxes to include the locations you access most.
  • Insert organization charts and business diagrams in your documents, worksheets, and presentations.
  • Use the new Document Recovery feature to recover work after a crash.
  • Learn about Office XP's speech and handwriting recognition tools.
  • Access help through the Ask a Question box.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Word, Excel, & PowerPoint New Features

Objective:
Learn application-specific new features of Word 2002, Excel 2002, and PowerPoint 2002.

Prerequisite Skills:
  • Comfortable and familiar with the 97 or 2000 versions of Word, Excel, and PowerPoint.

  • Comfortable with new features common throughout Office XP.
    (Suggested Course: Office XP Shared New Features)

Course Description:
Are you upgrading from Office 97 or 2000 to Office XP? Do you have a general understanding of the new features common throughout Office XP (such as Task Panes and Smart Tags), but you now need to learn which features are new and improved in each specific application? This class focuses on the application-specific new features in Word, Excel, and PowerPoint 2002.

Attend this course if you want to:

  • Use Word's Styles and Formatting Task Pane to view, apply, and modify styles in a document.
  • Identify and use other Word-specific Task Panes (i.e., the Reveal Formatting, Mail Merge, and Translate Task Panes).
  • Understand the Drawing Canvas that displays each time you insert a line, shape, or text box in Word 2002.
  • Create text or graphic watermarks for your documents.
  • Format the numbers or bullets in a list differently from the text that follows each number or bullet.
  • Select non-contiguous document text.
  • Use the expanded capabilities of Excel's AutoSum button.
  • Use ScreenTips to define function arguments in Excel.
  • Change the color of worksheet tabs.
  • Use the Watch Window to monitor the status or content of specific cells.
  • Retain formatting as you copy and paste data in Excel.
  • Use the Smart Tag Actions button to find stock quotes and company information.
  • Use the PowerPoint-specific Task Panes to select a slide layout, color scheme, or template and to apply various animation options.
  • Apply a built-in animation scheme to quickly animate the text and objects on your slides.
  • Apply custom animation to your slides.
  • Use Print Preview to help determine how you want to set up your presentation, handouts, and notes.
  • Use the grid to help you draw objects and to align slide elements in precise positions.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Drawing, Clip Art, & WordArt

Objective:
Learn to enhance Office XP files using drawing objects, clip art, and WordArt.

Prerequisite Skills:

Course Description:
Do you want to enhance your Word documents, Excel spreadsheets, or PowerPoint presentations? Do you want to add various shapes to your documents? Do you want to customize the standard clip art? Do you want to add special effects to your text?

Attend this course if you want to:

  • Draw lines, boxes, arrows and various other shapes.
  • Work with the Drawing Canvas in Word.
  • Resize, reshape, or rotate your drawings.
  • Move, copy, or align drawing objects.
  • Easily duplicate a drawing (e.g., a series of arrows).
  • Change the color and style of a drawing object (and of the border surrounding the object).
  • Create shadow and 3-D effects.
  • Add text to drawing objects.
  • Add clip art images to your documents, spreadsheets, or presentations.
  • Resize, move, or rotate clip art objects.
  • Recolor or crop clip art to better meet your needs.
  • Use the grid to draw and position objects precisely in Word and PowerPoint.
  • Enhance your text with WordArt.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - public (Attend Office 2003 class) - Check schedule and/or register

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Charting in Word & PowerPoint

Objective:
Learn to create and modify charts in Word and PowerPoint using Microsoft Graph.

Prerequisite Skills:

Course Description:
Do you want to add a chart to your Word document or PowerPoint presentation (without having to do it in Excel)? Do you want to make your documents and presentations look more professional?

Attend this course if you want to:

  • Communicate your ideas via a chart.
  • Select from several chart types.
  • Understand charting terminology.
  • Work with the chart and datasheet windows.
  • Enter data and make changes to the data.
  • Format your chart.
  • Add or modify a legend.
  • Add or hide gridlines.
  • Create your own chart templates.
  • Create charts from a Word table.
  • Import data or charts from Excel.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Integrating Word, Excel, & PowerPoint

Objective:
Learn to maximize Office XP's capabilities by converting, embedding, linking, and hyperlinking files in Word, Excel, and PowerPoint.

Prerequisite Skills:

Course Description:
Do you ever want to insert an Excel chart into a Word document or PowerPoint presentation? Do you want the chart to automatically update when changes are made to the Excel data? Have you ever wanted to add a graphic created in PowerPoint into your Word document?

Attend this course if you want to:

  • Understand the different ways to integrate Office applications (e.g., copying and pasting, embedding, linking, and hyperlinking).
  • Copy Excel data into Word or PowerPoint.
  • Copy information into Excel.
  • Embed a new Excel worksheet into a Word document.
  • Embed an existing file (or a portion of a file) into Word, Excel, or PowerPoint.
  • Edit, resize, or move an embedded object.
  • Create a link from one application or file to another (and choose whether the linked information should update automatically when the original information is modified).
  • Import a Word outline into a PowerPoint presentation.
  • Send a PowerPoint presentation to a Word document.
  • Create hyperlinks to other locations, files, or Web pages.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - public (Attend Office 2003 class) - Check schedule and/or register

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Organization Charts & Diagrams

Objective:
Learn how to create organization charts and concept diagrams to enhance your business documents, worksheets, and presentations.

Prerequisite Skills:

Course Description:
Do you need a way to visually represent the structure of an organization, division, group, or project? Are you trying to convey a concept or idea that might best be depicted in a diagram? You can use Office XP's organization chart and diagram tools to create professional-looking organization charts and business diagrams to enhance the look of your documents and facilitate your audience's comprehension of the document or presentation content.

Attend this course if you want to:

  • Create an organization chart in a Word document, Excel worksheet, or PowerPoint presentation.
  • Add text to organization chart boxes.
  • Understand the levels in an organization chart.
  • Select and format boxes, text, and connector lines.
  • Add, remove, and rearrange the boxes in an organization chart.
  • Change the layout of the organization chart.
  • Use the style gallery to format an organization chart quickly.
  • Understand the available business diagram types.
  • Insert a diagram in a Word document, Excel worksheet, or PowerPoint presentation.
  • Add, remove, and rearrange shapes in the diagram.
  • Format the elements of the diagram.
  • Change a diagram to another diagram type.
  • Use the style gallery to format a diagram quickly.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Reviewing & Collaborating Electronically

Objective:
Learn to use Office XP reviewing tools to effectively collaborate on and review Word documents, Excel spreadsheets, and PowerPoint presentations with other team members.

Prerequisite Skills:

Course Description:
Have you created a document, spreadsheet, or presentation that you want others to review? Do you want to allow others to provide suggestions or make changes to your file without losing your original version?

Attend this course if you want to:

  • Understand the review cycle for Office XP files.
  • Use Outlook to route a document, spreadsheet, or presentation for review.
  • Route files without using Outlook.
  • Control the types of changes others can make to your Word documents.
  • Receive a file for review.
  • Highlight text or data in a document or spreadsheet.
  • Add comments to a document, spreadsheet, or presentation.
  • Return the reviewed file to the author.
  • Reconcile changes made by each reviewer.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - public (Attend Office 2003 class) - Check schedule and/or register

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)


Office XP Tips & Shortcuts

Objective:
Learn tips and shortcuts to enable more efficient use of Office XP applications (Word, Excel, and PowerPoint 2002).

Prerequisite Skills:

Course Description:
Are you using Word, Excel, and PowerPoint as efficiently as possible? Would you like to customize some of the features of these applications to better suit the way you work? Would you like to learn some tips that can help you save time when working with documents, worksheets, and presentations?

Attend this course if you want to:

  • Customize the Places Bar on the left side of the Open and Save As dialog boxes.
  • Print, cut, copy, rename, and delete files directly from the Open dialog box.
  • Open, save, and close multiple files simultaneously.
  • Use the Search Task Pane to search for files that meet certain criteria.
  • Set options to change the way the Clipboard behaves.
  • Customize a toolbar or menu to better meet your needs.
  • Create a new toolbar or menu containing the options you choose.
  • Make a toolbar button menu "float" on your screen so you can quickly access it again.
  • Use the Format Painter to copy formatting from one text selection to another.
  • Use the "New from Existing" option to create a new file based on an existing one.
  • Understand the various Smart Tag buttons available in Office applications.

Class Length: 90 minutes

Delivery Options:

  • On-site instructor-led (contact us for details)

  • Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

  • Virtual classroom - one on one (register for a 1-on-1 Application Support session)