1. Starting Excel

2. Window Properties

3. Toolbars & Task Pane

4. Creating Workbooks

5. Creating Worksheets

6. Selecting Cells

7. Entering Data

8. Saving

9. Formatting

10. Cutting & Copying

11. Basic Math

12. The AutoSum Feature

13. The Function Wizard

14. Relative & Absolute References

15. The AutoFill Function

16. Paste Special

17. Linking Cells

18. Organizing Data

19. Charts

20. Inserting Comments

21. Page Setup

22. Printing

23. Closing & Exiting

For instructions on using Microsoft Excel 2003, please use the links to the left or the Table of Contents below.

Table of Contents:

1. Starting Microsoft Excel
2. Excel Window Properties
3. Toolbars & the Task Pane
   • Separating Toolbars & Displaying Complete Dropdown Menus
   • Accessing Other Toolbars
   • Adding & Deleting Toolbar Icons
   • The Task Pane
4. Creating a New Workbook
5. Creating New Worksheets
6. Selecting Cells
7. Entering Data in a Worksheet
8. Saving a Workbook
9. Formatting
   • Formatting Cells Using the Formatting Toolbar
   • Formatting Numbers
   • Wrapping Text
   • Merging Cells
   • AutoFitting Data Within Cells
   • Changing Worksheet Tab Colors
10. Cutting & Copying Data
    • Cutting Data
    • Copying Data
11. Performing Basic Mathematical Operations
12. Using the AutoSum Feature
13. The Function Wizard
14. Relative & Absolute References
    • What are Relative & Absolute References?
    • Copying a Formula Using a Relative Reference
    • Copying a Formula Using an Absolute Reference
15. AutoFill
    • Copying Text or Numbers
    • Creating a List or a Series
16. The Paste Special Function
17. Linking Cells
18. Organizing Data
    • Basic Data Sorting
    • Multiple-Level Sorting
    • Subtotaling Sorted Lists
    • Filtering Lists
19. Charts
    • Creating Charts
    • Editing Your Chart
20. Inserting Comments in a Worksheet
21. Page Setup
    • Using the Page Setup Dialog to Add Headers & Footers, Determine Size, Orientation & Margins, Print Specific Portions of Your Worksheet, etc.
    • Adding the File Name and Network File Path to a Worksheet
22. Printing a Worksheet
23. Closing a Workbook
24. Exiting Microsoft Excel

Revised October 19, 2010 (DHFM)