How to use Excel GETPIVOTDATA function

Introduction GETPIVOTDATA function in excel is a lookup function. This function is used to return specific data from a pivot table. It uses pivot table structure instead of reference cell reference for retrieving data. Syntax  =GETPIVOTDATA (Data_Field, Pivot_Table, [field1,item1]) Argument Data_Field: It is the name of the field entered in quotation marks which contains the data to be returned.Pivot_Table:  It is the reference made to the cell in pivot table which has the data to be returned.Field_Item: These are pairs…

Continue Reading

How to use Excel MINUTE Function

Introduction MINUTE function in Excel is a type of DATE/TIME function. This function is used to find minutes from a given time. It gives result in form of numbers ranging from 0 to 59. For example, for time 10:15 AM, MINUTE function will retrieve 15 as the result. MINUTE function can also be used with the TIME function for feeding MINUTEs into this function. Syntax =MINUTE(Serial_Number) Arguments Serial_Number- This is time in a valid excel format or a cell number…

Continue Reading

How to use Excel TEXTJOIN Function

Introduction TEXTJOIN function are text/string function in excel. It is used to join multiple text strings with a delimiter attached to it. It also has option to ignore empty values and can also be used to join a range of cells. Syntax =TEXTJOIN(delimiter, ignore_empty, text1, text2) Arguments Delimiter: It is the separator between text values. Ignore_empty: Logical argument which decides whether empty values should be ignored or not. Text1: It is the first text or range. Text2: It is the…

Continue Reading

How to use Excel FIND, FINDB Function

Introduction FIND, FINDB in excel is a text/string function. This function finds one text string within another string and returns its position as a number. This is a case sensitive function. For example, if we have a text string in cell A4 and we wants to find the position of ‘P’ in this string, then we use the function =FIND(“P”,A4) and gets result in form of a number, if the text is not present, #VALUE error is displayed. Syntax =FIND(Find_Text,…

Continue Reading

How to use Excel YEAR function

Introduction YEAR function in Excel is a type of DATE/TIME function. It used to find YEAR of a specified date. It can be used to supply YEAR into a cell or used with functions like DATE function as a feeder. Syntax =YEAR( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form of text are entered then there is a possibility of getting an error.   Keynotes In General…

Continue Reading

How to use Excel YEARFRAC function

Introduction YEARFRAC function in Excel is a type of DATE/TIME function. It used to find year between two dates which can also be in form of a fraction and result can be in form of decimals. It is a worksheet function and can be entered in a cell. Syntax =YEARFRAC(Start_Date, End_Date, Basis) Arguments Start_Date:- A starting date in a valid excel format. Can be entered using DATE function, if dates in form of text are entered then there is a…

Continue Reading

How to use Excel HOUR Function

Introduction HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the TIME function for feeding hours into this function. Syntax =HOUR(Serial_Number) Arguments Serial_Number- This is time in a valid excel format. Keynotes Time values are represented…

Continue Reading

How to use Excel ASC Function

Introduction ACS in excel is a text/string function. It is used in case of double byte character set to convert full width(double-byte) to half width(single-byte) characters. This function is useful for multiple languages and unique characters. For example, =ASC(“PRINCE”)gives PRINCE as the result. Syntax =ASC(Text) Arguments Text: It is the text or reference which contains the characters you wants to convert to single bytes. Keynotes The maximum characters possible in one byte is 265 while in two bytes maximum characters…

Continue Reading

How to use excel DATEVALUE function

Introduction DATEVALUE function in Excel is a type of DATEVALUE/TIME function. This function is used to change a date which is in form of text to a valid excel format and gives result in form of serial number in the Excel date system. For example, formula =DATEVALUE(12/09/2018) gives 43443 as the result.  Syntax =DATEVALUE(Date_Text) Arguments Date_Text-  It is the text or cell reference which represents the date value in valid excel format. Keynotes In General formatting of Excel, DATEVALUE function…

Continue Reading

How to use Excel DAYS Function

Introduction DAYS function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates. This function can be applied to find the number of the DAYS from the date present in the cell. This can also be used to extract and put the number of the DAYS into other functions, for example in DATE function. Syntax =DAYS(end_date,start_date) Arguments End_Date- The end date to which one wants to calculate the number of…

Continue Reading
Close Menu