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;
6. RIGHT, LEFT, MID
8. IF Statements
9. SUMIF, COUNTIF, AVERAGEIF
11. MAX and MIN functions
12. UPPER, LOWER,
13. PROPER proper function
14. now / date function
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.
13 freelancers están ofertando el promedio de $23 para este trabajo
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,
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.