- Identify areas inside the dataset that need cleaning, either for further analysis or visualization.
- Use a multitude of Excel features, functions and light VBA code to achieve this.
← Back to Projects
Data Cleaning
ExcelVBAPowerQuery
FIFA 22 Player Dataset
Clean-up with Excel & VBA
Multi-method data cleaning using Excel features, VBA macros, and PowerQuery — duplicate checks, date normalization, currency formatting, and conditional visualization.