|
" Excel 2007 for project managers / "
Kim Heldman, William Heldman.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
961802
|
| Doc. No
|
:
|
b716172
|
| Main Entry
|
:
|
Heldman, Kim.
|
| Title & Author
|
:
|
Excel 2007 for project managers /\ Kim Heldman, William Heldman.
|
| Publication Statement
|
:
|
Indianapolis, Ind. :: Wiley Pub.,, ©2007.
|
| Page. NO
|
:
|
xv, 344 pages :: illustrations ;; 24 cm
|
| ISBN
|
:
|
0470047178
|
|
|
:
|
: 9780470047170
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
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.
|
| Subject
|
:
|
Business-- Computer programs, Handbooks, manuals, etc.
|
| Subject
|
:
|
Electronic spreadsheets, Handbooks, manuals, etc.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
|
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
658.4/040285554
|
| LC Classification
|
:
|
HF5548.4.M523H455 2007
|
| Added Entry
|
:
|
Heldman, William.
|
| Parallel Title
|
:
|
Microsoft Office
|
| |