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: #12619089
About the project
9 freelancers are bidding on average $69 for this job
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 More
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 More
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
Hi! I can complete your project in short time. It will take not more than some hours. I'm able to start right now!
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