Creating a PivotTable, PivotChart, and Trendline

Problem: You work for Altar Holdings and help the financial director prepare and analyze revenue and expense reports. He has asked you to create two PivotTables and corresponding PivotCharts based on sales data. One PivotTable and PivotChart summarize the sales by Supplier $($Figure $1).$ The other PivotTable and PivotChart summarize the Digital Products sales by month for the top supplier $($Figure $2).$

Perform the following tasks:

$1.$ Download and open the workbook Altar Holdings.xlsx from assignment box and then save the workbook using the name, Altar Holdings Complete $($your Name$).$

$2.$ Using the data in the Sales Results worksheet, create the PivotTable and associated PivotChart

shown in Figure $1$ in a separate worksheet in the workbook. Name the worksheet Sales by Supplier.

$3.$ Change the contents of cell A$4$ to Supplier and cell B$3$ to Store. Apply the $$Pivot Style Dark $21$style to the PivotTable. Format the values as currency values with a dollar sign and no decimal places. Apply the chart Style $14$ to the PivotChart. Resize the PivotChart to cover the rangeA$18$:G$35$ and then hide the field buttons.

$4.$ Create a second PivotTable and associated PivotChart, as shown in Figure $2$ in a separate worksheet in the workbook. Name the worksheet Digital Product Sales by Month.

$5.$ Change the contents of cell A$4$ to Month and cell B$3$ to Store. Apply the $$Pivot Style Dark $4$style to the PivotTable. Format the values as currency values with a dollar sign and no decimal places.

$6.$ Filter the category by Digital Products. Filter the store to O$.$G$.$s Wholesale Club.

$7.$ Change the chart type to Line and then add a linear trendline that forecasts the trend for three more months. Add the R$-$squared value to the trendline. Apply the chart Style $15$ to the PivotChart and then hide the field buttons. Delete the legend. Resize the chart to the range D$1$:H$16.$

$8.$ If requested by your instructor, add the text, contact number, followed by your phone number to cell B$66$ of the Sales Results worksheet.

$9.$ Save the workbook. Submit the revised document in the format specified by your instructor.

$10.$ How helpful is the monthly breakdown when analyzing sales of various products?