Завершен

excel project -- 2

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?

Навыки: Excel, Ввод данных, Обработка данных, Visual Basic, Microsoft Office

О клиенте:
( 13 отзыв(-а, -ов) ) New York City, United States

ID проекта: #30033082

Поручен:

mhgroup21

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 Больше

$15 USD за 1 день
(16 отзывов(-а))
4.0

29 фрилансеров(-а) готовы выполнить эту работу в среднем за $24

AccountantArman

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. " Больше

$30 USD за 1 день
(132 отзывов(-а))
6.2
naaz3303

I can do the excel caculations and provide you with pivot table to you. Please get in touch with me to get started immediately.

$50 USD за 1 день
(22 отзывов(-а))
5.1
borispetrovfrl

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 Больше

$30 USD за 1 день
(25 отзывов(-а))
4.9
jiansevillejo

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.

$15 USD за 1 день
(49 отзывов(-а))
4.4
Monirulop

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 Больше

$30 USD за 1 день
(25 отзывов(-а))
4.0
habalghost22

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 Больше

$10 USD за 1 день
(9 отзывов(-а))
3.6
hussain62333

,..........................................................................................................................................................................................................excel expert he Больше

$10 USD за 1 день
(2 отзывов(-а))
1.9
shaojin

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 Больше

$40 USD за 1 день
(0 отзывов(-а))
0.0
salanif8

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.

$16 USD за 6 дней(-я)
(0 отзывов(-а))
0.0
AnaHassan

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
azizyousfzai71

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 Больше

$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
pankajsalariapp

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
av605370

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
shivanikoyande

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.

$25 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Pravinn07

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.

$30 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
sujitnayak9559

I will done this work quickly and better because I am expert in data entry job I have completed your work in less time

$25 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
my593480

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

$10 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Abhibhatt305

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
adeshct

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.

$15 USD за 1 день
(1 отзыв)
0.0
omargalal131

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 Больше

$20 USD за 1 день
(1 отзыв)
0.0