Microsoft Courses:
Microsoft Office Excel 2007 Level 1 Training Course

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.

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.

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.

Topics covered on the 2 day Microsoft Office Excel 2007 Level 1 course

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

Appendix A: Microsoft Office Specialist: Excel 2007

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk