Challenge

Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

i. Split the productcode field into two using text functions Example :S10_1678 -> S10 in one column and 1678 in another column.

ANS : I have done in Sales Data Sheet

j. Highlight the top 10% values of QuantityOrdered field using Conditional Formatting

Ans : I have done in Sales Data Sheet

g. change values of 2003 to 2019, 2004 to 2020 and 2005 to 2021 by using proper date formatting options.

ANS : I have done in Sales Data Sheet

Ship work like this
in your own course.