Advance Excel
₹1500-12500 INR
Teslim sırasında ödenir
Specific Requirements
The data received from Vivino wine rating IT department comprises three data files: [login to view URL],
[login to view URL] and Region.xml. The [login to view URL] file records the information of wine list across the
world which detailed information about their ratings is recorded in [login to view URL] and [login to view URL]
records the country of each wine region.
You are asked to:
1 Import all the data from the other files into the Excel file. Write Excel formulas to fill the last
three empty columns in the [login to view URL] file with appropriate information provided from the
other files.
2 Assess the data and correct it if necessary. You are also required to use Excel functions to
automate the correction.
3 Investigate the data distribution of wine price by drawing its histogram and boxplot and
providing your insight.
4 The company wants to collaborate with the favourite wineries to expand its market. To
support managers’ decision making, you are required to:
a) Propose a ranking with at least 2 criteria to rank the wineries for the company to
choose for their next collaboration. Provide your justification.
b) Create a pivot table to show the best five wineries based on your ranking. Provide a
filter to allow users to narrow the result to a specific country that they are
interested. Display the list of the wineries in the descending order of your proposed
criteria, i.e. the best one first. Design the pivot tables to make it comprehensive
(having meaningful titles, column headers, applying appropriate data format,
applying conditional formatting, etc.)
[login to view URL]
Proje NO: #36676518
Proje hakkında
Bu iş için 27 freelancer ortalamada ₹7722 teklif veriyor
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Daha Fazla
Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to Daha Fazla
Expert in Excel: I am expert in Excel with Macros, VBA, HLOOKUP etc. and perform macro coding. I am a Chartered Accountant (UK) + PhD (Scholar) writer with 7 years of excellence Finance and Accounting experience of div Daha Fazla
Hi! Pleased to meet you on this platform. I just read through the job details and I'm available for this project. Let's discuss more on chat about your requirements and budget. Warm Regards. Bc
I understand that you are looking for someone to help you import and assess the data from the other files into Excel and correct any errors. Additionally, you would like me to provide recommendations on how to expand y Daha Fazla
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 Daha Fazla
I am an advanced excel user with over 12 years analytical experience in data analytics. From data normalisation, macros pivots and some VBA I will be able to provide the desired outcome rapidly
HI there! My name is Irene, and I am a CPA in the Philippines. I am excited to hear that you are looking for someone to help you with your Advance Excel project. With more than 7 years of experience in accounting, fina Daha Fazla
¡Hola! Leí su proyecto y me ha interesado. Buen manejo de Office, entrada de datos, analista qa, frontend, procesamiento de datos. Puedo comenzar de inmediato
Hlo sir/mam i am aditya i am here for your work and i have 2 year experience in this line and your work is my responsibility i do my work very honestly and if you give me this work so this is a big opportunity for me .
Hello, I am working in Amazon as catalog Associate for Poland and Netherlands. Expert In Excel feeds Expert In Handling Voluminous data. Expert In creating Automations and Macros.
I am experienced in advanced Excel and eager to propose my skills for the wine data analysis project. With 5 years of expertise, I will provide comprehensive insights and support decision-making. Here's an overview of Daha Fazla
Hello there! My name is Sandeep Kumar and I am a specialist in bookkeeping, data entry, data analysis in MS Excel, MS Word and other similar software. I have more than 9 years of experience in this field which makes me Daha Fazla
I am a dedicated, organized and hardworking person. I have good interpersonal skills. I know very well excel and word and data entry work. I will give you the project perfectly and as soon as possible.
Dear Client, I am delighted to hear that you are looking for someone to help you with your project related to Advance Excel. As a professional career oriented freelancer with 10 years of experience and excellent skills Daha Fazla
Hello there! My name is Muhammad Sheraz and I am a data entry specialist. I have extensive experience in data processing, Excel and other computer applications. With over four years of successful data entry employment, Daha Fazla
Hi Hope you are doing well. I'm Erastus and I've read the whole description of your work and I've seen that it needs someone with a great excel skills. I've been doing this for a while and I have the related skills and Daha Fazla
MY EXPERTISE IN ADVANCE EXCEL MAKES ME SUITABLE FOR THIS PARTICULAR WORK. CONSIDERING ME WOULD HELP YOU GET WHATEVER ANALYSIS YOU WANT.
Data analyste expérimenté et expert en Excel, je peux vous assister dans ce projet intéressant. Des expériences confirmées dans l'élaboration de modèle sur Excel comme la consolidation des données, le nettoyage et l'au Daha Fazla
Drawing on my extensive knowledge and expertise, I am certain that I can deliver the desired outcome within a maximum timeframe of two days. My experience includes working for the largest beverage company in the world, Daha Fazla
