Loading...
Quick Links

MPUG Category: Excel

Duration (approximate)

Experience Level

​​Content Type

​PMI PDU

Effectively Using Excel for Analyzing MS Project Data

MS Project (MSP) is an excellent tool for preparing and tracking project schedules. Excel is also a great tool for analyzing any type of data. So, which one should you use for schedule analysis? You p...

Importing Data from Excel to MS Project

MS Excel is a generic tool that can be used in many situations. In terms of project management, it is an average tool for preparing project schedules, at best. It is generally believed that MS Project...

A Resource Leveled and Smoothed Schedule

  In the figure above, a schedule was resource leveled using Project (left Gantt chart). It was resource smoothed using Excel (right Gantt chart). Both results are resource-feasible, but the sche...

MS Project Formula Tips

Microsoft Project formulae are a powerful way to introduce custom calculations into your project plan. Many people who may be familiar with writing formulas in Excel find Microsoft Project’s formula e...

Webinar Recap: Data Analysis Using Project with Excel

Please find a transcription of the audio portion of Jeff Bongiovani’s Data Analysis Using Project with Excel webinar being provided by MPUG for the convenience of our members. You may wish to us...

Project Portfolio Selection Using NPV (Part 2)

Turning the whole system into something greater than the sum of its parts   In the first part of my article, we covered how the selection of projects is crucial to Project Portfolio Management (P...

MrExcel’s Favorite Excel Tips and Tricks Transcription

Please find a transcription of the audio portion of Bill Jelen’s MrExcel’s Favorite Excel Tips and Tricks webinar being provided by MPUG for the convenience of our members. You may wish to use t...

The Best of 2018: MPUG’s Top Ten Articles from Last Year

Here’s our lineup of articles from 2018 that were the most popular! What do you think? Were any of these a favorite of yours? 1. Ask the Expert: Import Excel Data into Project – Tips & Troubleshoo...

Best Practices for Integration of Microsoft Project and Excel

Introduction This article discusses Project and Excel integration points, specifically in the following areas: How to import data from Excel to Project Importing an initial last list How to export dat...