Project 5 Skill Set

Click on the button to the left of each skill demonstration to play the flash demonstration

Add a field and a formula to a list

Advanced filter and extract

Advanced Filter in Place

Advanced Filter

Auto Filter

Auto Outline

Use COUNTIF

Create a List with Headers

Create a custom auto filter

Find a Record with Data Form

DAVERAGE Function

Delete a Sheet

Export to a tab delimited file

Find Records with auto form

Format within a List

Group and Collapse Rows

Merge and Center Horizontally and Vertically

Remove Subtotals

Alpha Sort

Sort and use Subtotals

Sort on two criteria

Stop Style Error

SUMIF Function

Use a Form to Enter Data

HLOOKUP Function

Use Validation

VLOOKUP Function

Another look at VLOOKUP