MPUG Category: Excel
8 Places where Microsoft Excel Scores for Project Management
Which tool would you use for project scheduling — Microsoft Project or Microsoft Excel? I’m guessing your answer (like mine) would be Project. It has many inherent advantages over Excel. (...
Ask the Experts: Exporting Only Tasks to Excel
Heather from Naperville, IL asks: When I export tasks to Excel, I seem to export summary tasks, milestones, and detail tasks. Is there any way to export just detail tasks? Answer: With the help of a c...
Working the Numbers: How to Inject Financial Savvy into Project Management
Paul Sausville is no bean counter. Although he has a master’s degree in finance, spent years at NCR and AT&T as a consultant for the banking and financial services industries, and went to wo...
Ask the Expert: Importing Data from Excel into Project
Richard J. writes, I’m using Microsoft Project 2000 to import data from Microsoft Excel but some of the data isn’t appearing in Project, seemingly at random. This may be because there are ...
Ask the Teacher: Export the Task List to Excel and Keep the WBS Structure
I would like to export the task list in Microsoft Project to Excel and keep the WBS structure. A cut and paste loses the WBS structure. Is there a way to accomplish this? Answer: Yes, you can do this....
Excel vs. Project: How to Convince Managers that Project Really is Better for Managing Projects
How often have you seen a manager struggle to use Microsoft Office Excel to manage project information such as scheduling project dates or recording task assignments? Often, it’s a matter of sti...