Advanced Excel task
$20 USD
Paid on delivery
I have an excel sheet which is a overview of our current projects, which is attached. One project per line.
• Column A display sale signed date for this project
• Column D display the name of sale person for this project
• Column G display the project total sale amount
• Column I display the salary earned from this project.
• Column J display date for first part salary payment
• Column K display amount for first part salary payment
• Column L display date for second part salary payment
• Column M display amount for second part salary payment
• Column E display name of project leader
I need some advanced filter features for this sheet. Ex filter multiple columns. I need ex to easy be able to filter/display:
1. What each sale person has been paid (first and second payment) for a selected month/year, specified by project lines
2. Total salary which have been paid to each sale person for a selected month/year
3. Total sale amount per sale person for a specified month/year
4. Total sale amount for a specified month/year
5. Make some sheets where this a being visualized by some nice looking graphs/diagrams
It`s important that I will be able to add new project lines in times ahead.
Task must be completed within 2 days time from the date task has been forwarded to you.
Project ID: #12762929
About the project
30 freelancers are bidding on average $23 for this job
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, Devel More
Hey there, I am a graduate of Bachelors of science in Software Engineering. I have done various projects of variants types for number of people. I am a developer with skills of professional level and I exhale in graphi More
I think i am best with my this work . I shall be grateful to you if you will gave me the chance to work with you , I know i am a beginner but I love my work . and in any effort i am going to satisfy you . Thanks
I am sure that I can do this job. I have skill and experience in data processing using MS Excel, include make a pivottable, make a dashboard report, and etc.
Hi, My name is Deepak Rathour, I can serve for all your needs for your Excel task of your given project. I offer you to chat with me so i can have a further understanding of your needs and requirements. Than More
Reading the content and making subsequent entries in Excel/Spreadsheet can be done with 100% accuracy. I have experience in putting basic formulas; conditional sorting and lookup; creating pivot tables and charts; crea More
Dear Hiring Manager, I am available to take this job. I have Microsoft Office and Data Entry Skills. I also have over 3 years work experience in data entry. Please contact me for details. Yours faithfully, Mw More
I'm reliable person. I can help you solve your problems with your file.I would like get more detail as well. Also i would like to know how many (aprox.) record do you have...
In June last year, I worked on an assignment that requires web research to find contact information of various business from a particular city and filled those entry into Excel Spread Sheet. I can do this job and finis More
Dear Client, Thanks for providing me this opportunity to place bid over the project and communicate with you. I mainly deal in web development, SEO, Android App, software testing and graphic design. Along with thes More
Hi, I am a free freelancer for your on-time delivery of your project. I'll offer 50% discount on the quoted price and deliver amid tight deadline,in exchange for a good review. Best regards, Problemsolverng.
I have been working with excel since I it was first intorduced. I can make a simple pivot table and help buttons to explain how to use with the filters that you list.
I think what you need is a summary pivot with the possibility to filter by desired categories and expand/collapse buttons to access the significant details. A simple refresh of the pivot will incorporate into the summ More