Excel 2007 Level 1

Prerequisites:

To effectively understand this course, we recommend that you take a Microsoft Office Windows XP Introduction course or have equivalent knowledge.

Course Description:

This course is designed for people preparing for certification as a Microsoft Office 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.

This course includes the following modules:

Exploring the Excel Environment

• Explore the User Interface
• Explore the Ribbon
• Obtain Help
• Customise the Quick Access Toolbar

Working with an Excel Worksheet

• Navigate in Excel
• Select and Enter Data
• Save a Workbook

Modifying a Worksheet

• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create a Mixed Reference

Formatting a Worksheet

• Convert Text to Columns
• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Align Cell Contents
• Find and Replace Formats
• Apply AutoFormat
• Apply Cell Styles
• Apply Themes

Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheet
• Copy and Paste Worksheets

Printing Workbook Contents

• Set Print Titles
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Set Page Breaks
• Print a Range

Customising Layout

• Split a Worksheet
• Arrange Windows
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets