Skip to content Skip to login

Excel 2004 - Intermediate Training View a tutorial on this topic

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!
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Renaming a sheet 14910 1:15
2. preview Inserting a new sheet 14911 0:52
3. locked Removing a sheet 14912 0:40
4. locked Reordering worksheets 14913 0:52
5. locked Viewing different sheets at the same time 14914 0:59
6. locked Splitting a worksheet window into panes 14915 1:44
7. locked Freezing a worksheet into panes 14916 1:28
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Inserting a draw object into a worksheet 14917 1:23
2. locked Drawing a line or arrow in a worksheet 14918 1:15
3. preview Formatting a drawing object 14919 1:27
4. locked Resizing a drawing object 14920 1:10
5. locked Adding text to a drawing object 14921 1:13
6. locked Adding 3D effects to a drawing object 14922 0:41
7. locked Adding a shadow to a drawing object 14923 1:21
8. locked Drawing a text box 14924 1:50
9. locked Inserting a picture 14925 1:11
10. locked Formatting a picture or a graphic 14926 1:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding cell comments 14927 1:55
2. locked Editing and deleting cell comments 14928 0:38
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Finding and replacing data 14929 1:59
2. preview Formatting cells based on a condition 14930 2:02
3. locked Using AutoFilter 14931 1:23
4. locked Using a custom AutoFilter 14932 2:03
5. locked Referring to data on other sheets in formulas 14933 2:22
6. locked Create a formula using cells on different worksheets 14934 2:04
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Naming cell ranges using the name box 14935 1:23
2. locked Naming cells using the Define Name box 14936 2:01
3. locked Create a name to represent a formula or a constant value 14937 1:24
4. locked Naming cells using column or row labels 14938 1:15
5. locked Name cells on more than one worksheet by using a 3D reference 14939 1:32
6. locked Using named cells in formulas 14940 2:19
7. locked Using multiple stacked headings in a formula 14941 1:16
8. locked Using an intersection cell name in a formula 14942 0:59
9. locked Jumping to named cell ranges 14943 1:07
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a chart with one keystroke 14944 0:39
2. locked Creating a chart using the chart wizard 14945 2:17
3. locked Setting the default chart type 14946 1:06
4. locked Changing the chart type 14947 1:03
5. locked Modifying chart elements 14948 1:01
6. locked Adding titles to the chart 14949 1:12
7. locked Change the chart location 14950 0:51
8. locked Changing the data series color 14951 1:35
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a list using the list wizard 14952 2:15
2. locked Entering data into a list 14953 0:58
3. locked Entering data using a form 14954 1:15
4. locked Changing column settings 14955 1:29
5. locked Inserting a column into a list 14956 1:08
6. locked Deleting a column in a list 14957 0:45
7. locked Adding totals to a list 14958 1:18
8. locked Formatting a list 14959 0:54
9. locked Filtering a list 14960 1:50
10. locked Sorting a list 14961 1:31
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Ensuring valid data is entered 14962 1:44
2. locked Adding an input message to validate data 14963 1:09
3. locked Customizing an error alert 14964 0:55
4. locked Viewing columns with data validation applied 14965 0:34
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Previewing a workbook's Web appearance 14966 0:46
2. locked Saving a workbook as a Web page 14967 1:36
3. locked Enable and disable workbook sharing 14968 1:45
4. locked Protecting an entire workbook 14969 1:38
5. locked Protecting a single sheet 14970 1:31
6. locked 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.
©2012 Atomic Learning, Inc.   All rights reserved.