Data Analysis using Excel

This project showcases my ability to clean and analyze a raw set of data using Excel to provide some meaningful results.

Cleaning:- Removing duplicates, Find and Replace, Number Formatting, IF, Nested IF

Analysis:- Conditional Formatting, creating Pivot table to answer some questions, using slicers, Sort and Filter

Functions:- Vlookup(), Match(), Sum(), SumIF()

Created a dashboard and implemented slicers to make it interactive.