Narrative

Greenwich Workshop

Project Description:
You atomic number 18 an analyst for an art movement that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to channelise the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step| Instructions| Points come-at-able|
1| Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. | 0|
2| Sort the data on the Subtotals worksheet first by the reference towboat, then by the Art column, both in alphabetical order. | 4|
3| Subtotal the data at each multifariousness in Type. Identify the highest emergence price, estimated value, and percent increase.| 10|
4| Add an automatic outline to the Subtotals worksheet. Group the first and uttermost name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I).| 7|
5| Create a PivotTable on a refreshed worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. revalue, and reappearance Price fields and exercise the default locations in the PivotTable Layout.| 8|
6| Modify the make out Price and Est.



comfort determine to determine the average issue price and average estimated market value by type.| 6|
7| Insert a calculated field named % transfer in Value to determine the percent change in values by type. Format the values in the new column as percentages with two decimal places. Format the values in the Average of Issue Price and Average of Est. Value columns as accounting values with no decimal places.| 11|
8| Enter the custom name Average Issue Price for the issue price column. Enter Average Est. Value for the estimated value column. Change Row Labels in the first column to Art Type.| 3|
9| Set a trace filter to display only sold-out art. Filter the card to...If you want to get a full essay, order it on our website: Orderessay



If you want to get a full essay, wisit our page: write my essay .