Share

Live Webinar – July 27th, 2016 3:00 pm – 4:30 pm EDT
Offered by MPUG WebnLearn ( REP 1369 )
Duration 1 hour + Q & A 1 PDU / 1 CDU
Mpug Member Free – Members only event

Even though Project Pro for Office 365 is available through a monthly subscription, there are many companies and individuals who still use old versions of MS Project (Project 2010, Project 2007 and (believe or not) Project 2003) to track their schedules.

All these people sometimes struggle on trying to create reports to quickly understand their project performance, once the reporting mechanism in old versions of the software is not as good as the mechanism that was introduced with the launch of Project 2013.

What most people do not know is that it is possible to export data from MS Project to a MS Access database.

By doing this, we can then connect to the database with MS Excel and create beautiful, interactive dashboards, getting quick insights of the key project information.

Also, this approach provides the user with the ability of keeping the report up-to-date, and also to reproduce the report for other projects if needed.

The key take-aways of this presentation are:

  1. Knowing how to export data from Project to a MS Access Database
  2. Knowing the information that is exported and how to manage it
  3. Knowing how to use MS Excel to connect to the database
  4. Creating a beautiful, interactive status report
  5. Keeping the report up-to-date
  6. Using the report for other schedules

Presenter: Raphael Santos (LinkedIn profile) is the author of Excel 2013 – Módulo Intermediário (Portuguese Edition).  As a PPM Consultant, with deep expertise in providing Microsoft Project & Project Server solutions, he has worked in several projects to implement PPM tools, including countries in Latin America and Africa. With more than 10 years of experience in teaching users the use Project Management tools in a more productive way, Raphael runs a personal blog to share ideas and solutions for the Project Management community.

If you are NOT ALREADY a member JOIN MPUG!

This event is for members only BUT… You can take one of the MPUG Certificated Masterclass (Usually 6 Category A PDUs) Or over 30 other Category A PDUs for free each year.  The $129 Per Year Membership Fee is a terrific value!

MPUG Membership includes:

  1. MPUG’s Project Server and SharePoint certificated courses available to members
  2. Over 30 other virtual PDU events per year
  3. You can network with other MPUG (Microsoft Project Users Group) members at in person meetings and events.
  4. Work with Microsoft MVPs in MS Project Project Server & SharePoint
  5. And so much more …

Seriously consider joining MPUG if you work with SharePoint or Project & earn all the PDUs you will need as a member of MPUG!

Click to register for:
Create Beautiful Reports On Project Desktop
With Tools Other Than Just Project!

1.0 0 0
Technical Project Management Leadership Strategic & Business Management