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 freelancere byder i gennemsnit $21 timen for dette 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, I already read your file. I think I'm the best on in because I'm very well at Microsoft office and Excel also. I can submit it before your time line.
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