Skip to content Skip to login

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

Platform: PC

Description

The advanced tools in Microsoft® Excel 2002 , the spreadsheet module of Office XP, 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 Using Labels in formulas 3749 1:59
2. preview Using multiple stacked headings in a formula 3750 1:24
3. preview Using an intersection cell name in a formula 3751 1:48
4. preview Creating an outline group 3752 1:19
5. preview Collapsing and Expanding an Outline 3753 1:22
6. locked Changing Outline Settings 3754 0:47
7. locked Clearing an Outline 3755 1:00
8. locked Using Auto Outline 3756 1:27
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an Excel Database 3757 1:54
2. locked Making changes to an Excel Database 3758 1:09
3. locked Sorting Records 3759 1:29
4. locked Using Data Validation 3760 1:00
5. locked Validating Data using a list 3761 1:23
6. locked Creating an Error Message for users 3762 1:29
7. locked Clearing Data Validation restrictions 3763 0:28
8. locked Creating Sub-Totals in a List 3764 2:05
9. locked Removing Sub-Totals from a list 3765 0:34
10. locked Using Data Form to view Records 3766 1:08
11. locked Making changes to Data Form Records 3767 0:26
12. locked Adding a new Record in Data Form 3768 0:35
13. locked Defining Criteria in a Data Form 3769 1:21
14. locked Deleting a Data Form Record 3770 1:18
15. locked Creating a Criteria Range 3771 1:17
16. locked Using a Criteria Range to search a list 3772 1:32
17. locked Showing all records after a filter is complete 3773 0:25
18. locked Working with Comparison Criteria 3774 1:38
19. locked Using the Advanced AND condition 3775 1:08
20. locked Using the Advanced OR condition 3776 1:53
21. locked Copying Filtered Records 3777 1:47
22. locked Using Database Functions 3778 2:47
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Exporting Data to Other Applications 3779 2:20
2. locked Importing Data from a text file 3780 1:52
3. locked Importing Data from an Access file 3781 1:43
4. locked Breaking a link by removing the Query Definition 3782 1:20
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding or removing Chart Gridlines 3783 0:47
2. locked Formatting a Chart Axis 3784 1:29
3. locked Changing the Axis Scaling 3785 1:03
4. locked Formatting a Chart Data Series 3786 0:53
5. locked Add a data series from a different worksheet 3787 1:12
6. locked Using a secondary axis in a Chart 3788 1:35
7. locked Changing a Data Series Chart Type 3789 1:13
8. locked Adding a Trendline to a Chart 3790 0:47
9. locked Creating a Custom Chart Type 3791 0:29
10. locked Applying your own user-defined Chart type 3792 0:58
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Cascading multiple open workbooks 3793 0:29
2. locked Tiling multiple open workbooks windows 3794 0:30
3. locked Copying Information Between Workbooks 3795 0:26
4. locked Saving multiple workbooks as a Workspace 3796 1:06
5. locked Closing all workbooks at one time 3797 0:32
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Applying Conditional Formatting 3798 1:14
2. locked Making Changes to your conditional formatting 3799 0:32
3. locked Adding additional Conditional Formatting 3800 1:13
4. locked Adding records in Conditional Formatted cells 3801 0:43
5. locked Removing a Conditional Format 3802 0:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving a Workbook as a Template 3803 1:28
2. locked Opening up a Template for use 3804 0:57
3. locked Making changes to a saved Template 3805 1:15
4. locked Deleting a old Template 3806 0:30
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying a Value between worksheets 3807 1:16
2. locked Copying formulas between worksheets 3808 1:26
3. locked Using the Paste Special command 3809 1:53
4. locked Protecting a Worksheet 3810 1:17
5. locked Assigning a Password to a workbook 3811 1:10
6. locked Removing a Password from a workbook 3812 0:42
7. locked Setting up a VLOOKUP Table 3814 1:26
8. locked Creating a VLOOKUP Function 3813 2:03
9. locked Setting up an HLOOKUP Table 3815 1:52
10. locked Creating an HLOOKUP Function 3816 1:33
11. locked Using the IF Function 3817 2:28
12. locked Using Nested IF Functions 3818 2:37
13. locked Using an AND Condition with the IF Function 3819 1:49
14. locked Using an OR Condition with the IF Function 3820 1:17
15. locked Using the ROUND Function 3821 0:37
16. locked Limit the precision of numbers 3822 1:09
17. locked Displaying Dependent Arrows 3823 0:52
18. locked Displaying Precedent Arrows 3824 1:18
19. locked Using the Trace Error button 3825 0:57
20. locked Using the Error Checking button 3826 1:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Recording a Macro 3827 1:38
2. locked Assigning a Short Cut Key 3828 1:20
3. locked Assigning a Macro to a Menu 3829 1:14
4. locked Running a Macro 3830 0:49
5. locked Deleting a Macro from a menu 3831 0:29
6. locked Writing a Macro 3832 0:52
7. locked Entering Macro Comments 3833 1:01
8. locked Editing a Macro command 3834 0:32
9. locked Testing a Macro from the Code Window 3835 0:57
10. locked Creating a custom toolbar 3836 1:04
11. locked Adding a Custom button to a toolbar 3837 1:01
12. locked Assigning a Macro to a button 3838 1:05
13. locked Changing the button image 3839 0:38
14. locked Attaching a custom toolbar to a workbook 3840 0:50
15. locked Deleting a custom toolbar 3841 0:50
16. locked Creating a custom menu 3842 0:52
17. locked Adding commands to a Custom menu 3843 0:47
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.