Overview/Description Project managers often share Project 2007 data with other applications, such as Microsoft Excel and Microsoft Outlook. When importing and exporting information in this way, the information must first be sorted, filtered, and grouped to customize the information's appearance. Information also needs to be timely – actual work performed, actual start and finish dates, and actual costs must all be updated. This course outlines the basics of importing and exporting, sorting, filtering, and grouping information to meet a project's needs. It also discusses creating and sharing...

Overview/Description Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying...

Overview/Description To use SharePoint for file sharing, collaboration, and discussion, and integrate and use it with Office applications Target Audience End users of Office SharePoint Server 2007 Prerequisites A basic understanding of how to use Internet Explore 7 and basic word-processing skills Expected Duration (hours) 2.8 Lesson ObjectivesSharePoint 2007 Essentials distinguish between sites, workspaces, and pages, and create lists and libraries. add new files to SharePoint, check files in and out of it, and set an alert for the document library. add lists, files, and alerts in SharePoint...

Overview/Description In Microsoft Office Project 2007, people, equipment, and materials are collectively referred to as "resources." A large part of a project manager's responsibilities is managing these resources, whether that be assigning resource work times, leveling resources that are overallocated, and overseeing the budgeting and costs of resources. This course provides an overview of resource management for projects, and will help you get to grips with Microsoft Office Project 2007's robust resource management tools. Target Audience Business managers, project managers, planners, and...