Closed

excel project -- 2

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: create excel project microsoft, excel project 2/2, acc 2362 excel project 2, managerial accounting excel project 2, myitlab excel project 2, gmetrix excel project 2, ifsm 201 excel project 2, ifsm 201 excel project 2 2019, ifsm 201 excel project 2 if statement, excel project 2 answers, ifsm 201 excel project 2 step 18, excel project 2 ifsm 201, ifsm 201 excel project 2 pivot table, ifsm excel project 2, umuc ifsm 201 excel project 2, sam cengage excel project 2, excel project 2 ms excel (spring 2020), ifsm 201 excel project 2 (rental cars), simnet excel project 2-5, excel 2019 in practice - ch 2 guided project 2-3 download

About the Employer:
( 0 reviews ) Brampton, Canada

Project ID: #32283920

32 freelancers are bidding on average $21 for this job

(193 Reviews)
8.0
(215 Reviews)
7.0
(127 Reviews)
6.1
Ayo25

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.

$50 CAD in 1 day
(13 Reviews)
5.9
KarnMukesh

Hi Dear Client, Hope you are doing well. It's my pleasure to offer you my services for this quick project that's required to create reports according to the given requirement. I can make sure that the task will be p More

$25 CAD in 1 day
(65 Reviews)
5.4
(47 Reviews)
4.4
(8 Reviews)
3.7
(6 Reviews)
2.8
fahimkay

Hello Dear Client, Greetings... I have seen your attached file as understood the work requirement. I am sure that I am the right person to perfectly complete the project in short time with accuracy. Hope to hear you More

$18 CAD in 1 day
(2 Reviews)
2.3
(1 Review)
0.5
Velox509

Hi. I am very excited to offer you my work on this project. My skills are:data entry, excel expert, typing, translation, writing and many more that can be useful for you. I am also fully available to start the work and More

$20 CAD in 2 days
(0 Reviews)
0.0
tonnirdf

Hello Sir, I am very interested to do your job. I read your job project details. This is absolutely nice that you wrote about your job project details. And its clear. I am a experienced data entry operator for another More

$20 CAD in 7 days
(0 Reviews)
0.0
RonyAhmed96

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.

$18 CAD in 2 days
(0 Reviews)
0.0
omarhamdy02

it wouldn't take time, accept the bid and by the time you will receive the file.

$15 CAD in 1 day
(0 Reviews)
0.0
PROFMQS

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

$20 CAD in 7 days
(0 Reviews)
0.0
sandrokosevic95

Dear, I have a lot of experience with Excel and vba. I think i can help you to solve all problems with Excel. I am free for any question and if you like my biography contact me and you will not be disappointed. Best More

$20 CAD in 1 day
(0 Reviews)
0.0
venkateswaran24

I can do this workA job description summarizes the essential responsibilities, activities, qualifications and skills for a role. Also known as a JD, this document describes the type of work performed. A job description More

$15 CAD in 7 days
(0 Reviews)
0.0
archit164

I am well versed with the task and can complete it efficiently within deadline. I'll be happy to work on this task

$20 CAD in 7 days
(0 Reviews)
0.0
elpicico

i will do my best, ASAP, so please hire me ....,..............thank you ................

$20 CAD in 5 days
(0 Reviews)
0.0
sameersalve11

Hello sir/madam Let me introduce myself. My name is sameer salve I am certified data entry operator my work profession Data entry, typing jobs, ms word I believe in customer satisfaction, quality work and i'll More

$20 CAD in 2 days
(0 Reviews)
0.0