Data Cleaning and Transformation using Pivot table and Charts

I performed formatting the data and summarize sales (in terms of total sum of sales, average sales, standard deviation of sales, variance of sales, maximum sales, and minimum sales). In addition to this, also have to create a spreadsheet with information on fields status, product line, and sales using Pivot Table. From the concepts learned in the course, I am able to make customized ribbons, analyse the ordered quantities, present the data appropriately, clean the data, and highlight the top 10% of values using conditional formatting.