New Horizons Computer Learning Center
410-597-9722

Excel 2007 - Level 1

Course Length: 1 Day

Overview:
In this course, students will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks.

Prerequisites:
Windows XP - Level 1
Windows XP - Level 2
Or equivalent knowledge

Course 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 Content

• 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

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com