Project Title

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.

Data Cleaning Process

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.

Dashboard Creation

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.

Tools and Techniques

The following tools and techniques were used in this project:

• Excel
• PivotTables
• PivotCharts
• Data cleaning
• Dashboarding

Conclusion

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.