please someone help me with this.

1. Create a new worksheet titled - "Q4 - Profit by Category" and insert a new pivot table for the data in the sheet - "Raw Data." Move the worksheet to the 4*h "position.

List the total profit for product categories and subcategories in this table.

Format the numbers to reflect the "$" symbol before the figures and 2 decimal places.

Change the column headings to be meaningful.

2.

Create a new worksheet titled - "Q6 - Qtr. Profit" and insert a new pivot table for the data in the sheet - "Raw data." Move the worksheet after the Q5 worksheet.

List all the Product Categories in the 1st column.

Split the Quarter across the categories [ Hint: Drag the Date field in the "Column Label" area]. To group the date by Quarter - Click on the date field. Next, right-mouse click to display a menu. Click the Group option. Another menu will display. Click on Months and Quarters.

Add the profit by category and quarter. Format the data in currency format.

Add meaningful column labels.

Add a meaningful title to the worksheet at the top and center it across the pivot table.

Select the Pivot Table and Click on Options> Pivot Chart

Insert a Column Chart of your choice.