Project Scorecard for Executive Review

How to Create a Graphical Project Scorecard for Management Reviews.

Customers and Executives love to see a project scorecard as part of a project review.  This most often means it is presented on a PowerPoint slide in a dashboard format.   This article and video discusses how to quickly build a PowerPoint project scorecard around your project timeline as shown below.

Project Scorecard - how to make quickly make them in PowerPoint.,Why PowerPoint?

Executives and customers are most familiar with project reviews presented in PowerPoint.  They are experienced in reading these presentations, and know PowerPoint will force presenters into condensing their content into the most relevant information.  So they get a high-level summary of the business which enables them to make decisions quickly.

Why a Project Scorecard?

Since executive level presentations do not require deeply detailed project reports, they should be no more than 2-3 slides per project. Using a project scorecard is the most effective way to summarize project status at a high level to audiences such as project stakeholders, sponsors, clients and management.  Typically project scorecards are made up of metrics and commentary on various things like budget, accomplishments, risks and future actions, and all of these are anchored around a clear, up-to-date project timeline.

How to Make a Project Scorecard Easily in PowerPoint

Creating fresh and appealing visual project status reports or project presentations in PowerPoint is a time consuming effort for any project manager. Additionally, these presentations often need to be re-created, updated or edited on a weekly, or monthly rhythm, so finding tools that can quickly and easily create and manage this work saves time.

Office Timeline is a free timeline maker that creates and manages PowerPoint timelines for executive and customer project status meetings.  These timelines are created natively in PowerPoint so they can easily be integrated with a project status slide or pasted onto and existing project scorecard template.

The video below demonstrates how to quickly build the timeline and scorecard slide in the image above with Office Timeline.  It also demonstrates how to update your project timeline dashboard instantly and automatically with new information as your project progresses.  This makes updating the slide for reoccurring project reviews and executive presentations automatic.

Download Office Timeline Free Edition

Suggested Reading
Pasting timelines
Exceptional PowerPoint Add-Ons
How to quickly make a timeline


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

Quickly Build Gantt Charts in Excel

Project plans, reviews, and proposals often need to be presented to team, clients and executives.  Gantt charts and timelines are the proper way to communicate to these audiences.  Clients and executives, in particular, expect these Gantt charts and timelines to be graphical, visually appealing and easy to understand.  However, creating a Gantt chart in Excel has been challenging and time consuming.

This post and video will show you how to quickly turn timeline Excel data into a professional looking chart, like the one below, with the Office Timeline PowerPoint add-in.Turn a Gantt chart in Excel into a PowerPoint slide

Using existing tools to create professional looking Gantt chart and timeline presentations has not been easy.  Project tools, like Microsoft Project, are intended for large scale project management.  They are complicated to learn and they produce overly complex Gantt charts and timelines which are not suited for high level customer and management presentations.

Unlike heavy-weight project tools, visual tools like Visio are better at creating graphical images like Gantt charts and timelines.  However, they are painful to use and lack “smarts” which automatically adjust images when project schedules need updating.

Excel is often the place that project plans and schedules are created.  Most professionals and project workers find it easy to do this.  Once they have their project planned or tracked, they then need to quickly turn that Excel data into a graphical chart that can presented as a project status report, proposal summary or action plan.  This work is automated by the light-weight timeline maker from Office Timeline.

Office Timeline will immediately turn a Gantt chart in Excel into a professional looking PowerPoint slide that is easy to share and present.  It automatically manages updates, so if plans or project schedules change you can quickly update your Gantt chart or timeline without having to make major edits.

How to quickly build a Gantt chart with Excel

Once you have your timeline in Excel or Gantt chart in Excel simply cut and paste it’s data into the Office Timeline PowerPoint add-in.  This video shows how to do that.

Since PowerPoint has size limitations Office Timeline also provides the ability to customize spacing and sizing to maximize the space of your slide.  This is useful for a  Gantt chart in excel that has a long list of action items (tasks).  The video below shows how you can optimize your project slide if you need to present more.

Suggested Reading
Tutorial for making a Gantt chart with Excel 
Using Gantt diagrams for business planning
How to paste Excel schedules into PowerPoint
 

Steps for creating a Timeline in Excel

www.officetimeline.com


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

Make a “Diagramme de Gantt” in PowerPoint

