OnePager Pro works with Microsoft Project to combine multiple projects into a single portfolio view which can be used to present to clients or executives. Here's how to get started:
- First, add a flag field (Flag 20 in this example) to each of your Microsoft Project files, to indicate which tasks you want to include in your executive portfolio view. You can select as many or as few tasks as you want, but remember that simpler is often better. After adding the flag column, each of your Microsoft Project files should look something like this:
- Double-click the OnePager Pro icon on your desktop. (Don't have OnePager Pro yet? You can download a 15-day free trial to see how it works.) From the Start screen that appears, choose New.
- Select one of your .mpp files as the first Microsoft Project source file. Then, click the Change... button to launch the Data source selection dialog box, from which you can add the other files (as many as you like). Hit OK.
- Next, when the OnePager Pro import wizard launches, you'll want to name your Project View. Let's call it "Portfolio Executive Summary".
- Near the top of the form under Starting Template, click Change..., then BROWSE..., and then find the preloaded template called "Multi-Project Gantt Chart - Detailed" in your file system. This template has a set of pre-configured settings that make it easy for you to build multi-project presentations. You can always change these settings later.
- Now, select Flag 20 as the filter for your view. This ensures that you only import the tasks and milestones that your executives need to see:
- Choose a Snapshot (status) date for your executive summary (the current date is fine) and click Create new project view. OnePager will import your chosen tasks and milestones from each subproject and create an executive summary.
- If you want to color-code each project using a value different from the Resource Names column, click the Project-View Properties Button on the Home tab of the ribbon... ...and then click on the Task Bars tab. Locate the Gantt Bar/Milestone Fill Color section and choose "Project name" as shown below. This tells OnePager you want to color-code all of your project tasks based on their parent project. Click Apply.
- The result should look something like the below image:
That's it! You can cut and paste your OnePager Pro portfolio summary into a PowerPoint presentation or into an e-mail, and be ready to share it with executives in a matter of minutes.
If you would like to customize your executive portfolio summary a little more, here are some ideas:
- Use conditional formatting to allow your data to drive coloring, shapes, fills, shape size, and more!
- Group, sort tasks by any field in Microsoft Project (resources, phase, etc.).
- Generate a project legend that makes it easy for executives to get the big picture.
- Move tasks or milestones anywhere on the page to create custom groupings.
- Show each project's percent complete, critical bath, or baseline dates, and compare the entire portfolio.
- Refresh your project portfolio with updated dates and percentages any time one of your Microsoft Project plans is modified.
OnePager Pro will create rich, easy-to-understand portfolio views with the click of a button, and it keeps you from having to rebuild your executive summaries manually every time your project schedule changes.15-Day