Microsoft Excel 2003: Level 1

Revision: TE1313_20060318

Course Length:

1 Day

Course Description:

In this course, students will use Microsoft® Office Excel 2003 to manage, edit, and print data. This is one of a series of courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Who Should Attend:

This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.

Benefits of Attendance:

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

• Create a basic worksheet.
• Modify a worksheet.
• Perform calculations.
• Format a worksheet.
• Develop a workbook.
• Print the contents of a workbook.
• Customize the layout of the Excel window.

Prerequisites:

Students should first take Microsoft Office Windows XP: Introduction or have equivalent knowledge. If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Course Outline:

• Chapter 1: Getting Started With Excel
  1. An Overview of Excel
  2. Navigating in Excel
  3. Selecting Data
  4. Entering Data
  5. Saving a Workbook
  6. Obtaining Help
• Chapter 2: Modifying A Worksheet
  1. Moving and Copying Data Between Cells
  2. Filling Cells with Series of Data
  3. Editing Cell Data
  4. Inserting and Deleting Cells, Columns, and Rows
  5. Finding, Replacing, and Going To Cell Data
  6. Spell Checking a Worksheet
• Chapter 3: Performing Calculations
  1. Creating Basic Formulas
  2. Calculating with Functions
  3. Copying Formulas and Functions
  4. Creating an Absolute Reference
• Chapter 4: Formatting A Worksheet
  1. Changing Font Size and Type
  2. Adding Borders and Color to Cells
  3. Changing Column Width and Row Height
  4. Merging Cells
  5. Applying Number Formats
  6. Creating a Custom Number Format
  7. Aligning Cell Contents
  8. Finding and Replacing Formats
  9. Applying an AutoFormat
  10. Applying Styles
• Chapter 5: Developing A Workbook
  1. Formatting Worksheet Tabs
  2. Repositioning Worksheets in a Workbook
  3. Inserting and Deleting Worksheets
  4. Copying and Pasting Worksheets
  5. Copying a Workbook
• Chapter 6: Printing Workbook Contents
  1. Setting a Print Title
  2. Creating a Header and a Footer
  3. Setting Page Margins
  4. Changing Page Orientation
  5. Inserting and Removing Page Breaks
  6. Printing a Range
• Chapter 7: Customizing Layout
  1. Splitting a Worksheet
  2. Arranging Worksheets
  3. Freezing and Unfreezing Rows and Columns
  4. Hiding and Unhiding Worksheets
• Appendix A: Microsoft Office Specialist Program