Microsoft Excel 2003: Level 2

Performance-Based Objectives
Upon successful completion of this course, students will be able to:
*create a project plan file and enter task information.
*create a work breakdown structure by organizing tasks and setting task relationships.
*assign project resources.
*finalize the project plan file.

Course Content

Lesson 1: Creating a Project Plan File
Topic 1A: Create a Project Plan File
Topic 1B: Create and Assign a Project Calendar
Topic 1C: Add Tasks to the Project Plan File
Topic 1D: Add a Project Summary Task
Topic 1E: Add a Recurring Task
Topic 1F: Enter Task Duration Estimates

Lesson 2: Creating a Work Breakdown Structure
Topic 2A: Outline Tasks
Topic 2B: Link Dependent Tasks
Topic 2C: Identify Deliverables in the Project Plan File
Topic 2D: Constrain Tasks
Topic 2E: Set a Task Deadline

Lesson 3: Creating and Assigning Resources
Topic 3A: Create Resources
Topic 3B: Create a Resource Calendar
Topic 3C: Assign Resources
Topic 3D: Assign Additional Resources to a Task
Topic 3E: Resolve Resource Conflicts

Lesson 4: Finalizing the Project Plan
Topic 4A: View the Critical Path
Topic 4B: Shorten the Project Duration
Topic 4C: Set a Baseline
Topic 4D: Display Project Summary Information