Excel 2003 - Advanced View a tutorial on this topic

Platform: PC

Description

Microsoft® Excel 2003, the spreadsheet module of Office 2003, makes it easy to create powerful spreadsheets. This advanced skills series will show you things you perhaps didn't know Excel could do!
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.
Key # Length
1. preview Using labels in formulas 11665 1:55
2. preview Using multiple stacked headings in a formula 11666 1:15
3. preview Using an intersection cell name in a formula 11667 1:26
Key # Length
1. locked Creating an outline group 11668 1:38
2. locked Collapsing and expanding an outline 11669 1:54
3. locked Clearing an outline 11670 0:54
4. locked Using auto outline 11671 1:37
Key # Length
1. locked Creating an excel database 11672 1:27
2. locked Making changes to an excel database 11673 1:28
3. locked Sorting records 11674 1:59
4. locked Using data validation 11675 1:07
5. locked Validating data using a list 11676 1:45
6. locked Creating an error message for users 11677 2:14
7. locked Clearing data validation restrictions 11678 1:41
8. locked Creating subtotals in a list 11679 1:45
Key # Length
1. locked Using data form to view records 11680 1:19
2. locked Making changes to data form records 11681 1:02
3. locked Adding a new record in data form 11682 1:40
4. locked Defining criteria in a data form 11683 1:52
5. locked Deleting a data form record 11684 1:18
Key # Length
1. locked Creating a criteria range 11685 1:24
2. locked Using a criteria range to search a list 11686 2:59
3. locked Working with comparison criteria 11687 2:12
4. locked Using the advanced AND condition 11688 1:06
5. locked Using the advanced OR condition 11689 2:00
6. locked Copying filtered records 11690 1:40
7. locked Using database functions 11691 3:06
Key # Length
1. locked Exporting data as a text file 11692 2:17
2. locked Exporting data for a database application 11693 1:30
3. locked Exporting data to an xml file 11694 1:52
4. locked Importing data from a text file 11695 3:12
5. locked Importing data from an access file 11696 2:26
6. locked Breaking a link by removing the query definition 11697 1:16
Key # Length
1. locked Adding or removing chart gridlines 11698 1:46
2. locked Formatting a chart axis 11699 2:25
3. locked Changing the axis scaling 11700 1:19
4. locked Formatting a chart data series 11701 2:14
5. locked Add a data series from a different worksheet 11702 1:13
6. locked Using a secondary axis in a chart 11703 1:39
7. locked Changing a data series chart type 11704 0:58
8. locked Adding a trendline to a chart 11705 1:07
9. locked Creating a custom chart type 11706 2:02
Key # Length
1. locked Cascading and tiling multiple open workbooks 11707 0:55
2. locked Copying information between workbooks 11708 0:37
3. locked Saving multiple workbooks as a workspace 11709 1:02
4. locked Closing all workbooks at one time 11710 0:21
Key # Length
1. locked Applying conditional formatting 11711 1:32
2. locked Making changes or deleting your conditional formatting 11712 0:51
3. locked Adding additional conditional formatting 11713 1:01
4. locked Adding records in conditional formatted cells 11714 0:59
Key # Length
1. locked Saving a workbook as a template 11715 1:50
2. locked Making changes to a saved template 11716 1:13
3. locked Deleting an old template 11717 1:08
Key # Length
1. locked Copying a value between worksheets 11718 1:43
2. locked Copying formulas between worksheets 11719 1:24
3. locked Using paste special in a mathematical operation 11720 1:30
Key # Length
1. locked Protecting a worksheet 11721 1:56
2. locked Assigning and removing a workbook's password 11722 1:40
Key # Length
1. locked Setting up a VLOOKUP table 11723 1:49
2. locked Creating a VLOOKUP function 11724 2:23
3. locked Setting up a HLOOKUP table 11725 1:14
4. locked Creating a HLOOKUP function 11726 1:49
5. locked Using the IF function 11727 2:03
6. locked Using nested IF functions 11728 2:25
7. locked Using an AND condition with the IF function 11729 1:56
8. locked Using an OR condition with the IF function 11730 1:38
9. locked Using the round function 11731 1:04
10. locked Limit the precision of numbers 11732 1:24
11. locked Using Goal Seek 30531 1:22
Key # Length
1. locked Displaying dependent arrows with the Auditing toolbar 11733 1:10
2. locked Displaying precedent arrows with the Auditing toolbar 11734 2:12
3. locked Using the Trace Error button 11735 1:33
4. locked Using the Error Checking button 11736 1:42
Key # Length
1. locked Recording a macro 11737 2:43
2. locked Assigning a macro to a menu 11738 1:53
3. locked Deleting a macro from a menu 11739 1:00
4. locked Writing a macro 11740 2:43
5. locked Entering macro comments 11741 1:40
6. locked Editing a macro command 11742 1:29
7. locked Testing a macro from the code window 11743 0:49
Key # Length
1. locked Creating a custom toolbar 11744 1:54
2. locked Adding a custom button to a toolbar 11745 2:00
3. locked Attaching a custom toolbar to a workbook 11746 1:14
4. locked Deleting a custom toolbar 11747 0:56
5. locked Creating a custom menu 11748 2:00
Tutorial series by Diana Trettel
Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.