This repository is based on creating a pivot table in the Excel program. I was tasked to created one for a status update.
I was tasked to create a pivot table in the spreedsheet program, Excel. This pivot table was going to look at the color paint sales by the regions. It was used to in part of a status update.
I used the windows environment with the Excel program to complete this project.
This Screenshot was created from this project to show my starting point for this project.
This Screenshot was created from this project to show my progress of this project.
This Screenshot was created from this project to show the completion of this project.
I was amazed in my initial findings that some colors outsold others in certain regions of the country. I was glad to that this data was able to show me some useful insights.
There wasn't any major challenges for me. In Excel, there are many useful functions that allow to transform the worksheet into pivot tables and data visualizations.
When I was done with this project, I noticed it took a less amount of time. I was compairing the time spent with functions done in the python environment. Using the Excel program allowed me to focus on other projects.