Key Responsibilities:
- Data Collection and Importing:
- Collect, import, and Manage large Datasets from various sources into Excel.
-Data Cleaning: Identify and rectify errors, including duplicates, missing values, and formatting inconsistencies.
-Skills and Qualifications:
- Proficient in Microsoft Excel, including advanced functions and formulas
-Data Cleaning
- Excel Functions and Formulas (VLOOKUP, HLOOKUP, IF, SUMIF, etc.)
- Data Validation
- Data Visualization (Charts, PivotTables)
- Removing Duplicates
- Handling Missing Values
- Text Standardization (UPPER, LOWER, PROPER)
- TRIM Function
- Data Import and Export