Skip to content Skip to login

Excel 2000 - Advanced Training View a tutorial on this topic

Platform: PC

Description

The advanced tools in Microsoft® Excel 2000 make it easy to create powerful spreadsheets to manage and analyze data. These tutorials cover the more advanced aspects.
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.
Click here to learn about subscribing to this collection!
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Creating an Outline group 8083 1:09
2. preview Collapsing and expanding an outline 8084 0:57
3. preview Changing Outline settings 8085 0:42
4. preview Clearing an outline 8086 1:03
5. preview Using AutoOutline 8087 0:44
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an Excel database 8088 0:48
2. locked Making changes to an Excel database 8089 0:52
3. locked Sorting records 8090 0:56
4. locked Using Data Validation 8091 1:17
5. locked Validating data using a list 8092 1:29
6. locked Creating an error message for users 8093 1:23
7. locked Clearing data validation restrictions 8094 0:31
8. locked Creating subtotals in a list 8095 1:43
9. locked Removing subtotals from a list 8096 0:22
10. locked Using Data Form to view records 8097 0:58
11. locked Making changes to Data Form records 8098 0:36
12. locked Adding a new record in Data Form 8099 0:42
13. locked Defining criteria in Data Form 8100 1:32
14. locked Deleting a Data Form record 8101 0:40
15. locked Creating a criteria range 8102 0:52
16. locked Using a criteria range to search a list 8103 1:43
17. locked Showing all records after a filter is complete 8104 0:30
18. locked Working with comparison criteria 8105 1:15
19. locked Using the advanced AND condition 8106 1:09
20. locked Using the advanced OR condition 8107 1:30
21. locked Copying filtered records 8108 0:34
22. locked Using Database functions 8109 2:01
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Exporting data to other applications 8110 1:48
2. locked Importing data from a Text file 8111 1:38
3. locked Importing data from an Access file 8112 3:15
4. locked Breaking a link by removing the query definition 8113 1:04
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding or removing chart gridlines 8114 0:40
2. locked Formatting a chart axis 8115 1:41
3. locked Changing the axis scaling 8116 1:05
4. locked Formatting a chart data series 8117 0:55
5. locked Adding a data series from a different worksheet 8118 0:45
6. locked Using a secondary axis in a chart 8119 1:07
7. locked Changing a data series chart type 8120 0:25
8. locked Adding a trend line to a chart 8121 0:37
9. locked Creating a custom chart type 8122 0:52
10. locked Applying your own user-defined chart type 8123 0:44
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Cascading multiple open workbooks 8124 1:02
2. locked Tiling multiple open workbook windows 8125 0:33
3. locked Copying information between workbooks 8126 1:20
4. locked Saving multiple workbooks as a workspace 8127 1:34
5. locked Closing all workbooks at one time 8128 0:31
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Applying Conditional formatting 8129 1:23
2. locked Making changes to your Conditional formatting 8130 0:42
3. locked Adding additional Conditional formatting 8131 0:54
4. locked Adding records in Conditional formatted cells 8132 0:44
5. locked Removing a Conditional format 8133 0:30
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving a workbook as a template 8134 0:50
2. locked Opening up a template for use 8135 0:29
3. locked Making changes to a saved template 8136 1:00
4. locked Deleting an old template 8137 0:30
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying a value between worksheets 8138 1:08
2. locked Copying formulas between worksheets 8139 0:55
3. locked Using the Paste Special command 8140 1:18
4. locked Protecting a worksheet 8141 1:23
5. locked Assigning a password to a workbook 8142 1:15
6. locked Removing a password from a workbook 8143 0:43
7. locked Creating a VLOOKUP function 8144 1:10
8. locked Setting up a VLOOKUP table 8145 0:44
9. locked Creating a HLOOKUP function 8146 1:08
10. locked Setting up a HLOOKUP table 8147 0:50
11. locked Using the IF function 8148 1:20
12. locked Using nested IF functions 8149 3:12
13. locked Using an AND condition with the IF function 8150 1:41
14. locked Using an OR condition with the IF function 8151 1:44
15. locked Using the ROUND function 8152 1:38
16. locked Limiting the precision of numbers 8153 1:42
17. locked Displaying dependent arrows 8154 0:59
18. locked Displaying precedent arrows 8155 0:59
19. locked Using the Trace Error button 8156 1:52
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Recording a macro 8157 1:17
2. locked Assigning a shortcut key 8158 0:37
3. locked Assigning a macro to a menu 8159 1:42
4. locked Running a macro 8160 1:00
5. locked Deleting a macro from a menu 8161 0:51
6. locked Writing a macro 8162 1:15
7. locked Entering macro comments 8163 0:33
8. locked Editing a Macro command 8164 0:57
9. locked Testing a macro from the Code window 8165 0:30
10. locked Creating a custom toolbar 8166 0:30
11. locked Adding a custom button to a toolbar 8167 0:41
12. locked Assigning a macro to a button 8168 0:41
13. locked Changing the button image 8169 0:26
14. locked Attaching a custom toolbar to a workbook 8170 0:59
15. locked Deleting a custom toolbar 8171 0:21
16. locked Creating a custom menu 8172 1:02
17. locked Adding commands to a custom menu 8173 1:27
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.