Excel 2003 - Intermediate
Platform: PC
Description
Microsoft® Excel 2003, the spreadsheet module of Office 2003, makes it easy to create powerful spreadsheets. This intermediate skills series will take you many steps beyond the basics.
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.
| Key # | Length | |||
|---|---|---|---|---|
| 1. |  |
Comparing Excel workbooks side by side | 11003 | 1:37 |
| 2. | |
Working with zoom | 11004 | 1:38 |
| 3. | |
Full Screen Mode | 11005 | 1:25 |
| 4. | |
Splitting a worksheet window into panes | 11006 | 1:33 |
| 5. | |
Freezing and Unfreezing Panes | 11007 | 1:42 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Selecting worksheets | 11008 | 1:51 |
| 2. | |
Renaming worksheets | 11009 | 1:21 |
| 3. | |
Coloring worksheet tabs | 11010 | 1:32 |
| 4. | |
Inserting a worksheet | 11011 | 1:06 |
| 5. | |
Removing a worksheet | 11012 | 0:43 |
| 6. | |
Changing the order of worksheets | 11013 | 0:57 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Creating a 3-D formula | 11014 | 1:30 |
| 2. | |
Using 3-D ranges | 11015 | 1:42 |
| 3. | |
Dragging 3-D formulas | 11016 | 0:43 |
| 4. | |
Assigning a name to a cell | 11017 | 1:08 |
| 5. | |
Jumping to a cell using the name box | 11018 | 0:54 |
| 6. | |
Using range names in formulas | 11019 | 0:58 |
| 7. | |
Creating range names using column or row headings | 11020 | 2:03 |
| 8. | |
Replacing cell addresses with range names | 11021 | 1:10 |
| 9. | |
Deleting range names | 11022 | 0:53 |
| 10. | |
Creating a 3-D formula using range names | 11023 | 0:47 |
| 11. | |
Creating a 3-D range name | 11024 | 1:30 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Creating an IF function | 11025 | 1:35 |
| 2. | |
Creating a DATE function | 11026 | 2:24 |
| 3. | |
Formatting a date | 11027 | 0:46 |
| 4. | |
Editing a function | 11028 | 0:47 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Creating a list in Excel | 11029 | 2:29 |
| 2. | |
Sorting a list | 11030 | 2:12 |
| 3. | |
Filtering and sorting in an Excel list | 11031 | 1:09 |
| 4. | |
Inserting columns and rows in a list | 11032 | 1:29 |
| 5. | |
Moving, hiding, and converting lists | 11033 | 1:30 |
| 6. | |
Creating a toggle total row in a list | 11034 | 1:17 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using find and replace | 11035 | 1:25 |
| 2. | |
Running AutoFilter | 11036 | 1:11 |
| 3. | |
Changing formatting with Find and Replace | 11037 | 1:37 |
| 4. | |
Creating a Custom AutoFilter | 11038 | 2:02 |
| 5. | |
The Excel Search Task Pane | 11039 | 1:11 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Inserting a draw object in a worksheet | 11040 | 1:13 |
| 2. | |
Drawing a line in a worksheet | 11041 | 1:16 |
| 3. | |
Formatting a line | 11042 | 1:29 |
| 4. | |
Drawing an arrow | 11043 | 1:03 |
| 5. | |
Selecting filled and unfilled objects | 11044 | 1:00 |
| 6. | |
Resizing an object | 11045 | 1:36 |
| 7. | |
Adding text to an object | 11046 | 1:05 |
| 8. | |
Changing an object's fill and text colors | 11047 | 0:47 |
| 9. | |
Adding 3-D effects to an object | 11048 | 1:31 |
| 10. | |
Adding a shadow to an object | 11049 | 0:56 |
| 11. | |
Drawing a text box | 11050 | 0:45 |
| 12. | |
Inserting a picture | 11051 | 1:02 |
| 13. | |
Formatting a picture or graphic | 11052 | 1:04 |
| 14. | |
Inserting a diagram | 11053 | 1:04 |
| 15. | |
Using diagram Layout options | 11054 | 0:24 |
Generate Direct Linking HTMLBrowse Training
Find an Answer to a Tech Question