Untitled document
The student will be able to:
1. Describe the characteristics of a database
2. Sort database data
3. Use database functions; DAVERAGE, DCOUNT, and DMAX
4. Use filters to select data from the database
5. Apply conditional formatting using a simple condition
6. Create a pivot table from Excel data
7. Modify pivot table data
8. Use data analysis to audit worksheets
9. Apply scenarios
10. Create reports
Untitled document
1. Working with Databases
A. Defining database components
B. Adding database components
C. Modifying database records
2. Sorting Database data
A. Sorting records from top to bottom
B. Sorting records from left to right
C. Sorting by four or more columns
D. Specifying custom sort orders
3. Using Database Functions
A. Using the DAVERAGE function
B. Using the DCOUNT and DSUM functions
C. Using the DMIN and DMAX functions
4. Using Filters
A. Using the AutoFilter feature
B. Using the Advanced Filter feature
C. Extracting data
D. Working with extracted data
5. Using Automated Features
A. Using the Automatic Subtotals feature
B. Using Conditional formatting
C. Using the AutoFormat feature
6. Using Pivot Tables
A. Creating pivot tables
B. Editing pivot tables
C. Formatting numbers in pivot table fields
7. Modifying Pivot Table Data
A. Deleting pivot tables
B. Refreshing pivot table data
C. Sorting pivot table data
8. Using Advanced Data Analysis to Audit Worksheets
A. Tracing precedents, dependents, and errors
B. Finding cells with specific content
C. Using the Goal Seek feature
9. Working with Scenarios
A. Creating scenarios
B. Editing and deleting scenarios
C. Creating scenario summary reports
10. Creating Reports
A. Creating custom reports
B. Printing custom reports
Untitled document
Excel, Module 3, ComputerPrep, 1998