Course Decriptions

Microsoft® Office Excel® 2007: Level 1 (Second Edition)
Software: Microsoft® Office Excel® 2007
Course length: 1.0 day(s)

Course Description: You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel® 2007 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.

Target Student: This course is designed for people preparing for certification as a Microsoft Certified Application 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.

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. Students should have completed the following courses or possess equivalent knowledge before starting with this course:

• Windows XP Professional: Level 1
• Windows XP Professional: Level 2
• Windows XP: Introduction
• Windows 2000: Introduction

Performance-Based Objectives: Upon successful completion of this course, students will be able to:

• Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet
• Perform calculations
• Modify a worksheet
• Format a worksheet
• Print workbook contents
• Manage large workbooks

Microsoft® Office Excel® 2007: Level 2 (Second Edition)
Software: Microsoft® Office Excel® 2007
Course length: 1.0 day(s)

Course Description: In Microsoft® Office Excel® 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites: Before starting this course, students are recommended to take the following Element K course or possess equivalent knowledge: Microsoft Office Excel 2007: Level 1.

Performance-Based Objectives: Upon successful completion of this course, students will be able to:

• calculate with advanced formulas
• organize worksheet and table data using various techniques
• create and modify charts
• analyze data using PivotTables and PivotCharts
• insert graphic objects
• customize and enhance workbooks and the Microsoft® Office Excel® environment.

Microsoft® Office Excel® 2007: Level 3 (Second Edition)
Software: Microsoft® Office Excel® 2007
Course length: 1.0 day(s)

Course Description: This course is the first in a series of three Microsoft® Office Outlook® 2007 courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Office Outlook® 2007, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes. In this course, you will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.

Course Objective: You will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.

Target Student: This course is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft® Office Outlook® 2007 to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. In addition, this course helps prepare students who desire to take the Microsoft Certified Applications Specialist certification for Outlook.

Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. 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. The following courses are recommended, or you should have equivalent knowledge of:

• Windows XP Professional: Level 1
• Windows XP Professional: Level 2
• Windows XP: Introduction
• Windows 2000: Introduction

Performance-Based Objectives:Upon successful completion of this course, students will be able to:

• identify the components of the Outlook environment. You will also perform simple tasks such as sending and responding to email messages
• compose messages
• use folders to organize messages
• manage contacts and contact information
• schedule appointments
• schedule meetings
• create and edit tasks

Microsoft® Office PowerPoint® 2007: Level 1 (Second Edition)
Software: Microsoft® Office PowerPoint 2007

Course Description: 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.

Course Objective: You will explore the PowerPoint environment and create a new presentation. You will format text on slides to enhance clarity. In order to enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft® Office PowerPoint® 2007. This course is also intended for students interested in pursuing Microsoft Office Specialist certification in Microsoft® Office PowerPoint® 2007.

Prerequisites: To ensure your success, we recommend you first take one of the following Element K courses or have equivalent knowledge:

• Windows XP: Introduction
• Windows XP Professional: Level 1
• Windows XP Professional: Level 2
• Windows 2000: Introduction

Performance-Based Objectives: Upon successful 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
• modify objects on slides
• add tables to a presentation
• add charts to a presentation
• prepare to deliver a presentation.

Microsoft® Office PowerPoint® 2007: Level 2 (Second Edition)
Software: Microsoft® Office PowerPoint 2007

Course Description: As a PowerPoint 2007 user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication.

Course Objective: You will enhance your presentation with features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use the new and enhanced features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity.

Target Student: This course is designed for students who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. This course also assists in the preparation for the Microsoft Office Specialist exam in Microsoft® Office PowerPoint® 2007. It is for students who already have knowledge of the basics of Microsoft® PowerPoint® 2007, including slide formatting and working with tables, charts, images, objects, and presentation preparation.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:

• Windows XP: Introduction
• Windows 2000: Introduction
• Microsoft® Office PowerPoint® 2007: Level 1

Performance-Based Objectives: Upon successful completion of this course, students will be able to:

• customize the PowerPoint environment
• customize a design template
• add diagrams to your presentation
• add special effects to a PowerPoint presentation
• use the various options to customize slide shows
• use PowerPoint to collaborate on a presentation
• finalize a presentation.

< < < View Previous Class Descriptions