top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
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
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
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
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
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
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
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
Dp
Apr 25, 20182 min read
Create a New User Defined Calendar in MS Project 2010
The Default Calendar in Microsoft Project is the Standard 5 Day Week Calendar, and we have the two other calendars in the Global.MPT...
0
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
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
Dp
Apr 24, 20181 min read
Create One Month Filter in Primavera P6
Lets learn How to Create a One Month filter in Primavera now in this tutorial now Step 1: After Opening a Schedule in Primavera, click on...
0
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
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
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
Dp
Apr 23, 20182 min read
How to Import a Microsoft Project Schedule into Primavera With Same dates
Let us now learn How to Import a Microsoft Project Schedule into Primavera with the same dates exiting in the Microsoft project Primavera...
0
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
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
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
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
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
bottom of page