Excel 2003 Module III: Learning Guide w/ CD-ROM. No. PCLO1-MO3EX3-PR-503 Ver. 2.0.rd022205 Spiral-Bound. ISBN: 0742325601 (New In Stock). Save over 50% cost. Database Management Analysis - Student Guide. 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.

This coursebook includes a supplemental CD-ROM containing the lab files used in class. To practice the skills presented in class or to try any labs that were not completed, refer to the Classroom Setup section for information about system requirements and using the lab files.

Course Objectives:

After completing this course, you will be able to:
- Validate data.
- Modify and find database records.
- Create and modify list ranges.
- Sort records based on one criterion at a time, and based on multiple criteria.
- Rearrange database fields.
- Apply custom sort orders to database records.
- Use the DAVERAGE, DCOUNT, DSUM, DMIN, DMAX and DGET functions.
- Use the Advanced Filter feature to filter and extract database records.
- Use the Automatic Subtotals feature to perform summary database calculations.
- Create and modify PivotTables and PivotCharts.
- Extract data from PivotTables.
- Format numbers in PivotTables.
- Display, hide, refresh and sort PivotTable data.
- Use the PivotTable AutoFormat feature.
- Audit worksheets.
- Use the Goal Seek and Solver features.
- Project values.
- Create, show, merge, summarize, edit, delete and protect scenarios.


Product Details:

Brand: ComputerPrep
Publisher: Philip DeWald
Item No.:PCLO1-MO3EX3-PR-503
Version: 2.0.rd022205
Binding: Spiral-Bound
Course Time: 6 Hour
MPN: PCLO1-MO3EX3-PR-503
ISBN: 0742325601
UPC: 9780742325609
Condition: New In Stock
Qty In Stock: 3

:: Original Price: $29.99
:: Our Price: $14.49

L09_01_12-1-12