sales@onepager.com +1.303.779.0344

Creating Multi-Project Excel Schedules using OnePager Express

How to make a one-page Excel project timeline showing multiple projects

Does it take you hours to create a schedule for all your projects in Excel? Does that schedule look good enough to show your boss or client? Can you easily update your schedule chart for the next status report?

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:

  1. 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.
    Sample schedule in Excel.
  2. 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.
    OnePager Express Start screen.
  3. 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.
    Import multiple Microsoft Excel spreadsheets into your OnePager Gantt chart.
  4. OnePager Express will launch an easy import wizard. Give your multi-project schedule a name, and specify a status date (7/1/2013):
    Easy import wizard takes an Excel schedule and creates a project schedule.
  5. 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:
    Map your Excel columns into an easy-to-understand Gantt chart.
  6. When you are satisfied, just click on the Create new project view button, and you’ll see a schedule chart that looks like this:
    Multi-project schedule created in OnePager Express, based on an Excel spreadsheet.
  7. To share your project schedule, simply click the Copy button on the OnePager Express toolbar, and paste your schedule into a PowerPoint presentation.

Customizable

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.

Get started today by downloading a free trial or attending one of our demonstration webinars.

15-Day
Free Trial