This project demonstrates the use of Excel for data cleaning and dashboarding. The data cleaning process involved removing duplicate rows, correcting errors, and filling in missing values. The dashboard was created using Excel's PivotTable and PivotChart features.
The data cleaning process involved the following steps:
- The Remove Duplicates feature was used to remove duplicate rows from the data set.
- Errors were corrected manually by reviewing the data set.
The dashboard was created using the following steps:
- The data set was imported into Excel.
- A PivotTable was created to summarize the data.
- PivotCharts were created to visualize the data.
- The dashboard was formatted to make it visually appealing.
The following tools and techniques were used in this project:
- Excel
- PivotTables
- PivotCharts
- Data cleaning
- Dashboarding
This project demonstrates the power of Excel for data cleaning and dashboarding. Excel is a powerful tool that can be used to manipulate data and create visually appealing dashboards.