Excel 2007 for Project Managers	5
	Acknowledgments	7
	About the Authors	8
	Contents at a Glance	9
	Contents	10
	Introduction	15
	Chapter 1: Establishing Project Management Fundamentals	19
	Project Management Institute	20
	What Is a Project?	21
	Key Project Management Skills	28
	Chapter 2: Establishing Excel and Office 2007 SharePoint Server Fundamentals	41
	Using Excel and SharePoint to Manage Projects	42
	Creating a Document Repository	55
	Chapter 3: Initiating the Project	67
	Establishing a Project Initiation Process	68
	Identifying Stakeholders	90
	Defining Project Goals and Creating the Project Charter	93
	Chapter 4: Determining Project Requirements	99
	Creating the Project Scope Statement	100
	Creating the Communication Plan	118
	Reporting and Tracking Project Progress	122
	Chapter 5: Planning and Acquiring Resources	137
	Establishing the Project Team	138
	Procuring Materials, Supplies, and Equipment	160
	Chapter 6: Assessing and Tracking Risk	167
	Identifying Risks	168
	Performing Risk Assessment	173
	Documenting the Risk Register	178
	Responding to Risk Events	189
	Chapter 7: Quality Management	195
	Quality Management Plan	196
	Cost of Quality	198
	Determining Quality Metrics	199
	Controlling Quality	215
	Security and Formatting Elements of MOSS	215
	Chapter 8: Constructing the Project Schedule and Budget	229
	Creating the Work Breakdown Structure (WBS)	230
	Estimating Project Tasks	233
	Sequencing Tasks	236
	Determining the Critical Path	238
	Determining Resource Availability	241
	Documenting the Project Schedule	245
	Creating the Project Budget	249
	Determining and Monitoring Performance Measures	255
	Chapter 9: Establishing Change Control Processes	263
	When Change Occurs	264
	Creating a Change Control Process	266
	Creating Change Control Forms	268
	Assessing the Impacts of Change	281
	Establishing a Change Control Board	283
	Independent Verification and Validation	284
	Windows SharePoint Services Templates	285
	Accessing Templates in MOSS	287
	Subsite Creation	289
	Chapter 10: Controlling Project Outcomes and Archiving Documents	293
	Performing the Work of the Project	294
	Monitoring and Controlling the Work of the Project	295
	Taking Corrective Action	300
	Signs of Project Trouble	309
	Accepting Project Deliverables	310
	Notifying Stakeholders of Project Acceptance	311
	Closing Out the Contract	312
	Documenting Lessons Learned	312
	Releasing Team Members	315
	Archiving Project Documents	315
	Appendix A: Excel Function Junction	321
	Leveraging Excel Functions Using Excel Services	322
	Calculating Various Workbook Elements and Publishing to MOSS	326
	Using Excel Functions to Enhance Project Management Productivity	335
	VBA, Macros, and Other Ways to Automate Excel	342
	Consolidating Sheets	348
	Cubes/Pivot Tables	350
	Index	353