OUTLINE FOR EXCEL FOR Windows XP LEVEL I (Duration: 1 day)

1. Getting Started
- starting Excel, the Excel application window
- using the menu system and toolbars
- exiting from Excel

2. Modifying an existing worksheet
- resetting the working folder
- moving the cell pointer, changing data in a worksheet
- undoing an operation
- saving a workbook
- adding data to a worksheet, entering formulas
- adjusting column width in a worksheet
- printing a worksheet

3. Building a worksheet
- opening a new workbook

4. Using worksheet shortcuts
- using AutoFill
- copying, moving and clearing cell entries
- using AutoSum
- inserting new rows and columns into a worksheet

5. Enhancing worksheet appearance
- using edit mode
- adjusting row height, realigning cell entries
- changing the font, numeric format
- adding a border and shading to a worksheet
- using AutoFormat

6. Improving printed output
- changing the page setup
- previewing a worksheet

7. Final case study

 

A division of Infinities Inc Computer Training, Columbia, SC
| Home | Courses & Schedule | Registration | Contact Us |