Excel 2002 (XP) - Advanced

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!

Expand all / Collapse all

A. Formulas and Outlines

		Key #	Length
1.	Using Labels in formulas	3749	1:59
2.	Using multiple stacked headings in a formula	3750	1:24
3.	Using an intersection cell name in a formula	3751	1:48
4.	Creating an outline group	3752	1:19
5.	Collapsing and Expanding an Outline	3753	1:22
6.	Changing Outline Settings	3754	0:47
7.	Clearing an Outline	3755	1:00
8.	Using Auto Outline	3756	1:27

B. Manipulating Data

		Key #	Length
1.	Creating an Excel Database	3757	1:54
2.	Making changes to an Excel Database	3758	1:09
3.	Sorting Records	3759	1:29
4.	Using Data Validation	3760	1:00
5.	Validating Data using a list	3761	1:23
6.	Creating an Error Message for users	3762	1:29
7.	Clearing Data Validation restrictions	3763	0:28
8.	Creating Sub-Totals in a List	3764	2:05
9.	Removing Sub-Totals from a list	3765	0:34
10.	Using Data Form to view Records	3766	1:08
11.	Making changes to Data Form Records	3767	0:26
12.	Adding a new Record in Data Form	3768	0:35
13.	Defining Criteria in a Data Form	3769	1:21
14.	Deleting a Data Form Record	3770	1:18
15.	Creating a Criteria Range	3771	1:17
16.	Using a Criteria Range to search a list	3772	1:32
17.	Showing all records after a filter is complete	3773	0:25
18.	Working with Comparison Criteria	3774	1:38
19.	Using the Advanced AND condition	3775	1:08
20.	Using the Advanced OR condition	3776	1:53
21.	Copying Filtered Records	3777	1:47
22.	Using Database Functions	3778	2:47

C. Data In - Data Out

		Key #	Length
1.	Exporting Data to Other Applications	3779	2:20
2.	Importing Data from a text file	3780	1:52
3.	Importing Data from an Access file	3781	1:43
4.	Breaking a link by removing the Query Definition	3782	1:20

D. Charting

		Key #	Length
1.	Adding or removing Chart Gridlines	3783	0:47
2.	Formatting a Chart Axis	3784	1:29
3.	Changing the Axis Scaling	3785	1:03
4.	Formatting a Chart Data Series	3786	0:53
5.	Add a data series from a different worksheet	3787	1:12
6.	Using a secondary axis in a Chart	3788	1:35
7.	Changing a Data Series Chart Type	3789	1:13
8.	Adding a Trendline to a Chart	3790	0:47
9.	Creating a Custom Chart Type	3791	0:29
10.	Applying your own user-defined Chart type	3792	0:58

E. Workbooks

		Key #	Length
1.	Cascading multiple open workbooks	3793	0:29
2.	Tiling multiple open workbooks windows	3794	0:30
3.	Copying Information Between Workbooks	3795	0:26
4.	Saving multiple workbooks as a Workspace	3796	1:06
5.	Closing all workbooks at one time	3797	0:32

F. Conditional Formatting

		Key #	Length
1.	Applying Conditional Formatting	3798	1:14
2.	Making Changes to your conditional formatting	3799	0:32
3.	Adding additional Conditional Formatting	3800	1:13
4.	Adding records in Conditional Formatted cells	3801	0:43
5.	Removing a Conditional Format	3802	0:51

G. Templates

		Key #	Length
1.	Saving a Workbook as a Template	3803	1:28
2.	Opening up a Template for use	3804	0:57
3.	Making changes to a saved Template	3805	1:15
4.	Deleting a old Template	3806	0:30

H. Advanced Options

		Key #	Length
1.	Copying a Value between worksheets	3807	1:16
2.	Copying formulas between worksheets	3808	1:26
3.	Using the Paste Special command	3809	1:53
4.	Protecting a Worksheet	3810	1:17
5.	Assigning a Password to a workbook	3811	1:10
6.	Removing a Password from a workbook	3812	0:42
7.	Setting up a VLOOKUP Table	3814	1:26
8.	Creating a VLOOKUP Function	3813	2:03
9.	Setting up an HLOOKUP Table	3815	1:52
10.	Creating an HLOOKUP Function	3816	1:33
11.	Using the IF Function	3817	2:28
12.	Using Nested IF Functions	3818	2:37
13.	Using an AND Condition with the IF Function	3819	1:49
14.	Using an OR Condition with the IF Function	3820	1:17
15.	Using the ROUND Function	3821	0:37
16.	Limit the precision of numbers	3822	1:09
17.	Displaying Dependent Arrows	3823	0:52
18.	Displaying Precedent Arrows	3824	1:18
19.	Using the Trace Error button	3825	0:57
20.	Using the Error Checking button	3826	1:18

I. Macros & Customization

		Key #	Length
1.	Recording a Macro	3827	1:38
2.	Assigning a Short Cut Key	3828	1:20
3.	Assigning a Macro to a Menu	3829	1:14
4.	Running a Macro	3830	0:49
5.	Deleting a Macro from a menu	3831	0:29
6.	Writing a Macro	3832	0:52
7.	Entering Macro Comments	3833	1:01
8.	Editing a Macro command	3834	0:32
9.	Testing a Macro from the Code Window	3835	0:57
10.	Creating a custom toolbar	3836	1:04
11.	Adding a Custom button to a toolbar	3837	1:01
12.	Assigning a Macro to a button	3838	1:05
13.	Changing the button image	3839	0:38
14.	Attaching a custom toolbar to a workbook	3840	0:50
15.	Deleting a custom toolbar	3841	0:50
16.	Creating a custom menu	3842	0:52
17.	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.

Tools

Generate Direct Linking HTML

Browse Training

Browse available training & projects

Log in to your account

My Profile & Settings

Direct Linking Preview

Direct Linking HTML

Generate Direct Linking HTML

Excel 2002 (XP) - Advanced

Description

Tools

Browse Training

Find an Answer to a Tech Question