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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |