Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data management features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct, that it is entered in the proper format, and that formulas are working correctly, all of which are incredibly important for maintaining accurate records.

This course explores data management and subtotaling in Excel 2007 using the available data management features. It also covers data validation, including error messages, invalid data prevention, formula auditing, error checking, and the Watch window.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Lesson Objectives
Sorting and Filtering Data in Excel 2007
- sort data
- filter data in a range or table
Subtotal, Group, and Outline Data in Excel 2007
- group and outline data
- insert subtotals in a worksheet
- display different levels of data using outlines
Subtotaling, Filtering, and Grouping Data in Excel 2007
Organizing Worksheet Data
Validate Data in Excel 2007
- specify the data that is allowed in a particular range
- recognize which error alert to use in given examples
Audit and Correct Formulas in Excel 2007
- locate and correct formula errors
- use the Watch Window to audit formulas
Formula Auditing and Data Validation in Excel 2007