Đang Thực Hiện

Excel Programming for Sales Pipeline Report

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.

Thanks!

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.

Kỹ năng: Excel

Xem thêm: sales pipeline report excel, excel sales pipeline report, sales pipeline excel, sales pipeline excel spreadsheet, sales pipeline xlsx, sales pipeline report, excel pipeline report, excel sales pipeline, project pipeline excel, we excel, report programming, programming instructions, programming in excel, programming if, programming for excel, me excel, make me yellow, is programming for me, if programming, excel data programming, data programming, ask excel, excel columns sales pipeline, excel programming sales, pipeline report excel

Về Bên Thuê:
( 29 nhận xét ) Honolulu, United States

Mã Dự Án: #1044422

Đã trao cho:

bluefox4ever

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

$30 USD trong 0 ngày
(9 Đánh Giá)
3.5

37 freelancer đang chào giá trung bình $42 cho công việc này

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$50 USD trong 1 ngày
(57 Đánh Giá)
6.3
koolsidz

Please see PMB

$45 USD trong 1 ngày
(85 Đánh Giá)
5.6
fedalal2

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

$50 USD trong 1 ngày
(16 Đánh Giá)
4.6
torajiv

Details in PM Thanks

$30 USD trong 1 ngày
(25 Đánh Giá)
4.5
pyazlm

Refer to PMB.

$30 USD trong 2 ngày
(30 Đánh Giá)
4.4
manishadk

please view PMB for details.

$50 USD trong 1 ngày
(8 Đánh Giá)
3.5
muthumuni

Dear Sir Kindly see my massage. Thank you.

$40 USD trong 0 ngày
(6 Đánh Giá)
3.5
vgrichards

Very Good at Excel. Please allow me to do it.

$30 USD trong 1 ngày
(15 Đánh Giá)
3.4
LIMEXS

Please, Check my PM.

$30 USD trong 0 ngày
(4 Đánh Giá)
2.4
SilviaT

Please check PM.

$30 USD trong 0 ngày
(5 Đánh Giá)
2.4
pradeep1210

Please see PMB.

$45 USD trong 1 ngày
(1 Đánh Giá)
1.9
emce75

Hi, I've already done the formulas. Please see PM. Regards. emce75

$30 USD trong 0 ngày
(1 Đánh Giá)
1.8
pavanasamr

Hello, Please check your PM.

$50 USD trong 2 ngày
(1 Đánh Giá)
1.6
saranga86

Please see the PM.

$30 USD trong 1 ngày
(1 Đánh Giá)
1.3
IronButterfly

Hello, I can complete this quickly for you. Please consider me for you project.

$30 USD trong 1 ngày
(1 Đánh Giá)
1.0
gnsdesigns

I work in VBA and Sales reporting - day to day and would love to sort this out for you.

$75 USD trong 3 ngày
(0 Đánh Giá)
0.0
erickjohn

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!!!

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
simondlh

Hi there, I hope you will consider my bid. I'm keen to impress as I'm new on the site! Thanks Si

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
kcnkasun

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 Thêm

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
zatharis

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.

$50 USD trong 0 ngày
(0 Đánh Giá)
0.0