GETTING STARTED

• Open the file SC_EX19_CS8-11a_FirstLastName_1.xlsm, available for download
  from the SAM website.
• Save the file as SC_EX19_CS8-11a_FirstLastName_2.xlsm by changing the “1” to a
  “2”.
  
• PROJECT STEPS

1. Eva also wants to analyze May sales by product type. Create a PivotTable as follows:
   a. Create a PivotTable based on the Orders table.
   b. Place the PivotTable on a new worksheet, and then use May Sales by Product
   Type as the name of the worksheet.
   c. Use MaySales as the name of the PivotTable.
   d. Display the Product Type and then the Product ID fields as row headings.
   e. Display the Payment field as the values.
   f. Change the Number format of the Sum of Payment values to Currency with 0
   decimal points and the $ sign.
   g. Apply the Sky Blue, Pivot Style Medium 13 style to match the other PivotTable
   in the workbook.
2. Format the MaySales PivotTable to reduce clutter, as follows:
   a. Change the layout to show the PivotTable in Tabular form.
   b. Hide the field headers.
3. Porter 360 is considering whether to raise the price of each product by 10 percent. Add a
   calculated field to the MaySales PivotTable to show this increase as follows:
   a. Create a calculated field using Price as its name.
   b. The formula should multiply the Payment field value by 0.1, and then add the
   result to the Payment field value to calculate the increased price.
   c. Use Increased Price in cell D3 as the column heading for the calculated field.
   d. Use Current Price in cell C3 as the column heading for Payment field values.
   e. Resize columns C and D to their best fit.
4. Add a slicer to the MaySales PivotTable as follows to make it easy for Eva to filter the
   data:
   a. Add a slicer based on the Order Source field.
   b. Resize and position the slicer so it covers the range E4:F10.
   c. Change the slicer style to Sky Blue, Slicer Style Light 5.
   d. Use the slicer to filter the PivotTable to show only Hardware store data.