Generate Direct Linking HTML

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

Excel 2004 - Intermediate
- A. Working with Worksheets
- - Renaming a sheet
  - Inserting a new sheet
  - Removing a sheet
  - Reordering worksheets
  - Viewing different sheets at the same time
  - Splitting a worksheet window into panes
  - Freezing a worksheet into panes
- B. Objects, Pictures, and Diagrams
- - Inserting a draw object into a worksheet
  - Drawing a line or arrow in a worksheet
  - Formatting a drawing object
  - Resizing a drawing object
  - Adding text to a drawing object
  - Adding 3D effects to a drawing object
  - Adding a shadow to a drawing object
  - Drawing a text box
  - Inserting a picture
  - Formatting a picture or a graphic
- C. Cell Comments
- - Adding cell comments
  - Editing and deleting cell comments
- D. Miscellaneous Intermediate Skills
- - Finding and replacing data
  - Formatting cells based on a condition
  - Using AutoFilter
  - Using a custom AutoFilter
  - Referring to data on other sheets in formulas
  - Create a formula using cells on different worksheets
- E. Naming Cell Ranges
- - Naming cell ranges using the name box
  - Naming cells using the Define Name box
  - Create a name to represent a formula or a constant value
  - Naming cells using column or row labels
  - Name cells on more than one worksheet by using a 3D reference
  - Using named cells in formulas
  - Using multiple stacked headings in a formula
  - Using an intersection cell name in a formula
  - Jumping to named cell ranges
- F. Charts
- - Creating a chart with one keystroke
  - Creating a chart using the chart wizard
  - Setting the default chart type
  - Changing the chart type
  - Modifying chart elements
  - Adding titles to the chart
  - Change the chart location
  - Changing the data series color
- G. Working with Lists
- - Creating a list using the list wizard
  - Entering data into a list
  - Entering data using a form
  - Changing column settings
  - Inserting a column into a list
  - Deleting a column in a list
  - Adding totals to a list
  - Formatting a list
  - Filtering a list
  - Sorting a list
- H. Data Validation
- - Ensuring valid data is entered
  - Adding an input message to validate data
  - Customizing an error alert
  - Viewing columns with data validation applied
- I. Sharing Workbooks
- - Previewing a workbook's Web appearance
  - Saving a workbook as a Web page
  - Enable and disable workbook sharing
  - Protecting an entire workbook
  - Protecting a single sheet
  - Removing workbook or worksheet protection

Excel 2004 - Intermediate

Platform: Mac

The comprehensive tools in Microsoft^® Excel 2004 make it easy to create powerful spreadsheets and work with others to review and analyze them.

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. Working with Worksheets

		Key #	Length
1.	Renaming a sheet	14910	1:15
2.	Inserting a new sheet	14911	0:52
3.	Removing a sheet	14912	0:40
4.	Reordering worksheets	14913	0:52
5.	Viewing different sheets at the same time	14914	0:59
6.	Splitting a worksheet window into panes	14915	1:44
7.	Freezing a worksheet into panes	14916	1:28

B. Objects, Pictures, and Diagrams

		Key #	Length
1.	Inserting a draw object into a worksheet	14917	1:23
2.	Drawing a line or arrow in a worksheet	14918	1:15
3.	Formatting a drawing object	14919	1:27
4.	Resizing a drawing object	14920	1:10
5.	Adding text to a drawing object	14921	1:13
6.	Adding 3D effects to a drawing object	14922	0:41
7.	Adding a shadow to a drawing object	14923	1:21
8.	Drawing a text box	14924	1:50
9.	Inserting a picture	14925	1:11
10.	Formatting a picture or a graphic	14926	1:51

C. Cell Comments

			Key #	Length
1.		Adding cell comments	14927	1:55
2.		Editing and deleting cell comments	14928	0:38

D. Miscellaneous Intermediate Skills

		Key #	Length
1.	Finding and replacing data	14929	1:59
2.	Formatting cells based on a condition	14930	2:02
3.	Using AutoFilter	14931	1:23
4.	Using a custom AutoFilter	14932	2:03
5.	Referring to data on other sheets in formulas	14933	2:22
6.	Create a formula using cells on different worksheets	14934	2:04

E. Naming Cell Ranges

		Key #	Length
1.	Naming cell ranges using the name box	14935	1:23
2.	Naming cells using the Define Name box	14936	2:01
3.	Create a name to represent a formula or a constant value	14937	1:24
4.	Naming cells using column or row labels	14938	1:15
5.	Name cells on more than one worksheet by using a 3D reference	14939	1:32
6.	Using named cells in formulas	14940	2:19
7.	Using multiple stacked headings in a formula	14941	1:16
8.	Using an intersection cell name in a formula	14942	0:59
9.	Jumping to named cell ranges	14943	1:07

F. Charts

		Key #	Length
1.	Creating a chart with one keystroke	14944	0:39
2.	Creating a chart using the chart wizard	14945	2:17
3.	Setting the default chart type	14946	1:06
4.	Changing the chart type	14947	1:03
5.	Modifying chart elements	14948	1:01
6.	Adding titles to the chart	14949	1:12
7.	Change the chart location	14950	0:51
8.	Changing the data series color	14951	1:35

G. Working with Lists

		Key #	Length
1.	Creating a list using the list wizard	14952	2:15
2.	Entering data into a list	14953	0:58
3.	Entering data using a form	14954	1:15
4.	Changing column settings	14955	1:29
5.	Inserting a column into a list	14956	1:08
6.	Deleting a column in a list	14957	0:45
7.	Adding totals to a list	14958	1:18
8.	Formatting a list	14959	0:54
9.	Filtering a list	14960	1:50
10.	Sorting a list	14961	1:31

H. Data Validation

		Key #	Length
1.	Ensuring valid data is entered	14962	1:44
2.	Adding an input message to validate data	14963	1:09
3.	Customizing an error alert	14964	0:55
4.	Viewing columns with data validation applied	14965	0:34

I. Sharing Workbooks

		Key #	Length
1.	Previewing a workbook's Web appearance	14966	0:46
2.	Saving a workbook as a Web page	14967	1:36
3.	Enable and disable workbook sharing	14968	1:45
4.	Protecting an entire workbook	14969	1:38
5.	Protecting a single sheet	14970	1:31
6.	Removing workbook or worksheet protection	14971	0:56

Tutorial series by Sarah DePriest

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.