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
32 freelancers are bidding on average $21 for this job
I am a data entry specialist and statistician. I have advanced knowledge of Microsoft excel and R language. Please check out my portfolio for my past projects and reviews.
Hi there, I have checked the instructions I can assist with this excel project, i have more than 6 YEARS working on excel projects and using formulas. Please feel free to connect. Thanks & regards. Yassine