MPUG Category: Excel
Exploring VBA: Microsoft Project’s Macro Language
Description: The initial session will provide an overview of working within the VBA environment, including the basics of recording and editing VBA macros. In the second session Ira will demonstrate ho...
Exploring VBA Part III: Using VBA to Integrate Microsoft Project with other Microsoft Tools – Transcription
Please find below a transcription of the audio portion of Ira Brown’s session, Exploring VBA: Microsoft Project’s Macro Language Part III, being provided by MPUG for the convenience of our members. Yo...
Exploring VBA: Microsoft Project’s Macro Language: Part III Using VBA to Integrate Microsoft Project with other Microsoft Tools
Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Event Description: The session is g...
How Visual Basic for MS Project Changed my Life
Doing the Impossible In 2010, I attended a Baltimore MPUG meeting that changed my life. I learned about Visual Basic for Applications (VBA) for Microsoft Project, and I was stunned to discover easily-...
Exploring VBA: Microsoft Project’s Macro Language: Part III Using VBA to Integrate Microsoft Project with Other Applications
Exploring VBA: Microsoft Project’s Macro Language Ira Brown will deliver this fun and informative three-part series that will provide you with an in-depth understanding of the automation capabilities ...
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...