Skip to content Skip to login

Excel 2002 (XP) - Intermediate Training View a tutorial on this topic

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.
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Working with zoom 3452 1:05
2. preview Using Full Screen mode 3453 0:52
3. preview Splitting a worksheet window into panes 3454 1:29
4. preview Freezing and unfreezing panes 3455 1:11
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Selecting worksheets 3456 1:38
2. locked Renaming worksheets 3457 0:33
3. locked Coloring Worksheet tabs 3458 1:01
4. locked Inserting a worksheet 3459 0:28
5. locked Removing a worksheet 3460 0:28
6. locked Changing the order of worksheets 3461 0:41
7. locked Grouping worksheets for one-step changes 3462 1:17
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D formula 3463 2:16
2. locked Using 3-D ranges 3464 1:37
3. locked Dragging 3-D formulas 3465 0:53
4. locked Assigning a name to a cell 3466 0:56
5. locked Jumping to a cell using the Name box 3467 0:34
6. locked Using range names in formulas 3468 1:22
7. locked Creating range names 3469 2:23
8. locked Replacing cell addresses to range names 3470 1:30
9. locked Deleting range names 3471 1:32
10. locked Creating a 3-D formula using range names 3472 1:12
11. locked Creating a 3-D range name 3473 1:33
12. locked Using 3-D range names in formulas 3474 1:07
13. locked Creating an IF function 3475 2:54
14. locked Creating a DATE function 3476 2:26
15. locked Formatting a date 3477 1:02
16. locked Editing a function 3478 0:38
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Sorting lists 3479 2:21
2. locked Using Find and Replace 3480 1:03
3. locked Running AutoFilter 3481 1:18
4. locked Changing formatting with Find and Replace 3482 1:13
5. locked Creating a Custom AutoFilter 3483 1:05
6. locked Disabling AutoFilter 3484 0:22
7. locked Using the Excel Search Task Pane 3485 1:39
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Inserting a draw object in a worksheet 3486 1:19
2. locked Drawing a line in a worksheet 3487 0:41
3. locked Formatting a line 3488 1:12
4. locked Drawing an arrow 3489 1:01
5. locked Selecting filled and unfilled objects 3490 0:40
6. locked Moving and resizing an object 3491 0:22
7. locked Adding text to an object 3492 1:16
8. locked Resizing an object 3493 0:40
9. locked Changing an object's fill color 3494 0:55
10. locked Changing an object's text color 3495 0:50
11. locked Deleting an object 3496 0:28
12. locked Adding 3-D effects to an object 3497 0:48
13. locked Using 3-D options 3498 1:17
14. locked Adding a shadow to an object 3499 0:54
15. locked Drawing a text box 3500 0:40
16. locked Inserting a picture 3501 1:47
17. locked Formatting a picture or graphic 3502 1:16
18. locked Inserting a diagram 3503 0:41
19. locked Using Diagram Layout options 3504 1:18
Tutorial series by Diana Trettel
Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.
©2012 Atomic Learning, Inc.   All rights reserved.