Create Pivot Table(PLEASE SEE IMAGE ATTATCHED)

*Homework Help - Q&A from Onli x 3 Register | Pearson MyLab & Mast X Bb Excel Projects - Accounting Info X Bb Microsoft Word - Excel Project 1 X + C A newlearn.govst.edu/bbcswebdav/pid-582847-dt-content-rid-2490197_1/courses/ ACCT-3252-02_20FA/Excel%20Project%201%20Instructions%281%29.pdf G Excel Project 1 - Pivot Tables Many times, in the accounting field, you are given "raw data" to perform operations and prepare reports. In this assignment, you will prepare a pivot table and chart based on specific criteria. Before starting the pivot table, you will need to organize and format your data correctly 1. Open Raw Data file to "Txt." File in Notepad 2. Import Notepad file into Excel 3. Rename Excel file: Adam and Save 4. Sort file by Column A 5. Create Column Headers - Name, Address, City, State, Zip, Gender, Amount 6. Separate data as per columns 7. Convert Amount column to Currency format Create Pivot Table 1. Select the data 2. Create a pivot table from the following criteria: a. The data to collect is the following: i. Names ii. Filtered of the following Zip codes: 1. 53013, 53081, 53092, 53150, 60552 iii. Filtered of amounts greater than or equal to $10,000 iv. Filtered of Gender: M b. Items to be seen on your table is: i. Last Name, what zip code they are in, and the grand total amount per person. 3. Once you have your table formatted, create a Pivot Chart under the same criteria. + 9:33