Attached to this project is a simple sales worksheet for "Sherrywhite Stationeries," where you can replicate what you've learned in this course.

Assignment:

You are to sort the names of the Rep alphabetically using the Sort Functions
Create Pivot tables and charts that you will generate insights from.
Design a new sheet for your dashboard
Collate you pivot charts on your dashboard
Insert slicer and Report connections.

Hints

For your pivot table that will be good enough for insights, Create tables containing columns:

Names of Rep and Unit cost

Names of Rep and Unit
Names of Rep and Region
Region and Total cost
Order Date and Items
Order Date and Total Cost

Note:

You can include more insights based on your discretion.

Project Submission:

Share your final dashboard with the class by uploading to the "Your Project" section. Please let me know if you have any questions or need more tips! I'm happy to help! Here's the image of the dashboard I created in the class

Johann

1

5