Excel 2002 (XP) - Intermediate
Platform: PC
Description
Microsoft® Excel 2002, the spreadsheet module of Office XP, makes it easy to create powerful spreadsheets. This intermediate skills series will take you many steps beyond the basics.
Click any of the highlighted titles to view free sample tutorial movies. Atomic Learning subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
| Key # | Length | |||
|---|---|---|---|---|
| 1. |  |
Working with zoom | 3452 | 1:05 |
| 2. | |
Using Full Screen mode | 3453 | 0:52 |
| 3. | |
Splitting a worksheet window into panes | 3454 | 1:29 |
| 4. | |
Freezing and unfreezing panes | 3455 | 1:11 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Selecting worksheets | 3456 | 1:38 |
| 2. | |
Renaming worksheets | 3457 | 0:33 |
| 3. | |
Coloring Worksheet tabs | 3458 | 1:01 |
| 4. | |
Inserting a worksheet | 3459 | 0:28 |
| 5. | |
Removing a worksheet | 3460 | 0:28 |
| 6. | |
Changing the order of worksheets | 3461 | 0:41 |
| 7. | |
Grouping worksheets for one-step changes | 3462 | 1:17 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Creating a 3-D formula | 3463 | 2:16 |
| 2. | |
Using 3-D ranges | 3464 | 1:37 |
| 3. | |
Dragging 3-D formulas | 3465 | 0:53 |
| 4. | |
Assigning a name to a cell | 3466 | 0:56 |
| 5. | |
Jumping to a cell using the Name box | 3467 | 0:34 |
| 6. | |
Using range names in formulas | 3468 | 1:22 |
| 7. | |
Creating range names | 3469 | 2:23 |
| 8. | |
Replacing cell addresses to range names | 3470 | 1:30 |
| 9. | |
Deleting range names | 3471 | 1:32 |
| 10. | |
Creating a 3-D formula using range names | 3472 | 1:12 |
| 11. | |
Creating a 3-D range name | 3473 | 1:33 |
| 12. | |
Using 3-D range names in formulas | 3474 | 1:07 |
| 13. | |
Creating an IF function | 3475 | 2:54 |
| 14. | |
Creating a DATE function | 3476 | 2:26 |
| 15. | |
Formatting a date | 3477 | 1:02 |
| 16. | |
Editing a function | 3478 | 0:38 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Sorting lists | 3479 | 2:21 |
| 2. | |
Using Find and Replace | 3480 | 1:03 |
| 3. | |
Running AutoFilter | 3481 | 1:18 |
| 4. | |
Changing formatting with Find and Replace | 3482 | 1:13 |
| 5. | |
Creating a Custom AutoFilter | 3483 | 1:05 |
| 6. | |
Disabling AutoFilter | 3484 | 0:22 |
| 7. | |
Using the Excel Search Task Pane | 3485 | 1:39 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Inserting a draw object in a worksheet | 3486 | 1:19 |
| 2. | |
Drawing a line in a worksheet | 3487 | 0:41 |
| 3. | |
Formatting a line | 3488 | 1:12 |
| 4. | |
Drawing an arrow | 3489 | 1:01 |
| 5. | |
Selecting filled and unfilled objects | 3490 | 0:40 |
| 6. | |
Moving and resizing an object | 3491 | 0:22 |
| 7. | |
Adding text to an object | 3492 | 1:16 |
| 8. | |
Resizing an object | 3493 | 0:40 |
| 9. | |
Changing an object's fill color | 3494 | 0:55 |
| 10. | |
Changing an object's text color | 3495 | 0:50 |
| 11. | |
Deleting an object | 3496 | 0:28 |
| 12. | |
Adding 3-D effects to an object | 3497 | 0:48 |
| 13. | |
Using 3-D options | 3498 | 1:17 |
| 14. | |
Adding a shadow to an object | 3499 | 0:54 |
| 15. | |
Drawing a text box | 3500 | 0:40 |
| 16. | |
Inserting a picture | 3501 | 1:47 |
| 17. | |
Formatting a picture or graphic | 3502 | 1:16 |
| 18. | |
Inserting a diagram | 3503 | 0:41 |
| 19. | |
Using Diagram Layout options | 3504 | 1:18 |
Generate Direct Linking HTMLBrowse Training
Find an Answer to a Tech Question