Excel 2003 Module III: Database Management and Analysis is a course that presents skills training and assessment for some of the skill sets that form the Microsoft Office Excel 2003 Specialist and Expert exams. This course provides competency in validating data, creating and modifying list ranges, sorting database data, using database functions, using the Advanced Filter and Automatic Subtotal features, creating and modifying PivotTables and PivotCharts, formatting and adjusting PivotTables, auditing worksheets, performing what-if analyses, and working with scenarios. Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and review your skills after each lesson in the Lesson Summary and Lesson Review sections. Additional skill reinforcement is provided in Activities, Optional Labs, Lesson Quizzes and a Course Assessment that are available from your instructor.

Topics

Working with Databases
Introduction to Databases
Validating Data
Modifying and Finding Database Records
Creating and Modifying List Ranges
Case Study

Sorting Database Data
Introduction to Sorting Database Data
Sorting Records by up to Three Fields
Rearranging Fields
Sorting Records by Four or More Fields
Applying Custom Sort Orders
Sorting Text as Numbers

Using Database Functions
Introduction to Database Functions
Using the DAVERAGE Function
Using the DCOUNT Function
Using the DSUM Function
Using the DMIN Function
Using the DMAX Function
Using the DGET Function

Using Advanced Filters and
Automatic Subtotals
Filtering, Extracting and Subtotaling Data
Using the Advanced Filter Feature
Extracting Data
Using the Automatic Subtotals Feature
Creating PivotTables and

PivotCharts
Introduction to PivotTables and PivotCharts
Creating PivotTables
Modifying PivotTables
Changing PivotTable Field Names and
Functions
Extracting Data from PivotTables
Creating PivotCharts

Formatting and Adjusting
PivotTable
Formatting Numbers in PivotTables
Displaying and Hiding PivotTable Data
Refreshing PivotTable Data
Sorting PivotTable Data
Using the PivotTable AutoFormat Feature

Auditing Worksheets and
Performing What-If Analyses
Introduction to Auditing and
What-If Analyses
Auditing Worksheets
Using the Goal Seek Feature
Using the Solver Feature
Projecting Values

Working with Scenarios
Introduction to Scenarios
Creating Scenarios
Showing Scenarios
Merging Scenarios
Summarizing Scenarios
Editing and Deleting Scenarios
Protecting Scenarios