OnePager Express, an Excel-based project management tool, works with the data you already have in Salesforce to build project plans quickly and easily. To learn more, you can download a free trial and follow these step-by-step instructions:
- You can track client projects in Salesforce lots of different ways, but the easiest way is to create an Opportunity for each separate project, and give each opportunity a start date and finish date that corresponds to when you're planning to begin and finish work.
Once you have this data (or something similar) in Salesforce, you can create an Opportunity Report that summarizes all of your current projects like this:
- Click the Export Details button to export your projects into an Excel format like the one below:
- Now, it's time to create your project report. Click on the OnePager Express button on your Microsoft Excel toolbar or Add-ins tab. From the Start screen that appears, choose New.
- OnePager Express will launch an easy import wizard. Give your project plan a name, and specify a snapshot (status date) as shown below:
- Click Next and double-check that the columns you're importing from Salesforce are the ones you want in your project plan:
- Click on the Create new project view to build a project plan based on your Salesforce account data:
This project plan has been automatically grouped into swimlanes by the Account Name and color-coded by the Opportunity Owner, which makes it really easy to read.
- You now have an eye-catching project plan straight out of Salesforce that you can share with the rest of your team. Just go to Home > Copy Graph, and paste your chart into PowerPoint.
It's really easy to get started!
The best part is that you can customize your OnePager Express report to:
- Change colors, symbols, fonts, and layouts
- Automatically group or color-code by account owner, opportunity type, or any other Salesforce data
- Update your report any time your data changes in Salesforce
- Add comment boxes, text boxes, curtains, or images to your project plan
OnePager Express is the easiest way to make PowerPoint-ready project plans out of Salesforce account and opportunity data. Join the thousands of people just like you who use OnePager today!