Free Project Management Tools - Tutorials,Ebooks and Setups

This Function calculates the position of a value in a list relative to the other values in the list. It can be very much used while ranking to be done. Syntax: =RANK(NumberToRank,ListOfNumbers,RankOrder) Example: Back to MS Excel>>

This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when your press F9 Syntax: =RAND() or =RAND()*10 or =RAND()*(100-5) Back to MS Excel>>

This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax: =QUOTIENT(Numbertobedivided,divisor) Example: Back to MS Excel>>

This function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax: =PROPER(Text to convert) Example: Back to MS Excel>>

Before implementation of any schedule, It has to be reviewed, modified to ensure compatibility with the requirements. The following attached document is the sample scheduling specification where issues,Methods, terms Regarding the Scheduling have been illustrated. Download Here

Find a Paper on Detail Critical Path Analysis Published in  journal Download Here

Two Fundamental Techniques are used throughout the Project Management: 1.Breakdown Complex items into Simple Parts, Solve Them, Roll them up: Break the Project Down into the Five phases. Break the Scope down into manageable size deliverables. Break the Deliverables down into individual activities 2. Do one thing at a time to avoid Thrashing: List all the possible Stakeholders first, then you decide how to Communicate with them. List all possible risks first, then shortlist them and quantify them. Build the schedule first, then resolve any resource conflicts.

Project Management Deals with nine Knowledge areas 1.Integration 2.Scope 3.Time 4.Cost 5.Quality 6.Human Resources 7.Communications 8.Risks 9.Procurement

This Function multiples a group of numbers together. It is the same as using 2*3*4*5, which results the product of the four numbers. Syntax: =Product(Number1,Number2,........Number30) or =Product(range of Numbers) or =Product(Number1,Range,Number2,....) Example : Back to MS Excel>>

This Function raises a number to a user specified power.It is same as using the 6 Operator, Such as 2^5, which results as 32. Both the Power() function and the ^ Operator are the same as using 2*2*2*2*2. Syntax: =POWER(Number to be raised, power) Example: Back to MS Excel>>