Use the MaterialSales excel file in this folder to create a file with the following instruction:
Download the MaterialSales file.
If you see a yellow bar on top of your excel, click on "Enable Editing" so that you can use the file.
Create a new column for cost using this formula: Price=Sales/Quantity
Create a new column to indicate the salesperson. Use VLOOKUP and information from People sheet.
Use conditional formatting to identify the higher profits with green and lower profits with red.
Create a Pivot Table to show sales of each category for each year
Create a Pivot Chart (Column Chart) for the table that you created in step 4
Use the slicer to filter the data for Consumer segment.
Go back to the main data sheet and use the SUMIF Function in cell Z2 to calculate the Quantity of chairs sold.
Use the COUNTIF function to calculate the number of orders which are shipped with “Second Class”
Save and upload your file