Prerequisite skills: Basic familiarity with a computer mouse, keyboard, and
the Windows 7/XP operating system.

After completing this class, you should know how to:

• Create, save, locate, and open Word documents
• Navigate through and edit Word documents using the new Microsoft Fluent user interface
• Select text and change font sizes and styles
• Preview and print documents
• Use the spelling and grammar checker
• Use the AutoCorrect features

By the end of this course, you should be able to:

• Create a Pivot Table
• Change a Pivot Table's calculation
• Sort and Filter within a Pivot Table
• Adjust Pivot Table Field List layouts
• Group Pivot Table items
• Update and Format a Pivot Table
• Create a Pivot Chart

By the end of this course, you should be able to:

• Insert clip art and shape objects
• Browse the clip art gallery
• Create unique graphics by modifying clip art elements
• Apply and modify Shape Styles and Effects
• Use the Lasso technique to select objects
• Move, group and align objects
• Adjust an object's order and rotation
• Assign entrance, emphasis, and exit effects to objects
• Animate objects with motion paths

By the end of this course, you should be able to:

• Develop multiple slide masters
• Save a custom presentation theme
• Effectively use transitions
• Animate bulleted lists and charts
• Add and modify SmartArt
• Insert hyperlinks as graphics and as text
• Incorporate action buttons
• Create a non-linear presentation

By the end of this course, you should be able to:

• Create a Pivot Table
• Change a Pivot Table's calculation
• Sort and Filter within a Pivot Table
• Adjust Pivot Table Field List layouts
• Group Pivot Table items
• Update and Format a Pivot Table
• Create a Pivot Chart

Prerequisite skills: Basic familiarity with a computer mouse and keyboard.

After completing this class, participants should be able to:

• Navigate through the PowerPoint user interface
• Create, save, open, and close a presentation
• Insert new slides
• Enter and edit text
• Use the Slide Master
• Add clip art to a slide
• Format the slide background and design
• Print speaker notes and handouts
• View the slide show

After completing this class, you should be able to:

• Use relative and absolute references
• Apply sorting and filtering tools
• Use conditional formulas and other functions
• Apply defined names and formula auditing tools
• Apply hyperlinks
• Apply conditional formatting and cell styles