This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to build, edit, and format worksheets, and how to work with charts, formulas, and functions. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long after course completion. Related Exam: MOUS Excel 2000 Expert.

• Create, edit, preview, print, save and close an Excel workbook
• Edit, copy and move cell entries, and work with ranges
• Copy formulas with relative and absolute cell references
• Format values and labels, and apply colors, patterns, and borders
• Insert and delete rows and colums
• Design, create, modify, and enhance charts
• Create formulas, and display and print formula contents
• Build formulas that include the IF functions, the PMT function, and statistical functions

Getting Started with Excel 2000

• Defining Spreadsheet Software
• Starting Excel 2000
• Viewing the Excel Window
• Opening and Saving an Existing Workbook
• Entering Labels and Values
• Previewing and Printing a Worksheet
• Closing a Workbook and Exiting Excel

Building and Editing Worksheets

• Planning and Designing a Worksheet
• Editing Cell Entries and Working with Ranges
• Entering Formulas
• Copying and Moving Cell Entries
• Understanding Relative and Absolute Cell References
• Copying Formulas with Relative Cell References
• Copying Formulas with Absolute Cell References
• Naming and Moving a Sheet

Formatting a Worksheet

• Formatting Values
• Using Fonts and Font Sizes
• Changing Attributes and Alignment of Labels
• Adjusting Column Widths
• Inserting and Deleting Rows and Columns
• Applying Colors, Patterns, and Borders
• Using Conditional Formatting

Working with Charts

• Planning and Designing a Chart
• Creating a Chart
• Moving and Resizing a Chart
• Editing a Chart
• Formatting a Chart
• Enhancing a Chart
• Annotating and Drawing on a Chart
• Previewing and Printing a Chart

Working with Formulas and Functions

• Creating a Formula with Several Operators
• Using Names in a Formula
• Generating Multiple Totals with AutoSum
• Using Dates in Calculations
• Building a Conditional Formula with the IF Function
• Using Statistical Functions
• Calculating Payments with the PMT Function
• Displaying and Printing Formula Contents

Designed to cover basic Excel skills.

5 hours

IBM-compatible PC with 166 MHz or higher processor, 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95, Windows 98, Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.