Course Objective

You will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks.

Target student

This course is designed for people who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Prerequisites

Windows Introduction or equivalent knowledge.

Course Outline:

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