Develop a Data Table based Sales Pipeline Spreadsheet using some more complex formula
$30-250 USD
Dibayar saat pengiriman
I have a sales revenue pipeline spreadsheet with 12 months for monthly revenue plus a single probability column, an adjusted revenue column and a total revenue column. That's all easy and I can do that. What I want that's a bit difficult is a summary row at the bottom of the table that calculates the monthly adjusted revenue based on each rows revenue for the month times the rows probability into a single sum. I want for each of the 12 months. Then I also want it set up so that when a new account/project is added into the table anywhere between the firs row and the last row, the formula for total revenue, and adjusted revenue columns a well as the row with the adjusted monthly revenue all automatically adjust to include the data entered into the new row.
ID Proyek: #8930326
Tentang proyek
14 freelancer rata-rata menawar $69 untuk pekerjaan ini
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I'm a computer science professional with extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Lebih banyak
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. We will remove hidden helper rows in the file and will use a simple formula. The formula wo Lebih banyak
Hello, I am Excel and VBA expert. I can complete this project using macro. Please note that I have 100% completion rate and 5-star feedback on projects.
Hi, I am a scientist by profession with extensive experience in creating Excel platforms for reformatting and applying calculations to complex data sets. I believe that with a combination of formulas, named ranges a Lebih banyak
Dear employer, I propose to deliver you an updated template of the table including your requested calculation at the bottom of it as you request. Regarding your concern about it being updated when you create a new a Lebih banyak
Hi, I will help you to ldo your stats!!! Please contact me for this project. Thanks .................................................................................................................................. Lebih banyak
I am an expert in excel and formulas having more than 10 years of experience, Please consider me for the job, Looking forward to hear from you soon.
I have read and fully understood your requirements.. Please open chat to discuss further.. 88888888888888888888888888888888888888888888888888888888888888888888888888888888
Hello, I have a long time experience with data sheets and data processing, I'm a financial controller myself and I've done many templates for my department to make our job more efficient. I can guarantee you a precise Lebih banyak
Hi I have 10 years' experience working in London as an accountant, so I am highly proficient in using Excel for tasks such as the one you need completing. I also have a Masters in Information Technology from The Un Lebih banyak