Microsoft Excel 2000 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Excel 2000 Level 1 or equivalent experience. |
| Course Materials: | Course manual (074201S3 - Excel 2000: Charting And Organizing Data) |
| 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. |
Creating charts
Creating a chart sheet
Creating an embedded chart
Comparing chart sheets with embedded charts
Modifying charts
Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items
Formatting a chart
Formatting chart text
Formatting labels
Formatting the chart
Printing a chart sheet
Using graphic objects
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts
Sorting data
Single-level sorting
Multiple-level sorting
Sorting options
Design considerations
Filtering data
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list