Skip to content Skip to login

Excel 2004 - Advanced 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. 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!
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Using labels in formulas 17138 1:59
2. locked Using multiple stacked headings in a formula 17139 1:13
3. locked Using an intersection cell name in a formula 17140 1:27
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an outline group 17141 1:21
2. locked Collapsing and expanding an outline 17142 1:12
3. locked Clearing an outline 17143 0:55
4. locked Using auto outline 17144 1:27
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an Excel database 17145 1:14
2. locked Making changes to an Excel database 17146 1:29
3. locked Sorting records 17147 1:27
4. locked Using data validation 17148 1:14
5. locked Validating data using a list 17149 1:27
6. locked Clearing data validation restrictions 17150 1:40
7. locked Creating subtotals in a list 17151 1:47
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Using data form to view records 17152 1:13
2. locked Making changes to data form records 17153 0:51
3. locked Adding a new record in data form 17154 1:39
4. locked Defining criteria in data form 17155 1:16
5. locked Deleting a data form record 17156 1:01
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a criteria range 17157 1:03
2. locked Using a criteria range to search a list 17158 2:05
3. locked Working with comparison criteria 17159 2:00
4. locked Using the advanced AND condition 17160 1:07
5. locked Using the advanced OR condition 17161 1:12
6. locked Copying filtered conditions 17162 1:17
7. locked Using database functions 17163 2:40
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Exporting data as a text file 17164 1:33
2. locked Exporting data for a database application 17165 2:05
3. locked Exporting data to an xml file 17166 1:32
4. locked Importing data from a text file 17167 2:44
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding or removing chart gridlines 17168 1:16
2. locked Formatting a chart axis 17169 2:00
3. locked Changing the axis scaling 17170 1:14
4. locked Formatting a chart data series 17171 1:25
5. locked Using the secondary axis in a chart 17172 1:20
6. locked Changing a data series chart type 17173 0:54
7. locked Adding a trendline to a chart 17174 1:01
8. locked Creating a custom chart type 17175 1:47
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Cascading and tiling multiple open workbooks 17176 0:49
2. locked Copying information between workbooks 17177 0:50
3. locked Saving multiple workbooks as a workspace 17178 1:02
4. locked Closing all workbooks at one time 17179 0:23
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Applying conditional formatting 17180 1:31
2. locked Making changes or deleting conditional formatting 17181 0:55
3. locked Adding additional conditional formatting 17182 1:04
4. locked Adding records in conditional formatted cells 17183 0:48
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving a workbook as a template 17184 1:32
2. locked Making changes to a saved template 17185 1:11
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying a value between worksheets 17186 1:33
2. locked Copying formulas between worksheets 17187 1:31
3. locked Using paste special in a mathematical operation 17188 1:24
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting a worksheet 17189 2:06
2. locked Assigning and removing a workbook's password 17190 1:35
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Setting up a VLOOKUP table 17191 1:33
2. locked Creating a VLOOKUP function 17192 2:18
3. locked Setting up an HLOOKUP table 17193 0:59
4. locked Creating an HLOOKUP function 17194 1:40
5. locked Using the IF function 17195 1:52
6. locked Using nested IF functions 17196 2:35
7. locked Using an AND condition with the IF function 17197 2:05
8. locked Using an OR condition with the IF function 17198 1:18
9. locked Using the round function 17199 1:04
10. locked Limiting the precision of numbers 17200 1:29
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying dependent arrows with the Auditing toolbar 17201 1:02
2. locked Displaying precedent arrows with the Auditing toolbar 17202 1:46
3. locked Using the Trace Error button 17203 1:11
4. locked Using the Error Checking button 17204 0:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Recording a macro 17205 1:41
2. locked Assigning a Macro to a menu 17206 1:43
3. locked Deleting a Macro from a menu 17207 0:41
4. locked Writing a macro 17208 2:31
5. locked Entering macro comments 17209 1:44
6. locked Editing a Macro command 17210 1:04
7. locked Testing a macro from the code window 17211 0:44
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a custom toolbar 17212 1:16
2. locked Adding a Custom button to a toolbar 17213 1:28
3. locked Attaching a custom toolbar to a workbook 17214 0:54
4. locked Deleting a custom toolbar 17215 0:55
5. locked 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.
©2012 Atomic Learning, Inc.   All rights reserved.