Microsoft Excel 2007: Introduction for Beginners (2 day)

Course Overview

This course is designed for people who wish to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets and maybe preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 or above.

Audience

For users new to Excel 2007, this course provides the ideal introduction.

Skills Gained

Upon successful completion of this course, students will be able to:

• explore the Excel 2007 environment.
• work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet.
• modify a worksheet.
• perform calculations.
• format a worksheet.
• develop a workbook.
• print workbook contents.
• customize the layout of the Excel application window.

Prerequisites

It is recommended that you take the Microsoft Office Windows XP Introduction course or have equivalent knowledge. This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.

Course Outline

Exploring the Excel Environment

• Explore the User Interface
• Explore the Ribbon
• Obtain Help
• Customize 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 Worksheets
• 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

Customizing Layout

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

Microsoft Excel 2007: Introduction for Beginners (2 day) / MEX07-22