Skip to content Skip to login

Excel 2000 - Intermediate Training View a tutorial on this topic

Platform: PC

Description

Microsoft® Excel 2000 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 7970 1:29
2. preview Using Full Screen mode 7971 0:38
3. preview Splitting a worksheet window into panes 7972 1:07
4. preview Freezing and unfreezing panes 7973 0:59
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Selecting worksheets 7974 1:13
2. locked Renaming worksheets 7975 0:38
3. locked Inserting a worksheet 7976 0:43
4. locked Removing a worksheet 7977 0:30
5. locked Changing the order of worksheets 7978 0:27
6. locked Grouping worksheets for one-step changes 7979 0:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D formula 7980 1:18
2. locked Using 3-D ranges 7981 1:50
3. locked Dragging 3-D formulas 7982 0:53
4. locked Assigning a name to a cell 7983 0:55
5. locked Jumping to a cell using the name box 7984 0:32
6. locked Using range names in formulas 7985 1:07
7. locked Creating range names 7986 1:03
8. locked Replacing cell addresses to range names 7987 1:16
9. locked Deleting range names 7988 0:43
10. locked Creating a 3-D formula using range names 7989 1:13
11. locked Creating a 3-D range name 7990 1:28
12. locked Using 3-D range names in formulas 7991 0:37
13. locked Creating an IF function 7992 1:56
14. locked Creating a DATE function 7993 0:54
15. locked Formatting a date 7994 1:07
16. locked Editing a function 7995 0:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Sorting lists 7996 1:23
2. locked Using Find and Replace 7997 1:14
3. locked Running AutoFilter 7998 2:00
4. locked Creating a custom AutoFilter 7999 1:24
5. locked Disabling AutoFilter 8000 0:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Inserting a draw object in a worksheet 8001 1:01
2. locked Drawing a line in a worksheet 8002 0:27
3. locked Formatting a line 8003 0:29
4. locked Drawing an arrow 8004 0:44
5. locked Selecting filled and unfilled objects 8005 0:42
6. locked Moving vs. resizing an object 8006 0:55
7. locked Adding text to an object 8007 0:54
8. locked Resizing an object 8008 0:44
9. locked Changing an object's fill color 8009 0:36
10. locked Changing an object's text color 8010 0:41
11. locked Deleting an object 8011 0:34
12. locked Adding 3-D effects to an object 8012 0:34
13. locked Using 3-D options 8013 1:29
14. locked Adding a shadow to an object 8014 0:57
15. locked Drawing a text box 8015 0:51
16. locked Inserting a picture 8016 1:27
17. locked Formatting a picture or graphic 8017 2:22
Tutorial series by Diana Trettel
Box shot reprinted with 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.