I have an existing Sales Pipeline report (attached to this project) and I need formulas created to organize and sum the data.
We are currently using a combination of SUMIF and SUMPRODUCT formulas, but VLOOKUP-related formulas may be needed. Right now we have to manually adjust ranges to make the forumlas work whenever the data changes.
The attached xlsx file shows yellow highlights in the areas I need formulas created. The work to be done is:
1. Modify all formulas in columns named "Expected" so that the forumula automatically finds and calculates lines from source table that match the "Stage" for that row.
2. Calculate "Forecast Project" row, by month, using instructions highlighted in yellow on this line
3. Calculate "Forecast MRR" row, by month, using instructions highlighted in yellow on this line
4. Calculate "Forecast WS + SVR" row, by month, using instructions highlighted in yellow on this line
These instructions are easier to understand when you look at the spreadsheet. Please ask me if anything is unclear.
By the way, you can disregard the instructions (steps 1-12) in the spreadsheet, those are instructions for the salesperson who will enter data into the form.
Dear Hiring Manager, I want to do this "Excel Programming for Sales Pipeline Report" project now, let's start immediately. I have read the job description. Regards, Oliver
37 freelance font une offre moyenne de $42 pour ce travail
Hi, I have more 10 years experience with MS Excel and VB(VB.NET) so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
I can handle this project. I am a branch specialist in the bank where i am connected with and i used to work with advance office applications like MS excel. Let's get it done Sir/Madam!!!
Hi there, I hope you will consider my bid. I'm keen to impress as I'm new on the site! Thanks Si
dear Sir/madam, I could develop my skills in computer applications, customer care, Data Entry (record keeping), Web Designing & Photo editing & office communication (Office 2003/2007).I can able to carry out o Plus
Hello, I can provide the file in a matter of hours. I don't think no programming is required, just a few easy formula tricks. Have a nice evening.