Build Excel Worksheet containing (sample) data of 100,000 customers

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado Pagado a la entrega

For learning purpose, Excel Sheet (2013) is required containing set of imaginary Raw data* having Equal & above 100,000 rows (or list of customers).

*Examples of data required:

i. List of customer names,

ii. list of customer numbers,

iii. list of franchises (having franchise code & names in single cell which will be split later in formatting phase),

iv. list of dates when customer visited various franchises,

v. list of purchases each customer made on particular date with time (split on later stage & along with formatting of date & time patterns),

vi. Sales agents names & their ID’s

vii. Sales agents monthly sales target

viii. Sales agents monthly actual sales result

ix. Etc etc

a) At least 30 easy (different) Statistical functions formulae are applied (may be to calculate sales, customers no., comparison of anything, visit counts, customer names proper format etc.) for e.g;

1. SUM

2. COUNT

3. COUNTA

4. LEN

5. TRIM

6. RIGHT, LEFT, MID

7. VLOOKUP

8. IF Statements

9. SUMIF, COUNTIF, AVERAGEIF

10. CONCATENATE

11. MAX and MIN functions

12. UPPER, LOWER,

13. PROPER proper function

14. now / date function

Etc

b) Functions like Pivot, pie chart, bar charts are applied to present data concisely & make it easy to read.

For the purpose of generating Excel sheet data having above requirement, you can suggest elimination of or addition of any data required to fulfill requirement of 30 different formulae & Pivot, pie/bar charts to be used.

Excel

Nº del proyecto: #11909750

Sobre el proyecto

11 propuestas Proyecto remoto Activo hace 7 años

11 freelancers están ofertando un promedio de $29 por este trabajo

sandroshubladze

Hello, I am VBA programmer Excel expert Have got bachelor degree in finance I can do whatever you like very fast and for a cheaper price So, feel free to contact with me and ask any questions you have. I made av Más

$30 USD en 1 día
(195 comentarios)
8.0
Rashid241097

Hi there, I'm interested in your project. There wasn't an attachment. I would like to know more. Don't hesitate to contact me. Thank you.

$100 USD en 4 días
(1 comentario)
0.8
ashwani1989

i have giving training to the students of MCA for excel. i have done with every noke and corner of the execl....

$20 USD en 1 día
(0 comentarios)
0.0
fouzsyed

I believe that im the best candidate for this position because of my skills in MS Excel and that im dedicated to the work given to me.

$25 USD en 1 día
(0 comentarios)
0.0
ankurdwivedi75

Hey i can complete this work in 2 days , with 100% accuracy..

$25 USD en 2 días
(0 comentarios)
0.0
thewrite2016

Just try us

$15 USD en 2 días
(0 comentarios)
0.0
aashimalik6619

LOWEST COST 100% ACCURACY I read your project description and carefully understood your need. I am sure I am able to complete your project requirements. I have done BS in Computer Science. I have also done a number o Más

$10 USD en 1 día
(0 comentarios)
0.0
vicky197835

Hi I can complete your project within your time limit without any errors I am already doing this type of work in my company with using excel and charting.

$25 USD en 1 día
(0 comentarios)
0.0
ltironi

Hello, I am a consultant for 9 years now, working for prestigious companies such as Capgemini Consulting. During my project I used Excel intensively, and the task you mention could be finalised within 1 or 2 hour Más

$25 USD en 1 día
(0 comentarios)
0.0
Annesaludares

Please consider

$15 USD en 0 días
(0 comentarios)
0.0