VLOOKUP =VLOOKUP(103, A2:D6, 4, FALSE), =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

 - lookup_value: The value you want to look up.
 - table_array: The range of cells that contains the data.
 - col_index_num: The column number in the table from which to retrieve the value.
 - [range_lookup]: Optional; specifies whether you want an exact match (FALSE) or an approximate match (TRUE).

PIVOT TABLE
CHARTS
SUM
AVERAGE
concatenate
Switch
Aggregate
Sumproduct
Indexmatch
Filter and Sort
Conditional Formatting
Insert and Delete Column and Row
CTL + + to add Row and Column
CTL + - to remove Row and Colum
Find and Remove duplicate
Condition Formatting -> Highlight Rule -> Duplicate Value
Data -> Remove Duplicate
Merge and Centre
Wrap Text
Round Up, Round Down, Round
Autofill
Slicer
Drop Down