How to create your own PMP Application Worksheet

You have multiple projects you want to include in your application for the PMP(r). However, you are having trouble organizing your thoughts. Create a PMP(r), Application Worksheet in Excel. Here’s how to do it in excel step by step.
Step 1: Open an Excel document and list the project name and start and end dates. It should look something like this:
Step 2: Under the column “Project Title”, list all projects you have managed. As much as possible, try to organize your projects chronologically. In this example, we will keep it simple and simply call the project 1, 2, 3 etc.

Step 3: Create new tabs equal in number to the projects you have listed. If you have 10 projects, you should create 10 tabs. It should look something like this when you are done:

Step 4) Fill in the ‘Start Date” and ‘End Data’ columns. You must ensure that all cells are in Date format. You can check by right clicking on the cell and selecting ‘Format cells’. Your spreadsheet should look something like this once you’re done.

Step 5: To calculate how many months of experience you have, first find your minimum start date. Then, find your maximum end date. Add the dates together and divide by 30. Because there are approximately 30 days in a monthly calendar, you will need to divide by 30.

To be eligible for the PMP(r), you must have at least 3 years of experience if you have a university degree or equivalent.
PMI does not double-count the time if you manage multiple projects simultaneously. PMI counts 8 months of work experience if Project 1 was run from Jan 1, 2014 to Aug 1, 2014. Project 2 was run from February 1, 2014 to May 1, 2014. PMI does not count this as 8+3=11 month! Because Project 2 occurred within the same time frame as Project 1.
Step 6: Fill in the hours spent on each project within each of the five Process Groups. Next, add up the hours spent on each project and then sum them up across each process group. Once you have completed this step, you can close the summary tab.

To pass the PMP(r), you must have worked at least 4500 hours.
Step 7: Create a new tab for each project you have listed (we did this step 3), and fill in some information about the project.
Click on the “Project 1” tab and create a form that looks something like the following:

The good news is that you can reuse this form for any future projects.
Step 8: Before you submit your application, contact all your contacts within your organization. You will need to tell them 1) how much time you spent on each process group and 2) what your project description is. If your contact refuses to sign off on the documentation, you could be in serious trouble.
Step 9: Write a brief summary of the project. This section is usually the most difficult for students, as it is hard to reduce years of experience down only 550 characters.
The summary of each process group’s tasks can help you to write your description. This will give an idea of the type activities PMI is looking to see in your application. This summary will help you get started.
InitiatingDevelop project charter; Identify risks, assumptions and constraints; Identify stakeholders, Define high-level scope; Perform project assessmentPlanningPresent project plan to stakeholders; Develop project schedule, budget, and other management plans; Develop WBS; Define scope; Prepare project plansExecutingCommunicate with stakeholders; Implement approved changes; Execute tasks defined in the project plan; Obtain and manage resourcesMonitoring & ControllingAssess results of corrective action; Ensure quality standards are met; Manage changes to scope, schedule, and budget; Measure project performanceClosingArchive documents; Measure customer satisfacti

Author: Victoria