excel project -- 2
Buget $10-30 USD
Job Description:
1 Remove all formatting including filters from the data in the file
2 Create a pivot table to show all clients by region and the sum of their annual income.
3 Create a pivot table to show all clients by region with the average of their annual income.
4 Create a pivot table to show all clients by region and ownership with sum of their total purchases.
5 Create a pivot table to show all clients by region and ownership with the sum of their annual income and the average of their total purchases.
6 Create a pivot chart to show the data in 2 without the grand totals
7 Create a pivot chart to show the data in 5 without the grand totals
8 Create a pivot table to show all clients by region, ownership and annual income with the sum of their total purchases and the average number of their purchases. Then answer the following questions (Note: you will have to do and show more calculations in the pivot table):
(a) Which region has the renters with the highest annual income and the largest average number of purchases?
(b) Which region has the owners with the smallest annual income and the smallest average number of purchases?
(c) Which region and ownership have the clients whose sum of total purchases is closest to the median of the sum of the total purchases for all clients?
(d) In which regions do renters have a higher percentage of the sum of total purchases than owners?
Acordat lui:
Dear client, I have sound knowledge in excel and analytics. Also, I previously carried out a number of projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my p Mai multe
29 freelanceri licitează în medie 24$ pentru acest proiect
Sir, you will be satisfied in all of your requirements including pivots table. I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. " Mai multe
I can do the excel caculations and provide you with pivot table to you. Please get in touch with me to get started immediately.
Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Pro Mai multe
Hi, I can help you with your file. I have advanced knowledge of Excel's formulas, pivot tables, charts and visual basic coding. I'm willing to discuss more about your project.
Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love Mai multe
Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, vba and Python. Being an analyst, this task would be easy for me as I work on excel and vba day in and day out. Looking forwa Mai multe
,..........................................................................................................................................................................................................excel expert he Mai multe
Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA. I will finish your Excel VBA project in time with high quality Hope your Mai multe
Dear Sir / Madam, I understand your project and like to work with you. I am experienced in this field and would like do the work regarding to your requirements. . Regards.
hi im well experienced in handling data, being involved in research field as research assistant and research officer approximately for 5 years. im really meticolous person which is an important criteria when handling d Mai multe
Hi, your job description caught my attention because it exactly matches my skills. I will remove all unneccessary data and keep remain pivot data & Chart. I have 5 year experience as data entry operator and I’m expert Mai multe
I am Data Entry Operator. With good knowledge, I have done our work. I will assure to do your work with 100% accuracy. I have 2 years of experience as a Data Entry Operator and Trainer. If you are interested in any of Mai multe
I have just finished with a project, and do not have any more in the pipeline at the moment. If I am hired for this project, I will be able to give it my full attention and will deliver on time. Apart from this, I poss Mai multe
The project will take place and completed on google data studios. A dashboard will be created that will be enticing. The project can be done in 2 days, 1 extra day is a buffer.
I am sufficient to do this work. I have experience to do this work.I do this work very pure and clear. I do this work like you give extra tip for this work.
I will done this work quickly and better because I am expert in data entry job I have completed your work in less time
I understand you project. and can do this on time i have 4 years of work experience in data entry and web searching. with good skills. and will timely submit it to you . Replies within a few minutes
I have good skills to this work more effectively and efficiently in given time. I am 100 percent capable to do this this work with an ease. Hope you will address Mai multe
I can get this project ready for you within 3 days. I will be able to complete all the pivots you asked for and all the questions you asked will be answered.
Hi I've read the task well, I'm the right person for the task, my Excel skills are excellent. I've got a certificate in a specialization In Excel from Macquarie university from Australia, I can perform your task and d Mai multe
