excel project -- 2

Ditutup Disiarkan 2 tahun lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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

Excel

ID Projek: #32283920

Tentang projek

31 cadangan Projek jarak jauh Aktif 2 tahun lepas

31 pekerja bebas membida secara purata $21 untuk pekerjaan ini

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 dalam sehari
(16 Ulasan)
6.2
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 Lagi

$25 CAD dalam sehari
(65 Ulasan)
5.4
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 Lagi

$18 CAD dalam sehari
(2 Ulasan)
2.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 Lagi

$20 CAD dalam 2 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0
omarhamdy02

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

$15 CAD dalam sehari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$20 CAD dalam sehari
(0 Ulasan)
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 Lagi

$15 CAD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
0.0
elpicico

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

$20 CAD dalam 5 hari
(0 Ulasan)
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 Lagi

$20 CAD dalam 2 hari
(0 Ulasan)
0.0
Yadavji4140

I have skilled in Ms office as Ms Excel, Ms Word and Data entry and doing work from two years. I am very glad to do work for you. Thank you Sir.

$15 CAD dalam 2 hari
(0 Ulasan)
0.0
Pourmandp

Dear Sir or Madam, I completely read the structures and find out exactly what you want from this project. I am not only accurate, but also fast. Best Regards

$16 CAD dalam 10 hari
(0 Ulasan)
0.0
nataliajsilveira

I'm glad to help you with this project, in a very simple and forward way. I'm able to create all graphics, data sorter and formulas for your project.

$20 CAD dalam 7 hari
(0 Ulasan)
0.0
mgh7

Hi. I'm Mahdi. I have the necessary expertise in performing Excel projects from the beginning of data entry to analysis, as well as macro and vba projects, accurately and quickly, and I generally enjoy doing database Lagi

$30 CAD dalam 4 hari
(0 Ulasan)
0.0
wannurjannah

Hi there, I am really interested in working for your job. I read the information of your task project. It's fantastic that you wrote about the specifics of your job task and I able to do your job task. I've studied in Lagi

$30 CAD dalam 7 hari
(0 Ulasan)
0.0
aqilrushd

Microsoft Excel has been her companion since she first started her career in 2018 and still using it on her daily life. Sorting & analyzing data and information are her forte. Let her tidy your messy data in just few c Lagi

$20 CAD dalam 7 hari
(0 Ulasan)
0.0
jjphhh

Hello, I have gone through your project requirements, and I totally get what you want to do. I am very well versed with advanced excel functions so this task will be very easy for me, you can expect timely completion o Lagi

$10 CAD dalam sehari
(0 Ulasan)
0.0
KSaravind05

Hello sir, I hope your doing great.I have around 10 years of experience in civil material and procurement department & Excel. So i could deliver as per your expectation.

$10 CAD dalam 7 hari
(0 Ulasan)
0.0