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

Microsoft Excel XP is the most popular spreadsheet application available today. For instructions on using Excel XP, 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

For more information on Excel, please visit Microsoft's site at http://www.microsoft.com/office/excel.

You may also browse to https://data.georgetown.edu/uis/training/cbt/index.html for a list of Main Campus' downloadable computer-based training applications. There are several Microsoft Excel programs available. (When prompted to log into the Main Campus site, use your Access+ password.)

Revised August 15, 2006 (DHFM)