excel project -- 2
$10-30 CAD
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
ID Projek: #32283920
Tentang projek
31 pekerja bebas membida secara purata $21 untuk pekerjaan ini
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 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
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
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
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
I am well versed with the task and can complete it efficiently within deadline. I'll be happy to work on this task
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
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.
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
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.
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
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.