pivot chart basics

I worked on this Pivot Table assignment during my third year of undergraduate school (Spring 2023) in a course called Data Journalism, where I learned the fundamental skills of handling data in Excel. In this project, I worked with a dataset containing sales records where the objectives included data cleaning, transformation and creating pivot tables. I ensured there were no missing values before adding filters and colors to each column to create a more organized structure, and made sure each column was correctly formatted. I provided key insights on three worksheets to analyze sales performance and the top three best-selling products (via pivot tables). Pivot charts were included on each sheet to visually display the different trends.