Functions and Formulas in excel (Most Popular)
In this video, we look at the 11 most searched formulas and functions in excel. Below is the timestamp index for the video in case you came here looking for a particular excel function or formula.
Link to the video's companion excel file: https://drive.google.com/open?id=1Z7G...
Video Index
00:46 - COUNTIF
03:00 - SUMIF
05:42 - VLOOKUP
07:50 - PERCENTAGE
08:50 - IF CONDITION
09:49 - CONCATENATE/ CONCAT
10:39 - SUBTRACTION
11:12 - ROUND
12:08 - INDEX
13:19 - MATCH
14:19 - INDEX-MATCH
Short description of all the excel formulas and functions we discussed.
COUNTIF
Purpose of COUNIF Function in Excel : Count cells that match criteria
The COUNTIF formula format is "=COUNTIF (range, criteria)"
SUMIF
Purpose of SUMIF Function in Excel : Sum numbers in a range that meet supplied criteria
The SUMIF formula format is "=SUMIF (range, criteria, [sum_range])"
VLOOKUP
Purpose of VLOOKUP Function in Excel : Lookup value in table by matching on first column
The VLOOKUP formula format is "=VLOOKUP (lookup_value, table_array, col_index, [range_lookup])"
IF
Purpose of IF Function in Excel : Test for a specific condition
The IF condition format is "=IF (logical_test, [value_if_true], [value_if_false])"
CONCATENATE/CONCAT
Purpose of CONCATENATE/ CONCAT Function in Excel : Join text together
The CONCATENATE/CONCAT formula format is "=CONCATENATE (text1, text2, [text3], ...)" or "=CONCAT (text1, text2, [text3], ...)" if using Excel 2016 and above.
SUBTRACT
The way to SUBTRACT in Excel : Subtract values
SUBTRACTION can be done using the format "=cell1 - cell2"
ROUND
Purpose of ROUND Function in Excel : Round a number to a given number of digits
The ROUND formula format is "=ROUND (number, num_digits)"
INDEX
Purpose of INDEX Function in Excel : Get a value in a table based on location
The INDEX formula format is "=INDEX (array, row_num, [col_num])"
MATCH
Purpose of MATCH Function in Excel : Get the position of an item in an array
The MATCH formula format is "=MATCH (lookup_value, lookup_array, [match_type])"
INDEX-MATCH
The purpose of using INDEX and MATCH function together in a formula: To lookup anywhere in a table using a unique value
The INDEX-MATCH combination formula format is "=INDEX (array, MATCH(lookup_value, lookup_array, [match_type]), [col_num])"
#excelformulas #excelfunctions #learn365