Clearly communicating your project timeline to international teams, managers and partners is critical when working across cultures.  Doing so requires project presentation tools that are flexible enough to accommodate the local language of your audience.  In the example below we created a Diagramme de Gantt and selected French as the local language setting in Office Timeline.  For enterprises engaged in cross-border collaboration or cross-border selling, adjusting to the native language will create a good first impression.  This rule is important for any Gantt chart timeline presentation.   The steps below explain how you can quickly make a Diagramme de Gantt in PowerPoint using the light-weight add-in for PowerPoint – Office Timeline 2013.Diagramme de Gantt

Office Timeline 2013 provides two easy ways to localize the language of your Diagramme de Gantt or any other timeline presentation.  Download Office Timeline Free Edition

Step 1: First, while you are in the Wizard, choose the native language for timeband on your Gantt diagram . This is easy to do and makes a terrific first impression.  Simply set the Timeband Language from the Language drop-down menu on the Scale tab of the Office Timeline Wizard.

Step 2: Next, adjust the date format in your Gantt diagram, from US to International.  This is done from the Office Timeline ribbon in PowerPoint by using either the Task or Milestone date format.

Using these two simple steps to localize your Diagramme de Gantt will distinguish you and your work among your cross border clients, colleagues and managers. A Gantt chart template will help speed the process as you develop the Ganttproject presentation.

Download Office Timeline Free Edition

Suggested Reading
Using Gantt diagrams for business planning
Tutorial for making a Gantt chart with Excel
Simplifying Gantts for important presentations


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

How to make a timeline easily

Timeline makers are powerful visual tools for presenting project or planning information clearly.  This post will show you how to easily make a timeline slide for client or management presentations, with a simple template driven timeline maker that plugs into PowerPoint. 

In the past it has been difficult to create a timeline that is graphically appealing or to make a timeline that is appropriate for presentations to staff, clients or managers.  Free timeline makers, also called timeline creators or timeline generators, are a category of software tools that make this task much easier. This post shows how to make a timeline easily with a free timeline creator that builds professional timelines quickly, right inside PowerPoint.    Timeline template made with timeline generator Office Timeline

Office tools do not manage timeline data or automate timelines.

To create a timeline with Visio or make a timeline with Excel is painful because neither are automated for this work like a timeline creator is.   A timeline creator or timeline generator is specifically set-up to create graphical images and to manage project schedules.  (project schedules are the dates and events that make up your project).  A timeline creator or timeline generator simplifies how this project schedule is used to make a timeline and how to update it easily.

The ability to continually make changes is important because project schedules frequently change.  For example if any of your milestones slip the timeline creator would automatically update the entire timeline.   Without the automation of a timeline creator, making even simple changes like this would require painful manual editing of the graphics for each Excel data point or Visio object.Project Schedule for timeline creator

Project tools are too complicated for presentations to clients and managers.

Heavy-weight project tools such as Microsoft Project, like a timeline creator, are also equipped to make a timeline or Gantt chart.  Although these tools are automated to manage project schedules elegantly, they are complicated to learn and too heavy for high-level presentations.  Since project software is not designed to be graphical, it is difficult to make timeline presentations that are suitable for reviews with staff, customers and executives.  These audiences expect a PowerPoint presentation.

Office Timeline is a free timeline creator that solves these problems.

The best solution for project presentations is a light-weight timeline generator that integrates into a familiar presentation tool like PowerPoint.  It should create a timeline template or Gantt chart natively in PowerPoint so it can be updated, shared and modified simply by any PowerPoint user.  The post below shows how to easily build a timeline, right from PowerPoint, with a free timeline creator called Office Timeline.

Follow these steps to make a timeline quickly. 

Download and install Office Timeline.  Once installed it will add an Office Timeline tab to your PowerPoint ribbon.

Step 1: From the ribbon click New to launch the timeline creator wizard which will guide you through easy set-up and design steps.Timeline creator ribbon in PowerPoint

Step 2: Browse through styles of timelines, Gantt charts and templates.   Select the style you would like to build, then click the Next arrow to style your timeline.Make a timeline in PowerPoint

Step 3:  Enter the key project milestones and tasks and set their dates or durations (in the Office Timeline Plus edition you can paste schedules directly from Excel).  Make some optional style choices such as changing the color or shape for each item.  When you have finished click the Next arrow to create a timeline.Timeline creator milestone wizardTimeline generator task wizard

Step 4: Choose how you want milestones, tasks, timeband, and scaling to be presented.Make a timeline in PowerPoint _Style WizardMake a timeline in PowerPoint _Scale Wizard

Step 5: Done, just click the green Check in the timeline creator to make a timeline slide that looks like this.Make a timeline template in PowerPoint with add-in from Office Timeline

