Excel 2000: Worksheets
Course specifications
Course number: 074 200
Software version number: 2000
Course length: 1 day
Hardware/software required to run this
course
You will need 32 megabytes (MB) of Random
Access Memory (RAM) in order to run Excel. You will need a
minimum of 500 MB of hard-disk space available for Office 2000
after Windows 98 is installed. A Pentium 90 or higher processor
is needed. A typical installation of Windows 98 and a full-suite
installation of Microsoft Office 2000 is needed. In addition, you
will need printers if you want to print the worksheets created in
the course. At a minimum, you will need to install a printer
driver. This book has been developed using the Windows 98
platform; however, this course has been tested and runs on
Windows 95, Windows 98, and Windows NT 4.0.
Course description
Overview: Students will learn basic
worksheets skills and how to work with data in worksheets.
Prerequisites: Windows 98:
Introduction, or equivalent knowledge.
Delivery method: Instructor-led,
group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to use
an electronic spreadsheet to create basic data reports.
Target student: Students enrolling in
this course should understand how to use Windows 98.
What's next: Excel 2000: Worksheets is
the first course in this series. Excel 2000: Charting and
Organizing Data, the next course in this series, teaches
students how to use the charting and list management capabilities
in Excel. Students who want to learn advanced features can take Excel
2000: Advanced.
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.
- Save an Excel workbook as a Web page.
Course content
Lesson 1: Excel basics
- The paper spreadsheet
- The Excel program
- The workbook environment
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
Lesson 8: Creating Excel Web pages
Using Excel as a Web tool
