Excel 2004 - Intermediate

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.

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. 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.

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 - Intermediate

Description

Tools

Browse Training

Find an Answer to a Tech Question