In Progress

excel project

Use the MaterialSales excel file in this folder to create a file with the following instruction:

Download the MaterialSales file.

Open it.

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

Skills: Excel

See more: simple excel project grade, download open office database report addon, excel project manage template web design, excel project task list, visual studio excel project, excel project help needed, excel project macro samples, peachtree excel project, excel project bid template, create excel project microsoft, create excel project board, free download open php project content change detection web page, create excel project accounting, create simple vba excel project, create critical path excel project, create reminder plugin on open project, open project for windows 10 free download, spacemacs open project folder, selected folder is not a talend open studio project

About the Employer:
( 0 reviews ) Brampton, Canada

Project ID: #32283914

Awarded to:


Hello, I have seen your requirements and the attached file, and I am ready to help you with your assignment. I am a Data Analyst with extensive experience in managing Excel spreadsheets, ETL techniques, data modelling, More

$30 CAD in 1 day
(9 Reviews)

3 freelancers are bidding on average $27 for this job

(37 Reviews)

Hey I can help you with your project. You will get the work on time. I can share the sample of my work too. Please message me for discussion. Please hire me through my profile link if you find difficulty in reaching ou More

$20 CAD in 1 day
(0 Reviews)