Advanced Excel task

In Progress Posted 7 years ago Paid on delivery
In Progress 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: #12619089

About the project

9 proposals Remote project Active 7 years ago

9 freelancers are bidding on average $69 for this job

cgullapalli

Hi, I am good at Excel and vba. I have seen the file attached. Looking forward to discuss in the chat.

$100 USD in 2 days
(664 Reviews)
7.7
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$50 USD in 2 days
(139 Reviews)
6.5
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.

$20 USD in 10 days
(126 Reviews)
5.8
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d More

$250 USD in 10 days
(15 Reviews)
4.8
Ramez125

Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards

$20 USD in 0 days
(26 Reviews)
4.4
Excel4You

Hi! I can complete your project in short time. It will take not more than some hours. I'm able to start right now!

$20 USD in 0 days
(17 Reviews)
3.7
alteregoanne

You should hire me because I can be your partner to success. My profile is new but I have a 6-year experience in back-office supportand data processing. I take initiative on my tasks and make sure they are delivered w More

$20 USD in 2 days
(3 Reviews)
2.6