Advanced Excel task

En curso Publicado hace 7 años Pagado a la entrega
En curso Pagado a la entrega

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 Entrada de datos Extracción de datos Excel Asistente virtual

Nº del proyecto: #12619089

Sobre el proyecto

9 propuestas Proyecto remoto Activo hace 7 años

9 freelancers están ofertando un promedio de $69 por este trabajo

cgullapalli

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

$100 USD en 2 días
(664 comentarios)
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 Más

$50 USD en 2 días
(139 comentarios)
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 en 10 días
(126 comentarios)
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 Más

$250 USD en 10 días
(15 comentarios)
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 en 0 días
(26 comentarios)
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 en 0 días
(17 comentarios)
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 Más

$20 USD en 2 días
(3 comentarios)
2.6