|
Welcome to our Flash tutorial series for Microsoft® Excel® 2003, the Office 2003 spreadsheet application. This intermediate series shows you how to create spreadsheet workbooks with multiple worksheets of data - building on the topics in the Introductory series.
These fast loading Flash tutorials will show you the many features of the PC version of Microsoft Excel 2003.
|
 |
| Tutorial Title |
Duration |
Size (KB) |
| Working with Rows and Columns |
|
|
| 1. |
Freezing Rows and Columns |
1:15 |
2,375 |
| 2. |
Repeating Rows and Columns |
1:55 |
2,061 |
| 3. |
AutoFit columns versus Same Size Columns |
1:28 |
1,411 |
|
|
|
|
|
|
|
|
| Worksheets |
|
|
| 1. |
Splitting a Worksheet |
1:37 |
1,913 |
| 2. |
Additional Worksheet Windows |
1:58 |
1,883 |
| 3. |
Creating Worksheet Groups |
1:51 |
1,649 |
| 4. |
Protecting Worksheets |
2:17 |
1,813 |
| 5. |
Hiding worksheets |
:42 |
1,035 |
|
|
|
|
|
|
|
|
| Formatting Data and Cells |
|
|
| 1. |
Formatting - Number Tab |
7:43 |
4,508 |
| 2. |
Special Number Formats |
2:16 |
1,940 |
| 3. |
Formatting - Alignment Tab |
5:16 |
4,069 |
| 4. |
Formatting - Font Tab |
3:17 |
2,331 |
| 5. |
Formatting - Border Tab |
2:47 |
2,487 |
| 6. |
Formatting - Patterns Tab |
2:30 |
2,263 |
| 7. |
Formatting - Protection |
3:55 |
3,055 |
| 8. |
AutoFormatting a Cell Range |
1:41 |
1,865 |
| 9. |
Clearing all formatting from cells |
2:15 |
1,906 |
| 10. |
Copy Worksheet Formatting to Another Worksheet |
2:44 |
2,240 |
| 11. |
Conditional Formatting |
4:06 |
3,023 |
| 12. |
Conditional Formatting - Remote Cells |
2:33 |
2,414 |
|
|
|
|
|
|
|
|
| Set Up and Output |
|
|
| 1. |
Headers and Footers |
4:06 |
2,750 |
| 2. |
Using Named Ranges to Print |
3:03 |
2,496 |
| 3. |
Page Breaks |
2:48 |
2,442 |
| 4. |
Page Setup dialog box - Page |
3:13 |
2,209 |
| 5. |
Page Setup dialog box - Margins |
:55 |
1,162 |
| 6. |
Page Setup dialog box - Header/Footer |
4:51 |
3,278 |
| 7. |
Page Setup dialog box - Sheet |
5:51 |
5,476 |
| 8. |
Print Preview buttons |
4:36 |
3,655 |
|
|
|
|
|
|
|
|
| Tips and Tricks |
|
|
| 1. |
Watch Window |
3:50 |
3,600 |
| 2. |
Screen Tips |
1:17 |
1,254 |
| 3. |
Office Assistant |
3:00 |
2,571 |
| 4. |
Help Pane |
3:18 |
2,612 |
| 5. |
Clip Board |
3:31 |
2,593 |
| 6. |
Full Screen View |
1:15 |
1,236 |
| 7. |
Comments - Inserting, Editing & Deleting |
3:15 |
1,918 |
|
|
|
|
|
|
|
|
|
|
|
|
|
CTAP Technology Tutorials
© 2009 California Technology Assistance Project
|
Last Updated (Tuesday, 01 September 2009 10:08)
| 
| 
