Excel 2007 Advanced Online Courses | Online Learning

Unlimited Use. You may access a purchased e-learning course through the Internet at any time for 12 months from date of purchase.

Licensed Content The content material is proprietary and copyrights are owned as listed at the beginning of each

online course

. The course is licensed to you for your use.

License

Excel 2007 Advanced Series: Filtering and Sorting Data

Summary:

This course provides information on how to filter and sort your worksheets in Excel 2007.

Objectives:

Remove duplicate records from an Excel worksheet
Apply filters to an Excel worksheet
Apply one-click, multiple-level, and custom sorts to your data

Topics:

Removing duplicate records
Using filters
Setting filter options
Sorting data
One-click and custom sorting

Technical Requirements:

Minimum 500MHz Processor; 128 MB RAM; Minimum display resolution 1024x768; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 7.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and cookies enabled; Sound card with speakers or headphones strongly recommended.