Advanced Excel task

Closed Posted 7 years ago Paid on delivery
Closed 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.

BPO Data Entry Data Mining Excel Virtual Assistant

Project ID: #12762929

About the project

30 proposals Remote project Active 7 years ago

30 freelancers are bidding on average $23 for this job

vsprybhanu

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

$25 USD in 2 days
(41 Reviews)
4.5
nevo1234

Dear sir there is no attachment to the job... I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requ More

$20 USD in 10 days
(5 Reviews)
2.9
mshahzeb43

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

$20 USD in 1 day
(2 Reviews)
0.9
jahanzaibahmed30

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

$20 USD in 1 day
(0 Reviews)
0.0
iwanhim

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.

$25 USD in 2 days
(0 Reviews)
0.0
anillachedia

i will do your work. plz send me your project thanx

$25 USD in 10 days
(0 Reviews)
0.0
dpkrathour7

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

$23 USD in 3 days
(0 Reviews)
0.0
sonalagrawalwk

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

$25 USD in 3 days
(0 Reviews)
0.0
mwansamatimba19

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

$25 USD in 10 days
(0 Reviews)
0.0
emydlo

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...

$30 USD in 10 days
(0 Reviews)
0.0
mehulpatel0619

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

$25 USD in 2 days
(0 Reviews)
0.0
Ricardo1010

I can deliver this in 2 hours maximum

$25 USD in 0 days
(0 Reviews)
0.0
hammadjk

Solution includes using dynamic subfilters or using VBA, which ever one you prefer.

$20 USD in 1 day
(0 Reviews)
0.0
COROZCOB

Hello is a pleasure hepl you with your proyect. I have abilities with: - Data Entry - Database - Logical Functions - Financial Functions - Dynamic Pivots - Charts for analysis Please chat me. Also I can More

$20 USD in 1 day
(0 Reviews)
0.0
amiyangshu12

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

$20 USD in 10 days
(0 Reviews)
0.0
problemsolverng

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.

$25 USD in 2 days
(0 Reviews)
0.0
paulbennington

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.

$20 USD in 2 days
(0 Reviews)
0.0
patilpravin19816

A proposal has not yet been provided

$25 USD in 10 days
(0 Reviews)
0.0
ioanadobrin

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

$25 USD in 2 days
(0 Reviews)
0.0
zare2204

Retired electrical engineer with a long experience in designing el. designs, executing electrical installations on site, making material and work specifications in excel with pricing, making time schedule and cash flow More

$25 USD in 4 days
(0 Reviews)
0.0