top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
Dp
Apr 29, 20181 min read
"LOWER" Function In Excel
This Function converts your Uppercase sentence text into lower case one Syntax: =LOWER(TextToConvert) Example: Here is the video tutorial...
0 comments
Dp
Apr 29, 20181 min read
"LOOKUP" Function In Excel
This function looks for a piece of information in a list of values, and then picks an item from the last cell in the adjacent row or...
0 comments
Dp
Apr 29, 20181 min read
"DAVERAGE" Function In Excel
This Function is used to find the average of a particular item chosen from a particular criteria This is a combination of IF and Average...
0 comments
Dp
Apr 29, 20181 min read
"LEN" Function In Excel
This Function counts the number of characters in a given word, including the spaces, numbers. Syntax: =LEN(Text of a word) Example: Here...
0 comments
bottom of page