MicroSoft's excel has become must have skill for the tech aspirants.
Continuing daily use formulas from part 1...
COUNTIF: Counts the number of cells in a range that meet a certain criteria. Syntax: =COUNTIF(range, criteria)
SUMIF: Adds up the values in a range that meet a certain criteria. Syntax: =SUMIF(range, criteria, [sum_range])
HLOOKUP: Looks up a value in a table and returns a corresponding value in the same column. Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
CONCATENATE: Joins two or more strings together. Syntax: =CONCATENATE(text1, [text2], ...)
ROUND: Rounds a number to a specified number of digits. Syntax: =ROUND(number, num_digits)
ROUNDUP: Rounds a number up to a specified number of digits. Syntax: =ROUNDUP(number, num_digits)
ROUNDDOWN: Rounds a number down to a specified number of digits. Syntax: =ROUNDDOWN(number, num_digits)
INDEX: Returns the value of a cell in a specified row and column of a table. Syntax: =INDEX(table range, row number, column number).
SUMIFS: Adds up the values in a range that meet multiple criteria. Syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
AVERAGEIF: Calculates the average of the values in a range that meet a certain criteria. Syntax: =AVERAGEIF(range, criteria, [average_range])
AVERAGEIFS: Calculates the average of the values in a range that meet multiple criteria. Syntax: =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
IFERROR: Returns a specified value if a formula returns an error. Syntax: =IFERROR(value, value_if_error)
AND: Returns TRUE if all arguments evaluate to TRUE. Syntax: =AND(logical1, [logical2], ...)
OR: Returns TRUE if any of the arguments evaluate to TRUE. Syntax: =OR(logical1, [logical2], ...)
NOT: Returns the opposite of a logical value. Syntax: =NOT(logical)
TEXT: Converts a value to text in a specific format. Syntax: =TEXT(value, format_text)