Build Excel Worksheet containing (sample) data of 100,000 customers
$10-30 USD
クローズ
投稿日: 7年以上前
$10-30 USD
完了時にお支払い
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.
Hi,
I have more than 14 years of Excel/VBA exp and I am expert in this kind of work.
I have completed more than 290 projects.
Please look at the feedback left by my employers to know more about my work. Waiting for your positive response.
Thanks.
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Here is the reason. Why you should pick me?
a) I am a very expert and have the same kind of experience of 5 years.
b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers
c) And most important part is my policy:
"I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me”
Please sir, leave a reply ASAP, as I am waiting for your kind reply
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 average bid just to reach to you so we can discuss details in private chat
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 650 small to medium businesses in the United States, where we deliver excellent customer service to our clients. I worked closely with CEO's, directors and decision makers. I talked to these high valued clients almost everyday. I possess a combination of skills and experience that will make me stand out from the crowd. I can do the job and will deliver exceptional results.