Microsoft Office Excel 2007 for Project Managers

by Sybex

Product Description

Product Description

Combine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to boost your skill set and maximize your productivity. You’ll walk through a project and learn 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. --This text refers to the Paperback edition.

From the Back Cover

Maximize Your Productivity with these Project Management Tools and Skills

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. As a bonus, Excel templates and checklists are available online that you can apply to your next project.

• 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

Valuable extras online!

Visit www.sybex.com/go/exelpm for bonus Excel templates and checklists you can use immediately. --This text refers to the Paperback edition.

See all Product Description

Product Details

• Product Dimensions: 7.4 x 0.8 x 9.2 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Domestic Shipping: Item can be shipped within U.S.
• International Shipping: This item is not eligible for international shipping. Learn More
• ASIN: B000NVJME6
• Average Customer Review: 2.0 out of 5 stars  See all reviews (4 customer reviews)

Top Customer Reviews

28 of 29 people found the following review helpful

1.0 out of 5 stars This book is terrible November 1, 2007

By Mark A. Parrish

Format:Paperback

As a PMP, and a Wiley customer for years I find that this book provides me with no value and is a big disappointment. Clearly it was not written by project managers that would use this in the real world since the samples do not even work in calculating the sheets properly!!

This book doesn't tell you how to do the forms in Excel but shows you a form and says what it does. Wow would that be nice if a book on Excel taught you how to create the form with Excel. These are forms that could have been done in Word! There is nothing in this book that requires Excel. And even less to do with Sharepoint.

The calculations are simplistic on the workbooks and not checked. Just sums and averages. The book is full of errors that refer to things that are not in the examples and cannot be followed. IF THE AUTHORS WERE PM's THEY WOULD HAVE CHECKED THEIR WORK!!!

The downloaded samples that come from the website are horrible and only provide basic data that you can set up on your own. They conveniently left out the gantt chart from the samples that come with the book. The reason I purchased it, since it looked most promising. Also the charts and many others are not included even though the cover says all are provided.

The network diagrams do not take into account dependencies when figuring forward and backward passes. And they refer to data not in the sample graphic.

Do not buy this book. It is really bad and not for project managers.

9 of 9 people found the following review helpful

1.0 out of 5 stars Terrible August 4, 2008

By A C Petitt

Format:Paperback|Verified Purchase

I am a certified PMP and own many books on Project management. The book is very misleading in terms of excel and Project Management. Three fourths of the book explains what Project Management is. I found more useful templates from Microsoft. Also the included templates the book provides online are exraordinarily rudimentary.

2 of 2 people found the following review helpful

1.0 out of 5 stars More Sharepoint than Excel... Disappointing. October 15, 2010

By tjw

Format:Paperback

Very disappointing. I'd guess 70% deals with Sharepoint & MOSS, rather than Excel. The PM discussions are a mix of PMP/PMBOK and overly-simplistic management guidelines. Most EXCEL techniques & how-to can be found by easy web search.

5 of 10 people found the following review helpful

5.0 out of 5 stars One of the best books we've seen May 7, 2007

By Midwest Book Review

Format:Paperback

Combine the forces of Excel 2007, Microsoft Office SharePoint Server and other tools to build a project step by step using Excel 2007 for Project Managers, an outstanding manual which blends key management skills and needs with Excel and other standard office routines. From setting up schedules and budgets to using network diagrams, scatter charts, and assigning teams through Excel, Excel 2007 for Project Managers represents one of the best books we've seen blending project manager objectives with real-world applications in the Excel 2007 environment.