Advanced Excel task
$20 USD
货到付款
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.
项目ID： #12619089
关于项目
有8名威客正在参与此工作的竞标，均价$75/小时
Hi, I am good at Excel and vba. I have seen the file attached. Looking forward to discuss in the chat.
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 更多
Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.
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 更多
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
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 更多
