Home / Expert Answers / Computer Science / if-i-can-just-get-step-by-step-instruction-on-how-to-do-each-step-in-excel-that-would-be-amazing-a-pa932

# (Solved): If I can just get step by step instruction on how to do each step in excel that would be amazing!! a ...

If I can just get step by step instruction on how to do each step in excel that would be amazing!! all pictures of the assignment instructions and excel sheets are provided. I use a Macbook so when explaining please note that im using the apple version of excel. 1. On the "OrderData" sheet, turn the data on the left into a table named "OrderData." 2. Format column A to show in a Short Date style 3. Complete the "Subtotal" column by calculating the product of unit cost and units. 4. Use XLOOKUP or VLOOKUP equation to import the shipping cost based on the respective price found on the "Shipping Info" tab and prenamed table "Shippinglnfo." 5. Insert a new column "Tax" in column I. a. Calculate the tax on each order at a rate of 13 %, within column I. (please also tax the cost of shipping in the equation) 6. Calculate the total order cost in column J 7. Format all values that should be represented in currency to the currency data type. 8. Apply an appropriate colour scale conditional formatting to column J "Total". 9. In column O, use a formula to calculate the total amount of shipments containing each item. (ex. one order with 3 desks would be counted as 1) 10. Below, list each sales rep alphabetically, and use a formula to calculate their total sales from the month. a. Apply appropriate number and conditional formatting to represent this data.11. Convert the OrderData table to a PivotTable to be placed on the "PivotTable(s)" worksheet. a. Create a PivotTable that shows the total of each type of item ordered by the District. (one example of many approaches below) 12. Create another PivotTable from the OrderData table to be placed on the "PivotTable(s) worksheet. a. Create a PivotTable that shows the total amount of orders listed by OrderDate 13. Create a "Clustered Column" PivotCharts from your newly created PivotTables to be placed on the Dashboard worksheet. 14. Add your PivotCharts to your dashboard. a. Insert at least 2 relevant Slicers, connected to BOTH of your PivotCharts. 15. Apply some graphical formatting to your dashboard to make it visually appealing.

We have an Answer from Expert