![]() The manager is solely responsible to manage the entire team throughout the project life cycle right from project initiation to planning, execution and closure. The team can have a Project Manager and various other team members. Go thru below articles to get a thorough understanding of various important excel formulas and improve your productivity.Firstly, you need to initiate the project plan by specifying a Project Name and allocating a team. Most of the day to day questions of PMs can be easily answered if they know how to write some simple excel formulas like VLOOKUP (ex: what is the progress of a particular activity), SUMIF (ex: How many hours team memer x clocked this week?), COUNTIF (ex: How many issues are open?), NETWORKDAYS (ex: How many working days are there in this month?) etc.Īt PHD, we have extensively discussed about various excel formulas and their application to the day to day work of managers, analysts and other office users. Learning a few excel formulas can greatly improve the productivity of a project manager. More ExcelCharting Tutorials and Templates.Just follow these links to get the Project Management Charting Templates and Tutorials. I have written extensively about how to create various PM charts thru Excel. PMs can easily create almost any type of project management related chart using MS Excel in minutes. Microsoft Excel has several using charting features. ![]() Closed Issues – An Example Project Management ChartĮxcel Chart Templates for Project Management ![]() Actual Charts: Show how the project scope, plans, expenditure is going wrt planned budgets. Closed Issues: Clearly tells how well the issues in the project are getting resolved and give an indication of the trend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |