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...
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...
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...
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...
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...
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...
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...
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...
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...