Overview
This project uses sales and cost data for a fictitious cabinet hardware company, Cabinet Accessories Company (CAC). In this project, you (the student) will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, and create calculated columns. You also need to cleanse the data set by finding and correcting errors in the data set. In addition, you will create a pivot chart.
Project Resources
- Tutorial Project Requirements (Attached)
- Tutorial Data Set (Attached)
Directions
In Unit 3 (this assignment), you need to:- Access the CAC Project Requirements and Tutorial data set files.
- Respond to the project requirements using only the tutorial data set.