top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
May 1, 20181 min read
"INT" Function In Excel
This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...
0 comments
Dp
May 1, 20181 min read
"IF" Function In Excel
This function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered...
0 comments
Dp
May 1, 20181 min read
"HLOOKUP" Function In Excel
This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down...
0 comments
Dp
May 1, 20181 min read
"FREQUENCY" Function In Excel
This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the...
0 comments
Dp
May 1, 20181 min read
"FORECAST" Function In Excel
This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...
0 comments
Dp
May 1, 20181 min read
"FIND" Function In Excel
This function looks for a specific letter in a word and gives the result as number of the position of the letter in a word. If the text...
0 comments
Dp
May 1, 20181 min read
"EOMONTH" Function In Excel
This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:...
0 comments
Dp
May 1, 20181 min read
"DMAX" Function In Excel
This function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...
0 comments
Dp
Apr 30, 20181 min read
"RANK" Function In Excel
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...
0 comments
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 comments
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 comments
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
bottom of page