MICROSOFT PROJECT ADVANCED

---

DESCRIPTION

Even experienced project managers need help making the most of the tools at their disposal. Project managers at every level are asked to manage projects with short schedules, tight budgets, and scarce resources. This hands-on course focuses on the critical planning stage of a project and how to set a project up for success. Hands-on exercises with Microsoft Word and Project will demonstrate effective and easy-to-implement techniques to better plan schedule and allocate resources. The goal of this course is to enable project managers to increase their productivity, which means they have more time to stay on top of the critical project management tasks that increase the chances of project success.

WHAT YOU WILL LEARN

• Develop the planning and control tool in managing project
• Documenting the Project with software
• Integrating within the functioning departments
• Keep projects up to date with project updating tools
• Track resources ie. Costs, materials, manpower, time with project tracking tools
• Take advantage of project versatile views to get the big picture
• Anticipate and avoid potential problem before it occurs
• Fulfilling the expectation of stakeholders and clients
• Explain how effective project plans facilitate project success
• Quickly set up project plans that communicate key project information to the entire project team
• Develop schedules in Microsoft Project that communicate the project tasks effectively and accurately.
• Assign resources to tasks to obtain the desired results

WHO SHOULD ATTEND

This course is designed for career project managers and those professionals for whom project management is an integral part of their daily jobs, and who have a vested interest in improving the effectiveness of project management and the success of projects – often under complex or difficult circumstances. This audience has experience managing projects, but is looking to enhance its project management skills and its ability to handle more concurrent projects or to manage larger and more complex projects. 

DURATION

2 Days

SPEAKER

Abu Sapian Suhaimi

CONTENT

Custom Filters and Groups
Creating custom filters
Filtering using calculations
Creating custom groups
Custom Calculated Fields
Creating custom fields
Calculated custom fields
Using custom indicators
Custom Tables and Views
Creating a table
Creating a view
Forms
Creating a form
Add a form icon to a toolbar
Creating a report
Budgeting Resources
Creating and tracking resource budgets
Managing Resources and Costs
Creating work & material resources
Working with multiple calendars
Assigning resources
Effort Driven Scheduling
Task Types
Working with resource costs and fixed costs
Work contours
Assigning multiple arbitrary costs to tasks
Identifying budget variance
Finalising the Plan
Reviewing the schedule
Leveling resource over-allocation
Tracking
Creating baselines
Entering project progress
Viewing variance information
Analyse and adjust a schedule
Analysing schedules
Reschedule the project
Adjustment of resource schedules
Progress lines
Filters and sort
Working with auto filters
Applying built-in filters
Sorting and grouping data
Visual reporting
Using, modifying and creating visual reports
PERT Analysis
Using PERT to estimate task durations
Analyse Project Data using Excel
Creating custom export maps
Creating PivotTables from project data
Macro Features
Recording a macro
Running a macro
Assigning macros to toolbars
Manage multiple projects
Consolidating and sharing projects
Resource pools: Sharing resources across projects
Leveling and reporting across multiple projects
Exchange project data
Import, export and copy data from Microsoft Excel
Case Study
The case study is based on the actual from the clients office

---