top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
Apr 29, 20181 min read
"RAND" Function In Excel
This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when...
0
Dp
Apr 29, 20181 min read
"QUOTIENT" Function In Excel
This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax:...
0
Dp
Apr 29, 20181 min read
"PROPER" Function In Excel
This function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax:...
0
Dp
Apr 29, 20182 min read
How to adjust the Legend Space in Microsoft Project
In this Tutorial, let us see how to adjust the space occupied by the Legends in Microsoft Project, enabling for a better professional...
0
Dp
Apr 29, 20181 min read
"PRODUCT" Function In Excel
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....
0
Dp
Apr 29, 20181 min read
"POWER" Function In 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...
0
Dp
Apr 29, 20182 min read
Export Primavera P6 Data Into Excel and Format
We all know how to export the Schedules prepared in the Primavera tool into a spreadsheet format, if not view the tutorial just below....
0
Dp
Apr 29, 20181 min read
"PERMUT" Function In Excel
This Function calculates the maximum number of permutations given a fixed number of items. The Internal order is Significant. so AB and...
0
Dp
Apr 29, 20181 min read
"ODD" Function In Excel
This Function rounds a number up to the next highest odd number. Syntax: =ODD(number to be Rounded) Example: Here is the detailed video...
0
Dp
Apr 29, 20181 min read
"NOW" Function In Excel
This Function Shows the Current Date And Time. The Result will be updated each time the Worksheet is opened and Every time an Entry is...
0
Dp
Apr 29, 20181 min read
"NOT" Function In Excel
This function performs a test to see if the test fails. (A type of reverse logic). If the test fails, the result is TRUE. If the test is...
0
Dp
Apr 29, 20181 min read
"NETWORKDAYS" Function In Excel
This function will calculate the number of working days between two dates. You can simply use the subtraction method but the Benefit of...
0
Dp
Apr 29, 20181 min read
"N" Function In Excel
This function converts a numeric entry to its mathematical value.Anything which will not convert is shown as 0 zero.Excel does not really...
0
Dp
Apr 29, 20181 min read
"MROUND" Function In Excel
This Function Rounds a number up or down to the nearest multiple specified by the user. Syntax: =MROUND(NumberToRound,MultipleToUse)...
0
Dp
Apr 29, 20181 min read
"MONTH" Function In Excel
This Function Extracts the name of the Month from a complete date Given. Syntax: =MONTH(Date) The Result will be in the number format....
0
Dp
Apr 29, 20181 min read
"MOD" Function In Excel
This function calculates the remainder after a number has been divided by another number. Syntax: =MOD(Number,Divisor) Example: Here is...
0
Dp
Apr 29, 20181 min read
"MIN" Function In Excel
This Function Results the Lowest value of the data given. Syntax: =MIN(Range1,Range2,Range3... through to Range30) Example: In the...
0
Dp
Apr 29, 20181 min read
"MID" Function In Excel
This function picks out a piece of text from the middle of a text entry. The function needs to know at what point it should start, and...
0
Dp
Apr 29, 20181 min read
"MAX" Function In Excel
This Function picks the highest value from the given list of values. Syntax: =MAX(Range1,Range2,Range3... through to Range30) Example:...
0
Dp
Apr 29, 20181 min read
"MATCH" Function In Excel
This function looks for an item in a list and shows its position. It can be used with text and numbers. It can look for an exact match or...
0
bottom of page