MPUG Category: Excel
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...