As any seasoned Excel user will know, entering the data is only one part of the job, the next step is making that data speak so that you can make criticial business decisions based on the data input. We have compiled here the 7 most used Excel functions you will defintely want to remember.
Use VLOOKUP to look up and retrieve data from a table.
The Syntax for VLOOKUP is: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Use IF to make comparisons between a value and what you expect
The Syntax for the IF function is: IF(logical_test, value_if_true, [value_if_false])
Use SUM to add up a range of numbers
The Syntax for the SUM function is: SUM(range to be summed)
Use COUNTIF to count the number of cells that meet a criteria
The Syntax for the COUNTIF function is: COUNTIF(range, criteria)
Use SUMIF to sum the values in a range that meet a specific criteria.
The Syntax for the SUMIF function is: SUMIF(range, criteria, [sum_range])
Use CONCATENATE to join two or more text strings into one string.
The Syntax for the CONCATENATE function is: CONCATENATE(text1, [text2], …) To add spaces or punctuation, type the item inquotation marks between the cells or values you want to connect.
Use AVERAGE to retunr the average of a range of numbers.
The Syntax for the AVERAGE function is: AVERAGE (number1, [number2], …)