WHAT YOU WILL LEARN
|
WHO SHOULD ATTENDThis 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.
DURATION2 Days
SPEAKERAbu 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 |