MS Word 2007

Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word 2007 courses. It will provide you with the basic concepts required to produce basic business documents.
.
Upon completion of this course, students will be able to:

• Create a basic document by using Microsoft Word.
• Edit documents by locating and modifying text.
• Format text.
• Format paragraphs.
• Control a document's page setup and its overall appearance.
• Save the document for the future retrieval

Prerequisites:

• Students should be familiar with using personal computers and have used a mouse and keyboard.
• You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
• Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

.Course Outline

Creating a Basic Document

• Explore the User Interface
• Open and View a Document
• Customize the Word Environment
• Obtain Help
• Enter Text
• Save a Document
• Preview and Print a Document

Editing a Document

• Navigate and Select Text in a Document
• Insert, Delete, or Rearrange Text
• Undo Changes
• Search and Replace Text

Formatting Text

• Change Font Appearance
• Highlight Text

Formatting Paragraphs

• Set Tabs to Align Text
• Control Paragraph Layout
• Add Borders and Shading

MS PowerPoint 2007

In today's work environment, presentations have moved far beyond flip charts and overhead projectors. Audiences not only expect that your presentations are in an electronic format, but they also demand that your presentations be unique and sophisticated in their use of such formats. In this course, you will work with Microsoft® Office PowerPoint® 2007 to create electronic presentations.

Upon completion of this course, students will be able to:

• Get started with PowerPoint.
• Create a presentation.
• Format text on slides.
• Add graphical objects to a presentation.

Prerequisites:

• To ensure your success, we recommend you first take the Introduction to MS Office 2007 course.

Course Outline

Getting Started with PowerPoint

• Explore the User Interface
• Navigate and View a Presentation
• Use Microsoft PowerPoint Help
• Enter Text
• Save a Presentation

Creating a Presentation

• Create a Presentation
• Edit Text
• Add Slides to a Presentation
• Arrange Slides
• Work with Themes

Formatting Text on Slides

• Apply Character Formats
• Apply Paragraph Formats
• Format Text Placeholders

Adding Graphical Objects to a Presentation

• Insert Clip Art and Pictures
• Draw Shapes
• Insert WordArt

MS Excel 2007

This course is designed for people preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Objective:

Students will create, edit, format and print basic worksheets in Excel

Upon completion of this course, students will be able to:

• Explore the Excel 2007 environment.
• Work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet.
• Modify a worksheet.
• Perform calculations.

Prerequisites:

• To effectively understand this course, we recommend that you take any Microsoft Office course.

Course Outline

Exploring the Excel Environment

• Explore the User Interface
• Explore the Ribbon
• Obtain Help
• Customize the Quick Access Toolbar

Working with an Excel Worksheet

• Navigate in Excel
• Select and Enter Data
• Save a Workbook

Modifying a Worksheet

• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet

Performing Calculations

• Create Basic Formulas
• Calculate with Functions