Microsoft Excel 2000 Level 1
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual (074200S3 - Excel 2000: Worksheets) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will learn to create and work with basic worksheets, create formulas by using Excel’s built-in functions, move and copy data, format a worksheet, work with multiple worksheets, and more. |
Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Entering data and navigating in a worksheet
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Modifying a workbook
Working with ranges
Working with functions
Editing cell contents
Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions
Creating Excel Web pages
Using Excel as a Web tool