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