MICROSOFT EXCEL II
CURRICULUM: Computer Skills Training

PREREQUISITES:
• Successful completion of Microsoft Excel Basics
• 2 months using Microsoft Excel to create spreadsheets
LENGTH: 4 hours

OBJECTIVES:
1. Freeze rows and columns for screen view
2. Use custom lists
3. Sort and filter data
4. Guard cells using:
    Hide and unhide
    Protection
    Colors
5. Interrelate multiple sheets
6. Understand relative vs. absolute
7. Incorporate advance formulas:
    PV function
    If statements 
    Subtotal data
8. Select printing options:
    Orientation
    Print preview – margins
    Repeat rows and columns
    Gridlines vs. borders
    Headers and footers

MICROSOFT WORD II
CURRICULUM: Computer Skills Training

PREREQUISITES:
• Successful completion of Microsoft Word Basics
• 2 months using Microsoft Word to create spreadsheets
LENGTH: 4 hours

OBJECTIVES:
1. Learn composition tools:
    Non-breaking characters
    Envelopes
2. Change text using:
    Thesaurus
    Find and replace
    AutoCorrect
    Personal dictionary
3. Format with:
    Tabs
    Indents
    Format painter
    Styles
    AutoFormat
4. Incorporate headers and footers
5. Create a table:
    Adjust size
    Insert/delete columns and rows 
    Format borders, shading, alignment, text direction
    Merge cells
    Headings
    Sort
6. Perform mail merge:
    Main document
    Data source
    Merge