top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
Apr 28, 20181 min read
"DATEDIF" Function In Excel
This function calculates the difference between two dates. It can show the result in weeks, months or years. Syntax:...
0 comments
Dp
Apr 27, 20181 min read
"COUNTBLANK" Function in Excel
This function counts the number of blank cells in a range. Syntax: =COUNTBLANK(RangeToTest) Example: Here is the video tutorial of the...
0 comments
Dp
Apr 26, 20181 min read
"LEFT" Function In Excel
This function displays a specified number of characters from the left hand side of a given word. Syntax: =LEFT(OriginalText,NumberOfChara...
0 comments
Dp
Apr 25, 20181 min read
"LCM" Function In Excel
This Function calculates the Least Common Multiple of Given Numbers. LCM is nothing but the Least number which can be divided with the...
0 comments
Dp
Apr 24, 20181 min read
"DAY" Function in Excel
This function extracts the day of the month from a complete date. Syntax: =DAY(value) Example: Here is the video tutorial of the same for...
0 comments
Dp
Apr 24, 20181 min read
"DATE" Function In Excel
This function creates a real date by using three normal numbers typed into separate cells. Syntax: =DATE(year,month,day) Example: Here is...
0 comments
Dp
Apr 23, 20181 min read
"COUNTIFS" Function In Excel
This function counts the number of items which match multiple criterias set by the user. Syntax =COUNTIFS(RangeOfThings,Criteria1ToBeMat...
0 comments
Dp
Apr 23, 20181 min read
"LARGE" Function In Excel
This function Recognizes the List of Values and picks up a value according to the user specified position of the values arranged in the...
0 comments
Dp
Apr 22, 20181 min read
COUNTA function in Excel
This function counts the number of numeric or text entries in a list. It will ignore only blanks. Syntax: =COUNTA(Range1,Range2,Range3......
0 comments
Dp
Apr 22, 20181 min read
"COUNT" Function In Excel
This function counts the number of numeric entries in a list. It will ignore blanks, text and errors. Syntax: =COUNT(Range1,Range2,Range3...
0 comments
Dp
Apr 22, 20181 min read
"Correl" Function in Excel
This function examines two sets of data to determine the degree of relationship between the two sets.The result will be a decimal between...
0 comments
Dp
Apr 22, 20181 min read
"Convert" function in Excel
This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to...
0 comments
Dp
Apr 22, 20181 min read
"COUNTIF" Function In Excel
This function counts the number of items which match criteria set by the user. Syntax =COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatch...
0 comments
Dp
Apr 22, 20181 min read
"Concatenate" Function In Excel
This function joins separate pieces of text into one item. Syntax: =CONCATENATE(Text1,Text2,Text3...Text30) Example: Here is the video...
0 comments
Dp
Apr 22, 20181 min read
"Clean" Function In Excel
This function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported...
0 comments
Dp
Apr 22, 20181 min read
"Combin" Function In Excel
This function calculates the highest number of combinations available based upon a fixed number of items. This is nothing but the...
0 comments
Dp
Apr 22, 20181 min read
"Average" Function in Excel
This function calculates the average from a list of numbers. If the cell contains zero 0, the cell will be included in the average...
0 comments
Dp
Apr 22, 20181 min read
Autosum In Excel
Instead of using the Autosum function or the button from the toolbar You can press Alt and = to achieve the same result Just you have to...
0 comments
Dp
Apr 22, 20181 min read
"AND" Function in Excel
This function tests two or more conditions to see if they are all true. It can be used to test that a series of numbers meet certain...
0 comments
Dp
Apr 21, 20181 min read
Show only some portion of Excel sheet
Excel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank...
0 comments
bottom of page