Microsoft® Office Excel® 2007: Level 1

Course Specifications

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.

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

Course Content

Lesson 1: 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

Lesson 2: Performing Calculations

Create Basic Formulas

Calculate with Functions

Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

Manipulate Data

Insert and Delete Cells, Columns, and Rows

Search for Data in a Worksheet

Spell Check a Worksheet

Lesson 4: 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

Lesson 5: Printing Workbook Contents

Print Workbook Contents Using Default Print Options

Set Print Options

Set Page Breaks

Lesson 6: Managing Large Workbooks

Format Worksheet Tabs

Manage Worksheets in a Workbook

Manage the View of Large Worksheets