Experienced and professional advance excel user. Working extensively for more than 7 years on advance excel doing:
Date manipulations,
Data cleaning,
Feature engineering,
EDA,
Prescriptive and descriptive analysis,
Reporting,
Index, match, V-look up & H-lookup, (match, approximate match, exact match),
Complex if and nested if functions,
Logical parameters,
Interactive dashboards,(using developer tab, Dual Axis charts)
Subtotal,
Pivot table, (Level Of Details) LOD,
Data base functions,
Text functions,
Date manipulation,
Statistical calculations,
Null values,
Boxplot,
SD,
IQR range,
Sampling,
Forecasting, etc
Typing Speed >35 WPM.