Question: Please show the steps to solve this Financial problem. The Excel file is accessed by copy and pasting the link into another tab or browser.
Please show the steps to solve this Financial problem. The Excel file is accessed by copy and pasting the link into another tab or browser. Thanks

Excel File: https://1drv.ms/x/s!AnWxTJTVVD_IgQAE9HtWAQXun4Iu
Create your second PivotTable on a worksheet called Sales 2 using information from departments managers and sales. Setup the PivotTable on the Sales 2 worksheet so that it shows the sum of the Sales made for each department during each quarter. Format it so that it is in Accounting Style. Create a PivotChart using the PivotTable on the Sales 2 worksheet. Set up the chart using the clustered pyramid format. Have the chart be located on the separate worksheet. Be sure to label it appropriately. Create your second PivotTable on a worksheet called Sales 2 using information from departments managers and sales. Setup the PivotTable on the Sales 2 worksheet so that it shows the sum of the Sales made for each department during each quarter. Format it so that it is in Accounting Style. Create a PivotChart using the PivotTable on the Sales 2 worksheet. Set up the chart using the clustered pyramid format. Have the chart be located on the separate worksheet. Be sure to label it appropriately
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
