Cerrado

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

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.

Habilidades: Excel

Ver más: sales data entry sample excel, excel worksheet data, excel worksheet data download, data entry excel worksheet, yahoo finance data feed excel worksheet symbols, sample profit loss statements excel worksheet, excel worksheet data comparision macro, excel data form sample, comparison excel worksheet sample, vbnet reading excel worksheet sample project, sample job excel list data, sample inventory excel sheet data, refresh web data excel worksheet, excel worksheet entering racing betting data, sample read excel worksheet using visual basic

Información del empleador:
( 0 comentarios ) India

ID de proyecto: #11909782

13 los freelancers están ofertando un promedio de $23 para este trabajo.

renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$30 USD en 1 día
(27 comentarios)
4.2
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
(2 comentarios)
1.6
Ibragim123

A proposal has not yet been provided

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

i am an excel expert but new to freelancer.com. i understand your req and its easy for me to finish it quickly. you will not be disappointed

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

I understand the value of excellent customer service and my experience will be an asset to your organization. My responsibilities includes account management, email handling, data entry (Spreadsheet) I handled about Más

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

Hi, I am a freelance IT Specialist in Excel. Very familiar with all listed formula and functions with some others. I will surely meet your requirements and give it the best possible. Thanks,

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

I am working as a Assistant professor in Engineering college around 4 years and also i have 2 year exp in electrical design and detailing engineering in that i was worked in various substation project and prepared Layo Más

$23 USD en 2 días
(0 comentarios)
0.0
starangel2015

Hey There !! We have seen the job post of yours and very interested to start work with you as we have delivered out the similar kind of web applications and we completely understand the subject of yours and what is Más

$26 USD en 16 días
(0 comentarios)
0.0
Speedywork31

I've got a very good skills and a long term experience of these works. I can type 35 wpm with 98% accuracy. I try to provide quality works within the mentioned time-limit and at an affordable cost.

$15 USD en 1 día
(0 comentarios)
0.0
$10 USD en 1 día
(0 comentarios)
0.0
$25 USD en 1 día
(0 comentarios)
0.0
vw1313054vw

I will deliver a satisfactory job that will impress you. I crave for a chance to prove to you my worth and abilities.

$25 USD en 1 día
(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
$25 USD en 1 día
(0 comentarios)
0.0
ExcelPatterns

I have more than 15 years experience in education I can provide a 100,000 rows data sheets with some variations with 500,000 rows and 1 Million rows I use a Thinkpad T440p with i7-4800MQ CPU (4 cores with 8 subpr Más

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