Generate Direct Linking HTML

Select the tutorials you would like to include in the Direct Linking HTML, then click the "Preview" button.

Excel 2002 (XP) - Advanced
- A. Formulas and Outlines
- - Using Labels in formulas
  - Using multiple stacked headings in a formula
  - Using an intersection cell name in a formula
  - Creating an outline group
  - Collapsing and Expanding an Outline
  - Changing Outline Settings
  - Clearing an Outline
  - Using Auto Outline
- B. Manipulating Data
- - Creating an Excel Database
  - Making changes to an Excel Database
  - Sorting Records
  - Using Data Validation
  - Validating Data using a list
  - Creating an Error Message for users
  - Clearing Data Validation restrictions
  - Creating Sub-Totals in a List
  - Removing Sub-Totals from a list
  - Using Data Form to view Records
  - Making changes to Data Form Records
  - Adding a new Record in Data Form
  - Defining Criteria in a Data Form
  - Deleting a Data Form Record
  - Creating a Criteria Range
  - Using a Criteria Range to search a list
  - Showing all records after a filter is complete
  - Working with Comparison Criteria
  - Using the Advanced AND condition
  - Using the Advanced OR condition
  - Copying Filtered Records
  - Using Database Functions
- C. Data In - Data Out
- - Exporting Data to Other Applications
  - Importing Data from a text file
  - Importing Data from an Access file
  - Breaking a link by removing the Query Definition
- D. Charting
- - Adding or removing Chart Gridlines
  - Formatting a Chart Axis
  - Changing the Axis Scaling
  - Formatting a Chart Data Series
  - Add a data series from a different worksheet
  - Using a secondary axis in a Chart
  - Changing a Data Series Chart Type
  - Adding a Trendline to a Chart
  - Creating a Custom Chart Type
  - Applying your own user-defined Chart type
- E. Workbooks
- - Cascading multiple open workbooks
  - Tiling multiple open workbooks windows
  - Copying Information Between Workbooks
  - Saving multiple workbooks as a Workspace
  - Closing all workbooks at one time
- F. Conditional Formatting
- - Applying Conditional Formatting
  - Making Changes to your conditional formatting
  - Adding additional Conditional Formatting
  - Adding records in Conditional Formatted cells
  - Removing a Conditional Format
- G. Templates
- - Saving a Workbook as a Template
  - Opening up a Template for use
  - Making changes to a saved Template
  - Deleting a old Template
- H. Advanced Options
- - Copying a Value between worksheets
  - Copying formulas between worksheets
  - Using the Paste Special command
  - Protecting a Worksheet
  - Assigning a Password to a workbook
  - Removing a Password from a workbook
  - Setting up a VLOOKUP Table
  - Creating a VLOOKUP Function
  - Setting up an HLOOKUP Table
  - Creating an HLOOKUP Function
  - Using the IF Function
  - Using Nested IF Functions
  - Using an AND Condition with the IF Function
  - Using an OR Condition with the IF Function
  - Using the ROUND Function
  - Limit the precision of numbers
  - Displaying Dependent Arrows
  - Displaying Precedent Arrows
  - Using the Trace Error button
  - Using the Error Checking button
- I. Macros & Customization
- - Recording a Macro
  - Assigning a Short Cut Key
  - Assigning a Macro to a Menu
  - Running a Macro
  - Deleting a Macro from a menu
  - Writing a Macro
  - Entering Macro Comments
  - Editing a Macro command
  - Testing a Macro from the Code Window
  - Creating a custom toolbar
  - Adding a Custom button to a toolbar
  - Assigning a Macro to a button
  - Changing the button image
  - Attaching a custom toolbar to a workbook
  - Deleting a custom toolbar
  - Creating a custom menu
  - Adding commands to a Custom menu

Excel 2002 (XP) - Advanced

Platform: PC

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 here to learn about subscribing to this collection!

Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.

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.