Automating Portfolio Status Reporting Using Microsoft PowerPoint

Introduction
This write-up will show some simple and effective automation I have been using to publish and communicate one-page (or dashboard) project status reports using MS PowerPoint.

Along the way, I will explain how this is one of the many uses possible, and will point to other possibilities to adapt to your needs.

Target Audience
Project/portfolio/program managers working on multiple projects or programs who have basic Visual Basic for Applications (VBA) skills (or are able to delegate programming or customizing the use case cited here).

Purpose
This approach, involving some VBA programming, can reduce repetitive and periodic tasks of reporting and uploading status reports.

I have been using something similar for some years now, and found the most common scope for automation has been one of managing the portfolio (of group of projects) to publish individual projects in project portals for respective stakeholders/departments. Feel free to customize further based on your reporting needs and opportunities for automation (detailed project reports, publish finance reports, risk logs, etc. from MS Excel, MS Project, etc.).

I am planning to cover some other use cases in follow-up articles as feasible; here, I am focusing on automated publishing of project reports in individual project portals (or repositories). Hopefully, the simple VBA programming might …

Please log in or sign up below to read the rest of the article.

ADVERTISEMENT

Continue reading...

Log In
OR
Sign Up
ADVERTISEMENTS

"Karate is a form of martial arts in which people who have had years and years of training can, using only their hands and feet, make some of the worst movies in the history of the world."

- Dave Barry

ADVERTISEMENT

Sponsors