MS Excel Portfolio Project

In my recent MS Excel project, I worked with a large data set to clean and transform it, and create meaningful visualizations to gain insights and support decision-making. 

To begin, I used a combination of formulas and tools to clean and structure the data. I removed duplicates, corrected spelling errors. I also used the "IF" function to categorize data based on certain criteria and remove any unwanted data.

Next, I created visualizations using pivot tables to analyse the cleaned data. I used pivot tables to summarize data, calculate averages, and compare different data sets. I also created pivot charts to make the visualizations more engaging and easier to understand.

Throughout the project, I paid close attention to detail and accuracy, ensuring that the data was organized in a clear and concise manner, and the visualizations were easy to interpret. By doing so, I was able to provide meaningful insights and recommendations to stakeholders, enabling them to make informed decisions based on the data.

Overall, this MS Excel project demonstrates my ability to work with large data sets, clean and structure data using a variety of tools and formulas, and create engaging visualizations to communicate insights effectively.