203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Excel 2007, Introduction

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.

Audience

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
  • Windows 2000/XP, 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.

Course Contents
  • Creating a Basic Worksheet
    • Explore the User Interface and the Ribbon
    • Navigate and Select in Excel
    • Obtain Help
    • Enter Data and Save a Workbook
    • Customize the Quick Access Toolbar
  • Performing Calculations
    • Create Basic Formulas
    • Calculate with Functions
    • Copy Formulas and Functions
  • Modifying a Worksheet
    • Manipulate Data
    • Insert and Delete Cells, Columns, and Rows
    • Search for Data in a Worksheet
    • Spell Check a Worksheet
  • Formatting a Worksheet
    • Modify Fonts
    • Add Borders and Color to Cells
    • Change Column Width and Row Height
    • Apply Number Formats
    • Position Cell Contents
    • Apply Cell Styles
  • Printing Workbook Contents
    • Print Workbook Contents Using Default Print Options
    • Set Print Options
    • Set Page Breaks
  • Managing Large Workbooks
    • Format Worksheet Tabs
    • Manage Worksheets in a Workbook
    • Manage the View of Large Worksheets

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule