Microsoft Office Excel 2007 for Project Managers

Combine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to bring added value to your skill set. You'll walk through a project and learn step by step how to use these powerful tools to schedule jobs, create budgets, manage processes, and share project information. Whether new to project management or a veteran, you'll discover techniques, hints, and examples you can use immediately.

• Master the fundamentals of Microsoft Excel 2007 and SharePoint Server
• Review key management skills such as communication and negotiation
• Define project goals and create a Project Charter
• Learn the five steps of the project management process
• Set up schedules, estimates, and budgets using Excel 2007
• Create Gantt charts, network diagrams, and scatter charts
• Assign teams, handle changes, and take corrective action
• Publish and archive project information using SharePoint

About the Authors

Kim Heldman, the chief information officer for the Colorado Department of Natural Resources, has more than 16 years of project management experience in the information technology field. She’s managed small, medium, and large projects over the course of her career and shares her breadth of experience and knowledge in her books through examples, stories, and tips.

Kim is the best-selling author of several other project management books, including PMP Project Management Professional Study Guide, Third Edition (Sybex, 2005); Project Manager’s Spotlight on Risk Management (Sybex, 2005); and Project Management JumpStart (Sybex, 2005).

Bill Heldman is a computer technology instructor at a Career and Technical Education (CTE) high school in Lakewood, Colorado, where he teaches 11th- and 12th-graders on a variety of topics, including programming (application and game), networks, A+, project management, security, databases, and TCP/IP. Bill has 20 years of experience in the computer technology field, starting with mainframe computing and working through programming, networks, and enterprise application software. He has worked as a technician, supervisor, and mid-manager in both public and private-sector information technology organizations.

Bill has written numerous certification study guides for Sybex. He is also a frequent contributor to Microsoft Certified Professional (MCP) Magazine and its cousin, Redmond Magazine, as well as Windows IT Pro magazine.