This is a self practiced microsoft excel repository
In this repository, essential functions used in data analysis are practiced
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
CONCATENATE
-
LEN
-
SUMIFS
-
IFERROR
-
SUBSTITUTE
-
REPLACE
-
MINIFS
-
MAXIFS
-
AVERAGEIFS
-
COUNTIFS
-
LEFT
-
RIGHT