OnePager Express produces great-looking project schedules in minutes, using information you already have in Excel. Download a 15-day free trial today, and follow these easy steps to create a multi-project schedule for your team:
- Start with a set of Excel spreadsheets, one for each of your projects. Each of your spreadsheets should have a column for Task Name, Start Date, and Finish Date; other information is optional.
- Double-click the OnePager Express icon on your desktop. (If you don’t have OnePager Express, you can download a free trial.) From the Start screen that pops up, choose New.
- Select one of your spreadsheets as the first Excel 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.
- OnePager Express will launch an easy import wizard. Give your multi-project schedule a name, and specify a status date (7/1/2013):
- Click the Next button to select which Excel columns you want to use in your OnePager Express schedule. For example, for task name, it makes sense to select the "Task Name" column:
- When you are satisfied, just click on the Create new project view button, and you’ll see a schedule chart that looks like this:
- To share your project schedule, simply click the Copy button on the OnePager Express toolbar, and paste your schedule into a PowerPoint presentation.
If you’d like to customize your multi-project OnePager Express chart before pasting it into PowerPoint, you’ll find it very easy to accomplish:
- Change colors, symbols, fonts, and layouts
- Automatically group or color-code by resources, project phase, or any other Microsoft Excel data
- Show baseline dates and durations
- Add comment boxes, text boxes, curtains, or images to your project presentation
Using OnePager Express will allow you to create dynamic, informative multi-project schedules with the click of a button, all based on data you already have in Excel.15-Day