Course Length: 1 day
Prerequisites: Excel 2003: Level II

This course targets individuals interested in learning the features of Microsoft Excel 2003.

See dates for this class

What’s in Excel 2003 Advanced: Database Management and Analysis?

Excel 2003 Advanced: 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.

 

Working with Databases
Modifying and Finding Database Records

Sorting Database Data
Rearranging Fields
Sorting Text as Numbers
Using the DAVERAGE Function
Using the DMIN Function

Using Advanced Filters and Using the Advanced Filter Feature

Creating PivotTables and Creating PivotTables Functions

Formatting and Adjusting
Displaying and Hiding PivotTable Data
Using the PivotTable AutoFormat Feature
Introduction to Auditing and
Using the Goal Seek Feature

Working with Scenarios
Showing Scenarios
Editing and Deleting Scenarios
Introduction to Databases
Creating and Modifying List Ranges
Introduction to Sorting Database Data
Sorting Records by Four or More Fields

 

 

Using Database Functions
Using the DCOUNT Function
Using the DMAX Function
Automatic Subtotals
Extracting Data

PivotCharts
Modifying PivotTables
Extracting Data from PivotTables
PivotTable
Refreshing PivotTable Data

Auditing Worksheets and What-If Analyses
Using the Solver Feature
Introduction to Scenarios
Merging Scenarios
Protecting Scenarios
Validating Data
Case Study
Sorting Records by up to Three Fields
Applying Custom Sort Orders
Introduction to Database Functions
Using the DSUM Function
Using the DGET Function
Filtering, Extracting and Subtotaling Data
Using the Automatic Subtotals Feature
Introduction to PivotTables and PivotCharts
Changing PivotTable Field Names and
Creating PivotCharts
Formatting Numbers in PivotTables
Sorting PivotTable Data

Performing What-If Analyses
Auditing Worksheets
Projecting Values
Creating Scenarios
Summarizing Scenarios