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
