عنوان

Excel 2007 for project managers /

شابک

0470047178

شابک

9780470047170

شماره

b716172

عنوان اصلي

Excel 2007 for project managers /

نام عام مواد

[Book]

نام نخستين پديدآور

Kim Heldman, William Heldman.

محل نشرو پخش و غیره

Indianapolis, Ind. :

نام ناشر، پخش کننده و غيره

Wiley Pub.,

تاریخ نشرو بخش و غیره

©2007.

نام خاص و کميت اثر

xv, 344 pages :

ساير جزييات

illustrations ;

ابعاد

24 cm

متن يادداشت

Includes index.

متن يادداشت

Establishing Project Management Fundamentals -- Project Management Institute -- What Is a Project? -- Projects versus Ongoing Operations -- How Projects Come About -- Overview of the Project Process Groups -- Key Project Management Skills -- Project Management Maturity -- Leadership Skills -- Communicating Successfully -- Negotiating and Problem-Solving Skills -- General Management Skills -- Organizing Time and Information -- Professional Responsibility -- Establishing Excel and Office 2007 SharePoint Server Fundamentals -- Using Excel and SharePoint to Manage Projects -- How Excel 2007 and MOSS Support Project Management Processes -- Excel Is a One-Stop Environment For Project Documents -- SharePoint Services -- Office 2007 -- Excel 2007 and Office SharePoint Server 2007 -- Creating a Document Repository -- Setting Up MOSS Page Forms -- Embedded MOSS Form Links -- Populating MOSS with Documentation -- Notifying Users of Document Availability -- Initiating the Project -- Establishing a Project Initiation Process -- Components of the Initiating Process -- The Elements of a Project Request Form -- Establishing the Business Justification -- Creating the Project Request Form using Excel -- Publishing the Project Request Form -- Project Selection Criteria -- Creating a Project Request Tracking Log -- Identifying Stakeholders -- The Role of the Project Sponsor -- Key Stakeholders -- Documenting Key Stakeholders -- Defining Project Goals and Creating the Project Charter -- Principles of Goal Setting -- Project Charter Elements -- Obtaining Approval -- Determining Project Requirements -- Creating the Project Scope Statement -- Essential Elements of the Project Scope Statement -- Determining Deliverables and Acceptance Criteria -- Documenting Requirements -- Remaining Scope Statement Elements -- Creating the Communication Plan -- Determining Communication Needs -- Improving Project Communication with SharePoint and the MOSS -- Reporting and Tracking Project Progress -- Status Reporting -- Creating Reporting Templates with MS Excel -- Action Item Log -- Issues Log -- Planning and Acquiring Resources -- Establishing the Project Team -- Team Member Recruitment -- Stages of Team Development -- Performing a Skills Assessment -- Documenting Roles and Responsibilities -- Creating a Project Organizational Chart -- Motivating Teams -- Adding Team Members to MOSS -- Contact List Update -- Procuring Materials, Supplies, and Equipment -- Creating a Materials List -- Make-or-Buy Analysis -- Soliciting Bids and Proposals -- Selecting a Winner -- Managing Vendors -- Assessing and Tracking Risk -- Identifying Risks -- Identification Techniques -- Common Project Risks -- Creating a Risk Checklist -- Performing Risk Assessment -- Risk Tolerance -- Risk Probability and Impact -- Documenting the Risk Register -- Creating a Risk Register with MS Excel -- Responding to Risk Events -- Risk Response Techniques -- Documenting Risk Response Results -- Updating the Risk Register -- Closing Out Risks -- Quality Management -- Quality Management Plan -- Cost of Quality -- Costs Associated with Cost of Quality -- Cost of Quality Theories -- Determining Quality Metrics -- Benchmarking -- Cost-Benefit Analysis -- Affinity Diagrams -- Pareto Charts -- Scatter Diagram -- Flowcharts -- Control Chart -- Inspection -- Controlling Quality -- Security and Formatting Elements of MOSS -- Information Rights Management (IRM) and Office 2007 -- Digital Signatures -- Constructing the Project Schedule and Budget -- Creating the Work Breakdown Structure (WBS) -- Constructing WBS Levels -- Work Package Level -- Defining Resources for Work Packages -- Estimating Project Tasks -- Expert Judgment -- Top-Down and Bottom-Up Estimating -- Parametric Estimating -- Three-Point Estimates -- Sequencing Tasks -- Determining the Critical Path -- Calculating the Forward Pass -- Calculating the Backward Pass -- Calculating the Critical Path -- Crashing the Schedule -- Determining Resource Availability -- Documenting the Project Schedule -- Milestone Chart -- Project Calendar -- Network Diagram -- Gantt Charts -- Creating the Project Budget -- Budgeting Inputs -- Building Project Budgets -- Elements of a Project Budget -- Estimating Budget Items -- Determining and Monitoring Performance Measures -- Cost and Schedule Variance -- Performance Indexes -- Establishing Change Control Processes -- When Change Occurs -- Reasons for Change -- Dealing with Change -- Creating a Change Control Process -- Level of Authority -- Emergency Requests -- Escalation Process -- Creating Change Control Forms -- Change Request Form -- Change Request Log -- Converting Tables to Ranges -- Reporting and Printing Change Control Data -- Assessing the Impacts of Change -- Establishing a Change Control Board -- CCB Procedures -- Project Manager's Role on the CCB -- Independent Verification and Validation -- Windows SharePoint Services Templates -- Accessing Templates in MOSS -- Subsite Creation -- Controlling Project Outcomes and Archiving Documents -- Performing the Work of the Project -- Monitoring and Controlling the Work of the Project -- Schedule and Budget Monitoring -- Monitoring Risk -- Procurement Monitoring -- Monitoring Vendors and Contracts -- Change Request Monitoring -- Team Member Monitoring -- Taking Corrective Action -- Schedule Actions -- Budget Actions -- Personnel Actions -- Contract Actions -- Signs of Project Trouble -- Accepting Project Deliverables -- Notifying Stakeholders of Project Acceptance -- Closing Out the Contract -- Documenting Lessons Learned -- Releasing Team Members -- Archiving Project Documents -- Backing Up the MOSS Server -- Celebrate -- Excel Function Junction -- Leveraging Excel Functions Using Excel Services -- Calculating Various Workbook Elements and Publishing to MOSS -- Using Excel Functions to Enhance Project Management Productivity -- Function Groups -- Functions for the Project Manager -- VBA, Macros, and Other Ways to Automate Excel -- Consolidating Sheets -- Cubes/Pivot Tables.

بدون عنوان

0

عنوان اصلي به زبان ديگر

Microsoft Office

موضوع مستند نشده

Microsoft Excel (Computer file)

موضوع مستند نشده

Microsoft Excel (Computer file)

موضوع مستند نشده

Business-- Computer programs, Handbooks, manuals, etc.

موضوع مستند نشده

Electronic spreadsheets, Handbooks, manuals, etc.

موضوع مستند نشده

Business-- Computer programs.

موضوع مستند نشده

Electronic spreadsheets.

شماره

ويراست

شماره رده

نشانه اثر

مستند نام اشخاص تاييد نشده

Heldman, Kim.

مستند نام اشخاص تاييد نشده

Heldman, William.

تاريخ عمليات

20201208062115.0

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y