Project Summary For this project you will explore using Microsoft Excel to quickly reformat large amounts of data in an organized manner that would be usable to convey information. The data you will be working with is for Pierce County, Washington (Tacoma) and consists of approximately 50,000 data points. Learning Objectives During this project you should develop or practice the following skills: Creating a basic income statement. Making collaborative decisions within a work team. Using Microsoft Excel to manage and manipulate large amounts of data. Using Microsoft Excel to describe complex information visually. Tools Needed This instruction sheet Project 1 Dataset Spreadsheet (available on Canvas) Microsoft Excel (provided by the university as part of your Office 365 subscription) Access to the project instruction videos (available on Canvas) Instructions 1. Using the provided dataset and instruction videos, use Pivot Tables in Microsoft Excel to construct an income statement for the 2019, 2020, and 2021 years. 2. Reflect carefully on what fields you choose to use for your revenues and expenses on your income statement. 3. Add Sparklines to your income statement 4. Create at least one visual analytic in Excel that tells a story about your income statement. 5. Provide copies of your income statement (with Sparklines) and your analytic(s) in a Word document and address each of the following questions in less than one hundred words each. Requirements 1. What is the amount of revenue for the county for 2019-2021? 2. How much did the county sheriff spend in 2021? 3. Why did you select the revenue and expense names that you did from the various available options? 4. What are the pros and cons of having more or fewer revenue and expense line items on the income statement? 5. What is the story told by your visual analytic(s)? Deliverables An Excel spreadsheet including your income statement and analytics. A Word document including the following: o A screenshot of your income statement o A screenshot of your analytic(s) o Your written responses to requirements 1-5 above