Excel 2007 - Level 1

You Will Learn To

Manage, edit, and print data using Microsoft Excel 2007.

Who Should Attend

New Excel users and experienced but self-taught Excel users will both benefit from this course.  Basic Windows skills are required.

Course Content

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