I need someone with strong excel experience who is ok with data entry but also experienced with pivot tables and formulas to do the following: I have 11 months of payment data in 11 separate tabs of the attached excel sheet. In the May ’17 tab I need two things done:
First, in the yellow section I need you to sum up all the transactions in rows 2,739 and above and put them in cells B2743:E2755. For example, in cell B2743, I need you to sum up all the amounts in column “J” where column “H” matches Cell A2743 (Student Loan Relief Network, Inc) and also where the amount in column J matches the amounts that I’ve hardcoded into cell B2742 ($39,$49,$78,$98,$117,$147, $156, $195).
Second, in the blue section I need you to count the number of transactions that match the amount in column A (A2759:A2784) where the name of the affiliate in row 2758 matches row H.
If you are interested in this job, only reply with “I have attached the completed May summary” and send me a dropbox link to the finished May’17 tab (so that I know you can do the other 10 tabs.)
"I have attached the completed May summary"
Dropbox : I will share Dropbox link
Hi sir
Appreciate to work with you in this project I have good experience in this type of project and I will finish it on time , I am cost engineer and using Excel in Advanced tasks..
Relevant Skills and Experience
I am cost engineer and using Excel in Advanced tasks.. and using Pivot table very well
Proposed Milestones
$22 USD - after finished
Additional Services Offered
$20 USD - If you want to add any type of charts to your reports
$24 USD in 1 day
5.0 (24 reviews)
4.9
4.9
25 freelancers are bidding on average $25 USD for this job
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
I can complete the updated for $25 in 1 day
Relevant Skills and Experience
18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month.
Proposed Milestones
$25 USD - Completely Updated Workbook
I am updating May 17 results and can share the same in 15 mins. if you can message me. Freelancers cannot initiate a chat on their own.
Dear Client,
I'm very much interest on this job.I hope i'm perfect for this job. if you provide this task i will proper complete your task on your dateline.
I can offer affordable, fair rate and high quality of work. My goal is to complete any task on time and to develop a long term relationship with my clients.
Waiting for your reply soon.
Thanks,
Emamul Hassan
I can do that, but I didn't because if I did, then I send you, you'll can simply copy my formula
Relevant Skills and Experience
I'm sorry, doesn't mean I don't trust you but seriously, as an example, do in a tab is equal to do all tabs, just copy paste. I am an excel expert
Proposed Milestones
$30 USD - Finish it quickly and customable for any other tabs or case
will do the task in 1 day with $25
Relevant Skills and Experience
very strong at data entry and excel sheet
Proposed Milestones
$30 USD - yes
Additional Services Offered
$0.01 USD - no service is added. will do in the same bid with any upgrade modification
when I can start working
I would love to do this project of yours and I am pretty sure I can do this job without error. Hope you would consider me. Kindly visit my profile for reference.
Relevant Skills and Experience
Data entry
Stay tuned, I'm is still working on this proposal.
Hello
Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years of experience in,Data Entry, Data Processing, Excel . I am a highly skilled provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills,I have completed 50+ projects in:Data Entry, Data Processing, Excel . I can achieve the results that you are asking for.
My main focus is to deliver good quaity work and i always interact with clients in a polite manner.i will dedicate my self for the assigned work/project.i can ensure 100% satisfation on time at satisfactory cost.
Regards
Irfan....