Advanced Data Management in Excel 2007

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 organization 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 organizing and subtotaling data in Excel 2007 using the available features.

It also covers data validation, including error messages, invalid data prevention, formula auditing, error checking, and the Watch window.