You now have a professional looking timeline slide that will stand out in high-level presentations. At any time, you can make changes to the slide by simply clicking on the Milestone, Task or Style buttons on the timeline generator ribbon. This will re-access the wizards so you can quickly update your timeline, and easily change any of the design choices you made. Office Timeline will instantly rebuild your slide with those changes.

See a this short video of how it works.

Download Office Timeline Free Edition

Suggested Reading
Using timelines for IT projects
Exceptional PowerPoint Add-Ons
Steps for creating a Gantt chart in Excel

Steps for creating a Timeline in Excel 


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

Quickly make a Pharmaceutical timeline slide in PowerPoint

In pharmaceutical and in clinical trials, making and presenting professional, high-level pharmaceutical timelines to big pharma management or pharmaceutical agencies is essential.  The pharmaceutical industry needs and depends on clear project timelines and Gantt charts that can be easily presented in PowerPoint so manufacturing plans and decisions can be made efficiently and effectively. The post below shows how to easily build and update a clinical trial timeline or pharmaceutical project timeline slide, right from PowerPoint, with a free PowerPoint add-in.
Pharmaceutical timeline or clinical trial timeline

Creating a pharmaceutical timeline or clinical trial timeline slide has been painful.

Creating a pharmaceutical timeline slide or gantt chart slide with the project software used in pharmaceutical manufacturing has been difficult. Heavyweight project applications do not have simple tools to create high-level project reviews needed for important presentations. They produce overly complex Gantt charts and timelines which are not suitable for clinical trial presentations or pharmaceutical manufacturing project reviews to management and agency executives.

On the other hand, tools like Microsoft Visio and Excel are time consuming because they are not automated for making the type of professional looking pharmaceutical timeline or clinical trial timeline that management expects to see.   This is further complicated as a clinical trial timeline or pharmaceutical timeline frequently needs updating when schedules change, requiring a complete rebuild of the timeline.

Finally, stand-alone timeline maker or timeline generator solutions are not integrated into Microsoft PowerPoint, making them difficult to share and present, and also inflexible when multiple team members need to collaborate on a timeline.

Office Timeline is a lightweight PowerPoint add-in that solves these problems.

Office Timeline makes it easy to create clinical trial timeline or pharmaceutical timeline slides, suitable for high-level presentations, proposals and project reviews.  It was created to make it very simple to design, build and update professional looking pharmaceutical timeline slides for reviews to executives and management.  Since it is a lightweight PowerPoint add-in, it can build clinical trial timeline slides natively in PowerPoint which means they are easy to edit, communicate and share with other project stakeholders.

See how it easily makes Pharmaceutical Timeline and Clinical Trial timeline slides

Here is a quick look at how it works. Download and install Office Timeline from here.  Once installed it will add an Office Timeline tab to your PowerPoint ribbon (see image below). Click New to launch the Office Timeline wizard which will guide you through a couple easy set-up and design steps.Timeline maker add-in for PowerPoint 1Select the type of gantt chart or timeline slide you want to build from several style types offered, then click the Next arrow to enter your pharmaceutical or clinical trial project schedule and to begin customize it.Timeline maker add-in for PowerPoint New Wizard

2. Enter the key project milestones and tasks of your Pharmaceutical Timeline andset their dates or durations (in the Office Timeline Plus edition you can paste schedules directly from excel).  Make some optional style choices such as changing the color or shape for each item.  When you have finished click the Next arrow to choose customizations for your Pharmaceutical manufacturing slide.Timeline maker Milestone Wizard in PowerPoint

Timeline Maker Task Wizard in PowerPoint

3. Make stylistic and design choices for how you want Milestones, Tasks, Timeband, and Scaling to show on a Pharmaceutical timeline or Clinical Trial timeline, then click the green Check to build your slide.Timeline Maker Style Wizard in PowerPoint

You are done and now have a professional looking pharmaceutical manufacturing timeline or clinical trial timeline slide that will stand out in high-level presentations. At any time, you can make changes to the slide by simply clicking on the Milestone, Task or Style buttons on the ribbon. This will re-access the wizards so you can quickly update your pharmaceutical project or clinical trial data, and easily change any of the design choices you made. Office Timeline will instantly rebuild your slide with those changes.Pharmaceutical timeline or clinical trial timeline

Download Office Timeline Free Edition

Suggested Reading
Tutorial for making a Gantt chart with Excel
Using Gantt diagrams for business planning
Steps for creating a Timeline in Excel
Exceptional PowerPoint add-ons

Suggested Video Tutorial
Cutting and pasting your project tables into PowerPoint


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL