Download - Microsoft Excel to Project in 5 Easy Steps
![Page 1: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/1.jpg)
C D H
C D HFrom Excel to Project in 5
Easy Steps
April 2012
![Page 2: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/2.jpg)
C D H Quick Facts
About Us• 22nd Year• Grand Rapids &
Royal Oak• 30 Staff
Approach• Vendor
Independent• Non-reseller• Professional
Services Only
Partnerships• Microsoft Gold• VMware Enterprise• Citrix Registered• Novell Gold• Cisco Premier
![Page 3: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/3.jpg)
C D H Expertise
![Page 4: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/4.jpg)
C D H Get Social with C/D/H
C/D/H Talks Tech C/D/H Tweets Tech
![Page 5: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/5.jpg)
C D HC/D/H Project Management
Expertise
• C/D/H Project Management Group– Six active members – PMI certified– Experience in Microsoft Enterprise
Management approach– Experience in multiple project management
tools and methodologies– Experience in PMO development and
operations
![Page 7: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/7.jpg)
C D H Agenda
• Introduction• General Project Management Discussion• Microsoft Project Tools• Project Management - Tasks
– Work breakdown structure– Task assignment – Resource scheduling– Critical path analysis– Cost estimating
• Q&A
![Page 8: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/8.jpg)
C D H What is a “Project”?
“A project is a temporary endeavor undertaken to create a unique product, service or result.”
Source:A guide to the project management body of knowledge (PMBOK Guide) Fourth Edition
![Page 9: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/9.jpg)
C D H
1910s 1950s 1960s 1970s 1980s 1990s 2000s
(1861–919)The Gantt Chart developed by Henry Laurence Gantt
(1950s)The Critical path method (CPM) invented
(1958)The Program Evaluation and Review Technique (PERT) method invented
(1969)Project Management Institute (PMI) established
(1975)PROMPTII methodology created by Simpact Systems
(1986) Six Sigma Methodology
(1987)First PMBOKGuide published
(1989)PRINCE method derived from PROMPTII is published by the U.K. Government
(2002) Portfolio Management Techniques
(1995)Agile Project Management
Project Management Evolution
![Page 10: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/10.jpg)
C D H Project Management
• Projects in one form or another have been undertaken for a millennia
• Gantt Chart first developed in 1920• The latter half of the 20th century people
started to talk about “Project Management”
![Page 11: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/11.jpg)
C D H Why Project Management
• Project and Portfolio Management helps organizations gain visibility and control across all work, enhancing decision-making, improving alignment with business strategy, maximizing resource utilization, and enhancing project execution.
![Page 12: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/12.jpg)
C D H The Business Needs
Align work with strategic objectives
Manage projects and resources effectively
Gain visibility and control over projects
Rationalize investment
![Page 13: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/13.jpg)
C D H Microsoft Project - Tools
• Target Audience:– Excel 2010
– “Accidental” Project Managers
– Project Standard 2010• Individuals and Part Time Project Managers
– Project Professional 2010• Full Time Project Managers
– Project Server 2010• IT, PMO, Engineering R&D, Product Development,
Operations
![Page 14: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/14.jpg)
C D H Microsoft Excel 2010
• Microsoft Excel 2010 gives basic data list capabilities– Listing of activities– Listing of resources– Listing of budget– Listing of …..
![Page 15: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/15.jpg)
C D H Microsoft Project Standard 2010
• Microsoft Project Standard 2010 delivers powerful, visually enhanced ways to manage a wide range of projects.
![Page 16: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/16.jpg)
C D H Microsoft Project Professional 2010
• Microsoft Project Professional 2010 gives you a powerful, visually enhanced way to effectively manage a wide range of projects and programs.
• Provides integration capabilities with: SharePoint, Team Foundation Server and Project Server.
![Page 17: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/17.jpg)
C D H Microsoft Project Server 2010
• Microsoft Project Server 2010 builds upon the Microsoft SharePoint Server 2010 platform.
• Provides a basis for Project Web App pages, site administration, project workspaces, and authentication infrastructure for Project Server users.
• Provides portfolio tracking and planning.
![Page 18: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/18.jpg)
C D HMicrosoft Project Management
Overview
• Microsoft Project History– 1984 – Original version DOS based– 1986 – Version 4 (Final DOS based version)– 1990 – Version 1 for Windows– 1991 – MAC version released– No version 2 for Windows ever released– 1993 – Last MAC version (Project 4) released– Current version is 14th release– Version 15 TBD…
![Page 19: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/19.jpg)
C D HYou Just Might Be a Project
Manager
“If you're 6 months late on a milestone due next week but really believe you can make it, you just might be a project manager.”
(Apologies to Jeff Foxworthy)
![Page 20: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/20.jpg)
C D H Project Management
• Work breakdown structure• Task assignment • Resource scheduling• Critical path analysis• Cost estimating
![Page 21: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/21.jpg)
C D H Project Management - WBS
• Work breakdown structure• Task assignment • Resource scheduling• Critical path analysis• Cost estimating
![Page 22: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/22.jpg)
C D H Work Breakdown Structure
• Work Breakdown Structure– According to the PMBOK is defined as “the
process of subdividing project deliverable and project work into smaller more manageable components.”
– Done in Excel can be a list of activities that need to be accomplished
– Done in Project is manageable and can be used as a tool in Project Management
![Page 23: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/23.jpg)
C D H Work Breakdown - Excel
Line # Description Est. # of
hours Comments
1 Project Management2 Time required by C/D/H project manager and all C/D/H team member
time for status meetings, general communication and project collaboration
3 Project initiating tasks including internal prep meeting and establishment of project management plan
2.0
4 Project kick-off meeting 2.0 2 CDH Staff members @ 1 hour per
5 Project planning tasks including build of initial project plan and schedule
1.0
6 Weekly project status meetings 2.0
7 Monitoring and controlling activities including issuance of regular project communications, budget monitoring and reporting, project plan updates and project change control
2.0
8 Project closure tasks including preparation and issuance of final project documents and other tasks as needed
1.0
9 Project closure meeting 2.0 2 CDH Staff members @ 1 hour per
![Page 24: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/24.jpg)
C D H Work Breakdown – Project
![Page 25: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/25.jpg)
C D H Project Management - Tasks
• Work breakdown structure
• Task assignment • Resource scheduling• Critical path analysis• Cost estimating
![Page 26: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/26.jpg)
C D H Task Assignment
• Task Assignment– Done in Excel lists resources that can be
applied to a task – Done in Project is manageable and can be
used as a tool to track and monitor resource utilization
![Page 27: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/27.jpg)
C D H Task Assignment - Excel
Task Description Assigned to: Service Area
4th BGP Peer - Nov. 29th. Joe will not be onsite but Erik will be.
Joe - Information Technology Erik -Information Technology
Network Infrastructure
802.11n deployment for Corp Paul - Information Technology
Computer Operations, Network Infrastructure
Active Directory AuditPerform an annual audit of Active Directory to identify user access
Computer Operations
Add security to the Media (AV) WLANCurrently there is no authentication or encryption on the media WLAN.
Pat - Information Technology
Computer Operations, Network Infrastructure
![Page 28: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/28.jpg)
C D H Task Assignment - Project
![Page 29: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/29.jpg)
C D H Task Assignment - Project
![Page 30: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/30.jpg)
C D H Task Assignment - Project
![Page 31: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/31.jpg)
C D HProject Management - Resource
Scheduling
• Work breakdown structure• Task assignment
• Resource scheduling• Critical path analysis• Cost estimating
![Page 32: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/32.jpg)
C D H Resource Scheduling
• Resource scheduling– Excel is a great spreadsheet program but it is
not made for planning and scheduling– Excel provides limited Gantt Chart
development– Project allows visibility into task calendars and
resource allocation
![Page 33: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/33.jpg)
C D H Resource Scheduling - ExcelResource Name Work
Douglas J. MacNEIL 15.2 hrsProject initiating tasks including internal prep meeting and establishment of project management plan 2 hrs
Project kick‐off meeting 0.4 hrsProject planning tasks including build of initial project plan and schedule 1 hrWeekly project status meetings 0.4 hrsMonitoring and controlling activities including issuance of regular project communications, budget monitoring and reporting, project plan updates and project change control 2 hrs
Project closure tasks including preparation and issuance of final project documents and other tasks as needed 1 hr
Project closure meeting 0.4 hrsOther projects and commitments 8 hrs
Polly C. Corbett 169.8 hrsProject kick‐off meeting 1.6 hrsWeekly project status meetings 1.6 hrsProject closure meeting 1.6 hrsDevelop Exchange design and migration plans 16 hrsBuild new Exchange 2010 server hosting CAS, HUB, and mailbox roles 36 hrsCreate Cisco ASA network translation and access list. Create legacy URL and update SSL. Test Exchange connectivity for ActiveSync, OWA, and Outlook Anywhere. 18 hrs
Test co‐existence between Exchange Server 2003 and Exchange Server 2010 4 hrsMigrate pilot group from Exchange 2003 to Exchange 2010 48 hrsOther projects and commitments 0 hrs
Pat Jones 16 hrsCreate virtual machine for Exchange Server 2010 16 hrs
Erik Gilreath 24 hrsCreate Cisco ASA network translation and access list. Create legacy URL and update SSL certificate. 24 hrs
![Page 34: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/34.jpg)
C D H Resource Scheduling - Project
![Page 35: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/35.jpg)
C D H Resource Scheduling - Project
![Page 36: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/36.jpg)
C D H Project Management – Critical Path
• Work breakdown structure• Task assignment • Resource scheduling
• Critical path analysis• Cost estimating
![Page 37: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/37.jpg)
C D H Critical Path
• The critical path is the series of tasks (or even a single task) that dictates the calculated project start or finish date
• If a single task is late on the critical path, the end date of the entire project will also be late
![Page 38: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/38.jpg)
C D H Critical Path
• Critical Path Analysis– Excel allows listing of tasks but offers no
assistance with identification and tracking of critical path
– Project allows visibility into the critical path• Highlight the critical path• Show only the critical path• Show a single critical path for multiple projects• Calculate multiple critical paths
![Page 39: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/39.jpg)
C D H Critical Path - ExcelLine
# Description Est. # of hours Comments
1 Project Management2 Time required by C/D/H project manager and all C/D/H team member time
for status meetings, general communication and project collaboration
3 Project initiating tasks including internal prep meeting and establishment of project management plan
2.0
4 Project kick-off meeting 2.0 2 CDH Staff members @ 1 hour per
5 Project planning tasks including build of initial project plan and schedule
1.0
6 Weekly project status meetings 2.0
7 Monitoring and controlling activities including issuance of regular project communications, budget monitoring and reporting, project plan updates and project change control
2.0
8 Project closure tasks including preparation and issuance of final project documents and other tasks as needed
1.0
9 Project closure meeting 2.0 2 CDH Staff members @ 1 hour per
![Page 40: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/40.jpg)
C D H Critical Path - Project
![Page 41: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/41.jpg)
C D H Critical Path - Project
![Page 42: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/42.jpg)
C D H Critical Path - Project
![Page 43: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/43.jpg)
C D H Project Management - Costs
• Work breakdown structure• Task assignment • Resource scheduling• Critical path analysis
• Cost estimating
![Page 44: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/44.jpg)
C D H Cost Estimating
• Cost estimating– Excel allows cost rollup and what if scenarios
with extensive development– Project allows presentation of costs and
budgets from stock reports and offers multiple rates and ability to factor in overtime rates
![Page 45: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/45.jpg)
C D H Cost Estimating - Excel
![Page 46: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/46.jpg)
C D H Cost Estimating - Project
![Page 47: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/47.jpg)
C D H Cost Estimating - Project
![Page 48: Microsoft Excel to Project in 5 Easy Steps](https://reader033.vdocuments.us/reader033/viewer/2022052523/55661185d8b42a06318b4c96/html5/thumbnails/48.jpg)
C D H
Royal Oak306 S. Washington Ave.Suite 212Royal Oak, MI 48067(248) 546-1800
Thank You
Grand Rapids15 Ionia SWSuite 270Grand Rapids, MI 49503(616) 776-1600
(c) C/D/H 2007. All rights reservedwww.cdh.com