DpApr 29, 20181 min"LOWER" Function In ExcelThis Function converts your Uppercase sentence text into lower case one Syntax: =LOWER(TextToConvert) Example: Here is the video tutorial...
DpApr 29, 20181 min"LOOKUP" Function In ExcelThis 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...
DpApr 29, 20181 min"DAVERAGE" Function In ExcelThis Function is used to find the average of a particular item chosen from a particular criteria This is a combination of IF and Average...
DpApr 29, 20181 min"LEN" Function In ExcelThis Function counts the number of characters in a given word, including the spaces, numbers. Syntax: =LEN(Text of a word) Example: Here...
DpApr 28, 20181 min"DATEDIF" Function In ExcelThis function calculates the difference between two dates. It can show the result in weeks, months or years. Syntax:...
DpApr 27, 20181 min"COUNTBLANK" Function in ExcelThis function counts the number of blank cells in a range. Syntax: =COUNTBLANK(RangeToTest) Example: Here is the video tutorial of the...
DpApr 26, 20181 min"LEFT" Function In ExcelThis function displays a specified number of characters from the left hand side of a given word. Syntax: =LEFT(OriginalText,NumberOfChara...
DpApr 25, 20182 minCreate a New User Defined Calendar in MS Project 2010The Default Calendar in Microsoft Project is the Standard 5 Day Week Calendar, and we have the two other calendars in the Global.MPT...
DpApr 25, 20181 min"LCM" Function In ExcelThis Function calculates the Least Common Multiple of Given Numbers. LCM is nothing but the Least number which can be divided with the...