Build Excel Worksheet containing (sample) data of 100,000 customers
$10-30 USD
Cerrado
Publicado hace más de 7 años
$10-30 USD
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.
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.
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.
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 of courses in MS Office. My typing speed is 50-60 wpm. I can do pdf conversion, image to word as well as excel conversion, online and offline data entry, data searching and extraction.
I have my personal laptop and a fast and reliable internet connection to done my work.
I assure you the 100% accuracy of work and honesty because I need this work more than you need a worker. Also I will complete work within time and I am available to start work ASAP.
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 subprocesses) with 16GB Ram and 1TB solid hard disk with 64 bit operation system proviving the best performance in Excel
Specialist in Humen Resources, Reail and many others markets.