Đã Đóng

Create 2 excel spreadsheets (formulas)

How can I possibly reach my sales numbers if I really don't know my ratios?

I need to create an Excel spreadsheet that can be used to automatically calculate my sales ratios for 2011 and every single year thereafter! Research studies have shown that if you consistently track and set daily, weekly, monthly and yearly sales goals you will mega-boost your sales success to the power of 10!

Do you know how to set up formulas and a spreadsheet in MS Excel?

This tracking spreadsheet should be so easy to use and takes just minutes a day to fill out. At the end of each sales day, all I need to do is enter my daily statistics such as the number of marketing calls (with total of attempts and completion), recruiting presentation calls, sourcing calls, first presentation on search assignment to a candidate for an interview calls, first presentation on search assignment to client for an interview calls, interview to follow-up calls, reference calls, follow-up calls on a search assignment for closing calls, and total number of telephone interviews and face-to-face interviews set.

I need to create a sales call activity spreadsheet in Excel. I need someone to figure out how to create the formulas that will tabulate running call totals daily, weekly, monthly and yearly.

I envision 4 tabs at the bottom of the Excel spreadsheet. Tabs identified as follows...daily, weekly, monthly and yearly (4 tabs).

When I (type) fill-in my daily calls activity, the numbers automatically tabulate running totals for the day, week, the month and the year.

I'll create a folder I'll title "Personnel Consultant's Self Performance Audit"

Within that folder I'll create12 additional folders - one for each month - JUN 11, JUL 11, AUG 11 and so on until the end of the year. Each monthly folder will contain that months activity.

Once I have successfully complied 6 to 12 months totals I'll then understand my ratios and the necessary daily activity to reach my weekly, monthly and yearly goals based those numbers.

This tracking sheet will instantly find the answers to these questions below:

How many marketing calls do I need to call to make a contact?

How many contacts do I need to reach to get a search assignment?

How many search assignments do I need to make a placement?

How many candidate calls do I need to make to set up an interview?

How many interviews do I need to make a placement?

What is my average placement fee?

Number of placements needed to reach my yearly income goal?

Kỹ năng: Excel

Xem thêm: create tracking spreadsheet excel, excel candidate spreadsheet, excel spreadsheets tracking sales call activity, month tracking spreadsheet formulas, spreadsheet interview, what is your goal, what is power up, what is marketing consultant, telephone interview questions, telephone interview, studies weekly, spreadsheet consultant, self consultant, search boost, sales & marketing consultant, sales interview questions and answers, sales interview questions, sales folder, sales and marketing recruiting, questions for interviews, questions for an interview, questions and answers for interview, power up 2, ms excel consultant, interviews questions

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

Mã Dự Án: #1075980

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

vserv

Pls see your messages. Thanks

$100 USD trong 3 ngày
(53 Đánh Giá)
5.6
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$130 USD trong 4 ngày
(40 Đánh Giá)
5.4
greggfletcher

Hello, i can help you with this project. If interested please contact me. Thanks.

$100 USD trong 3 ngày
(15 Đánh Giá)
5.2
FIBIN

Hi I am an expert in excel and VBA Coding in Excel. I have experience in doind small application products and business solutions. I can do this work in 2 days and deliver after a complete testing in 3 days. I can gu Thêm

$30 USD trong 3 ngày
(38 Đánh Giá)
5.2
gshiels

I am a Management Accountant with 20 years experience and use Excel for hours every day. I can certainly do this for you, possibly in one day, but certainly in two. I am trying to get started on this site, so would a Thêm

$100 USD trong 2 ngày
(11 Đánh Giá)
4.9
chriskerpini

Please check my PM.

$220 USD trong 30 ngày
(12 Đánh Giá)
4.4
kittu2906

hi, I am proficient in computer skills with good typing skills 55 wpm. and also i am having 3 yrs of work experience in data entry. Please give me one chance, i'll never disappoint you. Thanks Pooja

$110 USD trong 5 ngày
(8 Đánh Giá)
4.0
SaraHailes

UK qualified accountant. Have recently completed a similar project. Please see PMB for further details.

$125 USD trong 3 ngày
(3 Đánh Giá)
3.6
bluefox4ever

Dear stedman, I want to do this "Create 2 excel spreadsheets (formulas)" project now, let's start immediately. I have read the job description. Please send me more details of the job. Regards, Oliver

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

………..#####... “FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE” ...##### ……….. ...

$30 USD trong 1 ngày
(6 Đánh Giá)
3.5
nsurani

Very interesting project, love to work for you. We have both passion & expertise to do the job, well, within specified time & budget. Thank you.

$251 USD trong 5 ngày
(4 Đánh Giá)
3.1
uhostings

Take an experts advise , plz chk pmb !

$110 USD trong 3 ngày
(6 Đánh Giá)
3.1
SilviaT

Please check PM.

$100 USD trong 3 ngày
(5 Đánh Giá)
2.4
FirestarterXIII

Hi, I'm supply chain manager so I'm experienced in calculations of fill rates etc. I know excel very well and VBA macros programming. I'm the person which you're looking for.

$150 USD trong 3 ngày
(1 Đánh Giá)
2.4
sagnikpal

Hi, I am available immediately to work on your project & I already have past experience of such trend analysis. Please refer to attachment in PM & let me know if you would like to discuss this prospect.

$200 USD trong 3 ngày
(1 Đánh Giá)
2.1
KarrarRaza

I'm an expert at financial modeling. Please see PMB.

$90 USD trong 3 ngày
(2 Đánh Giá)
2.1
jacoby

Dear Stedman,I am an experienced financial accountant and excel expert in Sydney. I am quite interesting in your project please check pm for more details. Thanks. Jacob

$120 USD trong 6 ngày
(1 Đánh Giá)
2.0
mike121zz

Easy does it. Your project can be done in a week's worth of work. Go with safe bet choose USA!

$250 USD trong 6 ngày
(1 Đánh Giá)
1.0
ktmrakesh

ready to start . please check pm>

$50 USD trong 1 ngày
(1 Đánh Giá)
1.1
dsouchkov

please see pm

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