Excel 2003: Worksheets

Course specifications
Course number: 074 220
Software version number: 2003
Course length: 1 day

Hardware/software required to run this course

•	A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.
•	A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
•	128 MB of RAM.
•	A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
•	A 3 GB hard disk or larger if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
•	A floppy disk drive.
•	A mouse or other pointing device.
•	An 800 x 600 resolution monitor.
•	Network cards and cabling for local network access.
•	A printer (optional).
•	A projection system to display the instructor’s computer screen.
•	Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.
•	Microsoft Office Professional Enterprise Edition 2003.

Course description

Overview: Students will learn basic worksheets skills and how to work with data in worksheets.

Prerequisites: To ensure students’ success with this course, we recommend that they have a familiarity with Windows 2002 Professional or Windows XP Professional.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Excel 2003: Worksheets

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

*	Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
*	Create a basic worksheet by entering text, values, and formulas.
*	Create formulas by using Excel’s built-in functions.
*	Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
*	Change the appearance of worksheet data by using a variety of formatting techniques.
*	Prepare a document for printing by using the spell checking feature and a variety of printing options.
*	Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.

Excel 2003: Worksheets

Course content

Lesson 1: Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Task pane navigation

Lesson 2: Entering data and navigating in a worksheet
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques

Lesson 3: Modifying a workbook
Working with ranges
Working with functions
Editing cell contents

Lesson 4: Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature

Lesson 5: Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting

Lesson 6: Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options

Lesson 7: Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions

Appendix A: Using Excel as a Web tool
Using Excel as a Web tool

Appendix B: New Features in Excel 2003
New Features