Excel 2000: Module III - Database Management and Analysis
Course Summary

Lesson 1: Working with Databases

Approximate Time: 35

Exercise File(s) Needed: 3Saturn1.xls, 3Zenith1.xls, and 3Zenith2.xls

Summary of Objectives: Students define database components, add database components, and modify database records

Lesson 2: Sorting Database Data

Approximate Time: 30

Exercise File(s) Needed: 3Saturn2.xls, 3Zenith3.xls, and 3Zenith4.xls

Summary of Objectives: Students sort records from top to bottom, sort field data from left to right, sort by four or more columns, and specify custom sort orders

Lesson 3: Using Database Functions

Approximate Time: 30

Exercise File(s) Needed: 3Saturn3.xls, 3Zenith5.xls, and 3Zenith6.xls

Summary of Objectives: Students use the DAVERAGE function, use the DCOUNT and DSUM functions, use the DMIN and DMAX functions, and use the VLOOKUP function

Lesson 4: Using Filters and Queries

Approximate Time: 50

Exercise File(s) Needed: 3Saturn4.xls, 3Saturn Inventory1.mdb, 3Zenith7.xls, 3Zenith8.xls, and 3Zenith Instructors1.mdb

Summary of Objectives: Students use the AutoFilter feature, use the Advanced Filter feature, extract data, work with extracted data, query an external database, and work with queried data

Lesson 5: Using Automated Features

Approximate Time: 30

Exercise File(s) Needed: 3Saturn5.xls, 3Zenith9.xls, and 3Zenith10.xls

Summary of Objectives: Students use the Automatic Subtotals feature, use conditional formatting, and use the AutoFormat feature

Productivity Builder 1

Approximate Time: 35

Exercise File(s) Needed: 3Saturn Personnel1.xls and 3Saturn Personnel2.xls

Lesson 6: Using PivotTables

Approximate Time: 35

Exercise File(s) Needed: 3Saturn6.xls, 3Zenith11.xls, and 3Zenith12.xls

Summary of Objectives: Students create PivotTables, edit PivotTables, use PivotTable AutoFormat, change PivotTable field names and functions, and format numbers in PivotTable fields

Lesson 7: Modifying PivotTable Data

Approximate Time: 20

Exercise File(s) Needed: 3Saturn7.xls, 3Zenith13.xls, and 3Zenith14.xls

Summary of Objectives: Students delete PivotTable data, display and hide PivotTable data, refresh PivotTable data, sort PivotTable data, and use the GETPIVOTDATA function

Lesson 8: Using Advanced Data Analysis to Audit Worksheets

Approximate Time: 35

Exercise File(s) Needed: 3Saturn8.xls, 3Expenses1.xls, and 3Expenses2.xls

Summary of Objectives: Students trace precedents, dependents, and errors, remove arrows, find cells with specific characteristics or entries, use the Goal Seek feature, and use the Solver feature

Lesson 9: Working with Scenarios

Approximate Time: 30

Exercise File(s) Needed: 3Saturn9.xls, 3Student1.xls, and 3Student2.xls

Summary of Objectives: Students create scenarios, display scenarios, edit and delete scenarios, protect scenarios, and create scenario summary reports

Lesson 10: Creating Reports

Approximate Time: 30

Exercise File(s) Needed: 3Saturn10.xls, 3Student3.xls, and 3Student4.xls

Summary of Objectives: Students create custom reports, print custom reports, and create PivotChart reports

Productivity Builder 2

Approximate Time: 35
Exercise File(s) Needed: 3Avant1.xls and 3Avant2.xls
Total Exercise File Size for Course: 742 kB
Approximate Length of the Course: 6 hours 35 minutes

Responsibility of the Student

Each student must study all information learned in the course after normal classroom hours so that he/she may gain a firmer grasp of the information covered.  This allows students to detect any weak areas that they may have and enables them to seek out the assistance of the instructor

Back to Course Outlines