I need an advanced excel user who can help me with a work -pivot tables, formulas
- or -
Post a project like this2849
$$
- Posted:
- Proposals: 14
- Remote
- #1195824
- Awarded
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
10253271934784864957812269634741050712122805012364401237383127791112824011294653
Description
Experience Level: Intermediate
General information for the business: sell products
Analysis tool: Excel
Description of analysis: Assume that you are the manager of some store chain. In excel you have some data about stores results (2 pages: Sale, Store).
Please answer the following questions and show you calculations:
1. Which shop have the biggest daily sale -> what store and when - date? How does it look in comparison to average
sale in this shop?
2. Which shop have sale in every day of the week?
3. What is the average daily sale for every store on working days?
4. Which shop have the highest number of non-working days?
5. Which shop have the biggest sale in May.
6. There are two assortment type store. What is average daily sale in every day of week for each assortment type?
• Please use the next pages in the same excel for you answers naming pages – N1, N2 etc. Please put the pivot table
with results and chart
Extra notes:
Analysis tool: Excel
Description of analysis: Assume that you are the manager of some store chain. In excel you have some data about stores results (2 pages: Sale, Store).
Please answer the following questions and show you calculations:
1. Which shop have the biggest daily sale -> what store and when - date? How does it look in comparison to average
sale in this shop?
2. Which shop have sale in every day of the week?
3. What is the average daily sale for every store on working days?
4. Which shop have the highest number of non-working days?
5. Which shop have the biggest sale in May.
6. There are two assortment type store. What is average daily sale in every day of week for each assortment type?
• Please use the next pages in the same excel for you answers naming pages – N1, N2 etc. Please put the pivot table
with results and chart
Extra notes:
Ionika V.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
23 Jun 2016
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Ionika,
Can you please send me a sample spreadsheet to use? I have an idea of how to optimise this.
Thanks
Alan -
Hi, Ionika
Can you send a sample of it??
Thank you in advance. -
Hi Ionika,
please send a sample.
Thanks
Ivan -
Do you have a sample file to use?
33056321353209831338
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies