Find Jobs
Hire Freelancers

I need an excel expert with matrices

$30-250 USD

Imekamilika
Imechapishwa over 4 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
In the attached Excel spreadsheet, you will find two data tabs: ALL_range tab has a list of all “mother” SKUs in the portfolio with the indication of the lowest available price and the category of the SKU (ring, earring, necklace and bracelet); on the SALES tab you find all sales information per SKUs per a certain time period. Using 2 data tables provided in this spreadsheet, please build the matrix which shows what is the count of SKUs in each price segment per category and how much revenue and orders each combo (price x category) drive. The matrix needs to allow me to answer these questions: 1) What are the key price x category segments in the portfolio? Why? 2) Please make a recommendation on where (price x category) we can discontinue some SKUs and where we need to launch more products? Why? Notes: 4 Price segments are: <$100, $101 - $250, $251 - $500, $501+ Categories are: Ring, Earring, Necklace, Bracelet The data sets which are needed for this analysis are mother SKU count, Revenue ($) and number of units sold (#). There is much more information in those tabs then you need for your analysis. Only use what you need for the matrix. Please use revenue and unit sales on the net basis.
Kitambulisho cha mradi: 22834055

Kuhusu mradi

27 mapendekezo
Mradi wa mbali
Inatumika 4 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I checked the attached file and read the project description. I can build both formula and VBA based solution for you in excel for calculating the sales and sku's in each category which is defined by product type and the price segment. The result would be 2 matrices of dimension 4*4. One matrix containing the number of SKUs and one containing the net sales. We can then conditionally format these matrices so that it is more informative visually. I think I'll be able to fulfill all your requirements for this project. I look forward to a positive and prompt response from your side :) Regards Sourabh
$30 USD ndani ya siku 1
5.0 (136 hakiki)
5.9
5.9
27 wafanyakazi huru wana zabuni kwa wastani $148 USD kwa kazi hii
Picha ya Mtumiaji
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD ndani ya siku 3
4.9 (367 hakiki)
7.5
7.5
Picha ya Mtumiaji
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$200 USD ndani ya siku 3
4.9 (366 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 250 projects successfully completed here. Contact me to discuss the details. Best regards
$200 USD ndani ya siku 3
4.9 (241 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hello there, I am an Excel expert and I can create this matrix for your explanation. I think so. Please contact me. I will need some clear information before start. Thank you. Chien
$150 USD ndani ya siku 2
5.0 (183 hakiki)
6.3
6.3
Picha ya Mtumiaji
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
$250 USD ndani ya siku 6
5.0 (13 hakiki)
5.6
5.6
Picha ya Mtumiaji
Hi there, I can create you a dynamic matrix that will help you slice and dice your data easily and find certain trends in your skus performance. Furthermore, the dynamic matrix will have conditional formatting thus you can spot immediately unusual factors like the outliers. Please message me if this is any of you need, I’ll be standing by to help. -Reggie
$100 USD ndani ya siku 3
5.0 (18 hakiki)
4.7
4.7
Picha ya Mtumiaji
Hi, I can do this for you. 3 SKUs are missing in your all range (AU183,191 & 192)I can send you a picture of the initial matrix if you will contact through chat. Regards. Reuben
$50 USD ndani ya siku 1
5.0 (12 hakiki)
4.2
4.2
Picha ya Mtumiaji
Hello, Ive check the file, i did a draft version to discust the finals utilities that you will need. Fell free to ask for it to evaluate it. Regards, Juan
$80 USD ndani ya siku 7
5.0 (7 hakiki)
3.5
3.5
Picha ya Mtumiaji
Hello!! Am very interested in ur project and I'm an expert in Word/Excel/Excel Marcos/VBA/Visual basic/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
$30 USD ndani ya siku 1
5.0 (13 hakiki)
3.0
3.0
Picha ya Mtumiaji
Hi , I have read carefully your request.I am ready for your excel Job. I am expert and experience in MS Word,PPT, Excel also PDF. I will delivery your job on time and even before since. I will provide this job with 100% accuracy. Please send me a message to discuss more. I am ready to Start Right Now. Kind regards
$140 USD ndani ya siku 7
5.0 (2 hakiki)
1.5
1.5
Picha ya Mtumiaji
I am interseted do your work. I can give your work in half time that given by you. I want an aporchunity to do your work .It is an proud moment to do your work. I have an experince of 5 years in automobile company in insurence department
$140 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Expert in data entry Relevant Skills and Experience Data entry
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am expert in excel
$111 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, I am Reiley and as an engineer I am great at data processing in excel. I have experience working with matrices, and would love to help with the project. Send me a message if you have any questions.
$50 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I can handle a variety of tasks on a daily basis, use creative approaches to problem solving and be a good time management person and can work anytime. Relevant Skills and Experience I'm good in Microsoft office like Excel, Word, PowerPoints.
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I can help you step by step on your business. Please discuss your topics with me. Add me your chats to discuss different issues between the two.
$250 USD ndani ya siku 30
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am a Statistician with proper degree and bachelors from an eminent Institute. I am a data analyst also.
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Dear Employer, I have gone through your excel file. I am good at analysis. I am mechanical engineer. let us discuss in chat and i will prepare required matrix.
$150 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Experienced data scientist with a PhD in the area of data mining with 14 years of experience working for NHS (National Health System).I will produce a report answering your questions along with any necessary files.
$200 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi there, thank you for the opportunity. i look that you need freelance data analyst that can help you about statistical analysis. let me introduce my self, i am ardiansyah, i am an expert data analyst, especially in statistical analysis. i master a lot of statistical method and various kind of statistics software, especially R, STATA, SAS, and SPSS. although i am new in this platform, i have been in data analytic job since 2014, i have worked with a lot of client. if you're interested, i will send you the example if my previous work, maybe this file can be your consideration to work with me. Thanks a lot
$222 USD ndani ya siku 3
0.0 (1 hakiki)
2.1
2.1

Kuhusu mteja

Bedera ya UNITED STATES
fords, United States
5.0
1
Njia ya malipo imethibitishwa
Mwanachama tangu Des 12, 2019

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.