Excel 2003 - Advanced

Platform: PC

Description

Microsoft^® Excel 2003, the spreadsheet module of Office 2003, makes it easy to create powerful spreadsheets. This advanced skills series will show you things you perhaps didn't know Excel could do!

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. Labels in Formulas

		Key #	Length
1.	Using labels in formulas	11665	1:55
2.	Using multiple stacked headings in a formula	11666	1:15
3.	Using an intersection cell name in a formula	11667	1:26

B. Using Outlines

		Key #	Length
1.	Creating an outline group	11668	1:38
2.	Collapsing and expanding an outline	11669	1:54
3.	Clearing an outline	11670	0:54
4.	Using auto outline	11671	1:37

C. Excel Database Features

		Key #	Length
1.	Creating an excel database	11672	1:27
2.	Making changes to an excel database	11673	1:28
3.	Sorting records	11674	1:59
4.	Using data validation	11675	1:07
5.	Validating data using a list	11676	1:45
6.	Creating an error message for users	11677	2:14
7.	Clearing data validation restrictions	11678	1:41
8.	Creating subtotals in a list	11679	1:45

D. Data Forms

		Key #	Length
1.	Using data form to view records	11680	1:19
2.	Making changes to data form records	11681	1:02
3.	Adding a new record in data form	11682	1:40
4.	Defining criteria in a data form	11683	1:52
5.	Deleting a data form record	11684	1:18

E. Advanced Filters

		Key #	Length
1.	Creating a criteria range	11685	1:24
2.	Using a criteria range to search a list	11686	2:59
3.	Working with comparison criteria	11687	2:12
4.	Using the advanced AND condition	11688	1:06
5.	Using the advanced OR condition	11689	2:00
6.	Copying filtered records	11690	1:40
7.	Using database functions	11691	3:06

F. Export and Import Data

		Key #	Length
1.	Exporting data as a text file	11692	2:17
2.	Exporting data for a database application	11693	1:30
3.	Exporting data to an xml file	11694	1:52
4.	Importing data from a text file	11695	3:12
5.	Importing data from an access file	11696	2:26
6.	Breaking a link by removing the query definition	11697	1:16

G. Advanced Charting

		Key #	Length
1.	Adding or removing chart gridlines	11698	1:46
2.	Formatting a chart axis	11699	2:25
3.	Changing the axis scaling	11700	1:19
4.	Formatting a chart data series	11701	2:14
5.	Add a data series from a different worksheet	11702	1:13
6.	Using a secondary axis in a chart	11703	1:39
7.	Changing a data series chart type	11704	0:58
8.	Adding a trendline to a chart	11705	1:07
9.	Creating a custom chart type	11706	2:02

H. Multiple Workbook Features

		Key #	Length
1.	Cascading and tiling multiple open workbooks	11707	0:55
2.	Copying information between workbooks	11708	0:37
3.	Saving multiple workbooks as a workspace	11709	1:02
4.	Closing all workbooks at one time	11710	0:21

I. Conditional Formatting

		Key #	Length
1.	Applying conditional formatting	11711	1:32
2.	Making changes or deleting your conditional formatting	11712	0:51
3.	Adding additional conditional formatting	11713	1:01
4.	Adding records in conditional formatted cells	11714	0:59

J. Templates

		Key #	Length
1.	Saving a workbook as a template	11715	1:50
2.	Making changes to a saved template	11716	1:13
3.	Deleting an old template	11717	1:08

K. Special Paste Options

		Key #	Length
1.	Copying a value between worksheets	11718	1:43
2.	Copying formulas between worksheets	11719	1:24
3.	Using paste special in a mathematical operation	11720	1:30

L. Workbook Protection

			Key #	Length
1.		Protecting a worksheet	11721	1:56
2.		Assigning and removing a workbook's password	11722	1:40

M. Advanced Functions

		Key #	Length
1.	Setting up a VLOOKUP table	11723	1:49
2.	Creating a VLOOKUP function	11724	2:23
3.	Setting up a HLOOKUP table	11725	1:14
4.	Creating a HLOOKUP function	11726	1:49
5.	Using the IF function	11727	2:03
6.	Using nested IF functions	11728	2:25
7.	Using an AND condition with the IF function	11729	1:56
8.	Using an OR condition with the IF function	11730	1:38
9.	Using the round function	11731	1:04
10.	Limit the precision of numbers	11732	1:24
11.	Using Goal Seek	30531	1:22

N. Auditing and Error Checking

		Key #	Length
1.	Displaying dependent arrows with the Auditing toolbar	11733	1:10
2.	Displaying precedent arrows with the Auditing toolbar	11734	2:12
3.	Using the Trace Error button	11735	1:33
4.	Using the Error Checking button	11736	1:42

O. Macros

		Key #	Length
1.	Recording a macro	11737	2:43
2.	Assigning a macro to a menu	11738	1:53
3.	Deleting a macro from a menu	11739	1:00
4.	Writing a macro	11740	2:43
5.	Entering macro comments	11741	1:40
6.	Editing a macro command	11742	1:29
7.	Testing a macro from the code window	11743	0:49

P. Customizing Toolbars and Buttons

		Key #	Length
1.	Creating a custom toolbar	11744	1:54
2.	Adding a custom button to a toolbar	11745	2:00
3.	Attaching a custom toolbar to a workbook	11746	1:14
4.	Deleting a custom toolbar	11747	0:56
5.	Creating a custom menu	11748	2:00

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 2003 - Advanced

Description

Tools

Browse Training

Find an Answer to a Tech Question