Challenge

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

applied times new roman as font, gave all borders, and gave left most alignment.

solved (b) & (c) in the existing sheet "sales_data" at location AD4, AJ4.

created ABC tab and added data formatting tools.

solved (e) & (h) in two different sheets namely (E) & (H).

solved (f) & (j) using conditional formatting.

split productcode column into two different columns using text functions.

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.