In this project, we employ formulas and pivot tables in Excel to conduct an analysis based on specific questions. Our exploratory data analysis includes using conditional formatting. We also identify if there are any anomalies in the data.
In this project we use Excel formula to clean the data, then create a pivot table for easy analysis and visualization, resulting in a presentable chart.