Excel 2004 - Advanced

Platform: Mac

Description

The comprehensive tools in Microsoft^® Excel 2004 make it easy to create powerful spreadsheets, and work with others to review and analyze them. These advanced-level tutorials will help you to understand and utilize some of its more complex features.

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	17138	1:59
2.	Using multiple stacked headings in a formula	17139	1:13
3.	Using an intersection cell name in a formula	17140	1:27

B. Using Outlines

		Key #	Length
1.	Creating an outline group	17141	1:21
2.	Collapsing and expanding an outline	17142	1:12
3.	Clearing an outline	17143	0:55
4.	Using auto outline	17144	1:27

C. Excel Database Features

		Key #	Length
1.	Creating an Excel database	17145	1:14
2.	Making changes to an Excel database	17146	1:29
3.	Sorting records	17147	1:27
4.	Using data validation	17148	1:14
5.	Validating data using a list	17149	1:27
6.	Clearing data validation restrictions	17150	1:40
7.	Creating subtotals in a list	17151	1:47

D. Data Forms

		Key #	Length
1.	Using data form to view records	17152	1:13
2.	Making changes to data form records	17153	0:51
3.	Adding a new record in data form	17154	1:39
4.	Defining criteria in data form	17155	1:16
5.	Deleting a data form record	17156	1:01

E. Advanced Filters

		Key #	Length
1.	Creating a criteria range	17157	1:03
2.	Using a criteria range to search a list	17158	2:05
3.	Working with comparison criteria	17159	2:00
4.	Using the advanced AND condition	17160	1:07
5.	Using the advanced OR condition	17161	1:12
6.	Copying filtered conditions	17162	1:17
7.	Using database functions	17163	2:40

F. Export and import data

		Key #	Length
1.	Exporting data as a text file	17164	1:33
2.	Exporting data for a database application	17165	2:05
3.	Exporting data to an xml file	17166	1:32
4.	Importing data from a text file	17167	2:44

G. Advanced Charting

		Key #	Length
1.	Adding or removing chart gridlines	17168	1:16
2.	Formatting a chart axis	17169	2:00
3.	Changing the axis scaling	17170	1:14
4.	Formatting a chart data series	17171	1:25
5.	Using the secondary axis in a chart	17172	1:20
6.	Changing a data series chart type	17173	0:54
7.	Adding a trendline to a chart	17174	1:01
8.	Creating a custom chart type	17175	1:47

H. Multiple Workbook Features

		Key #	Length
1.	Cascading and tiling multiple open workbooks	17176	0:49
2.	Copying information between workbooks	17177	0:50
3.	Saving multiple workbooks as a workspace	17178	1:02
4.	Closing all workbooks at one time	17179	0:23

I. Conditional Formatting

		Key #	Length
1.	Applying conditional formatting	17180	1:31
2.	Making changes or deleting conditional formatting	17181	0:55
3.	Adding additional conditional formatting	17182	1:04
4.	Adding records in conditional formatted cells	17183	0:48

J. Templates

			Key #	Length
1.		Saving a workbook as a template	17184	1:32
2.		Making changes to a saved template	17185	1:11

K. Special Paste Options

		Key #	Length
1.	Copying a value between worksheets	17186	1:33
2.	Copying formulas between worksheets	17187	1:31
3.	Using paste special in a mathematical operation	17188	1:24

L. Workbook Protection

			Key #	Length
1.		Protecting a worksheet	17189	2:06
2.		Assigning and removing a workbook's password	17190	1:35

M. Advanced Functions

		Key #	Length
1.	Setting up a VLOOKUP table	17191	1:33
2.	Creating a VLOOKUP function	17192	2:18
3.	Setting up an HLOOKUP table	17193	0:59
4.	Creating an HLOOKUP function	17194	1:40
5.	Using the IF function	17195	1:52
6.	Using nested IF functions	17196	2:35
7.	Using an AND condition with the IF function	17197	2:05
8.	Using an OR condition with the IF function	17198	1:18
9.	Using the round function	17199	1:04
10.	Limiting the precision of numbers	17200	1:29

N. Auditing and Error Checking

		Key #	Length
1.	Displaying dependent arrows with the Auditing toolbar	17201	1:02
2.	Displaying precedent arrows with the Auditing toolbar	17202	1:46
3.	Using the Trace Error button	17203	1:11
4.	Using the Error Checking button	17204	0:51

O. Macros

		Key #	Length
1.	Recording a macro	17205	1:41
2.	Assigning a Macro to a menu	17206	1:43
3.	Deleting a Macro from a menu	17207	0:41
4.	Writing a macro	17208	2:31
5.	Entering macro comments	17209	1:44
6.	Editing a Macro command	17210	1:04
7.	Testing a macro from the code window	17211	0:44

P. Customizing Toolbars and Buttons

		Key #	Length
1.	Creating a custom toolbar	17212	1:16
2.	Adding a Custom button to a toolbar	17213	1:28
3.	Attaching a custom toolbar to a workbook	17214	0:54
4.	Deleting a custom toolbar	17215	0:55
5.	Creating a custom menu	17216	1:38

Tutorial series by Andrea Carlson

Box shot reprinted with permission from Microsoft Corporation. Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries. Mac is a trademark of Apple Computer, Inc., registered in the U.S. and 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 2004 - Advanced

Description

Tools

Browse Training

Find an Answer to a Tech Question