Build an Excel Spread Sheet to track Sales Goals

Terminé Publié le il y a 4 ans Paiement à la livraison
Terminé Paiement à la livraison

I require a basic Excel spread sheet to track sales data over the 2020 calendar year on a fortnightly basis. The file 2020_GoalTracker provides an example of the layout and required fields for the new spread sheet. The second file (Copy of WIP) is a previous Excel workbook that we have used to track sales data to provide an idea of what we are after.

Required :

- all fields in red need to accumulate each fortnight

- date column needs to be fortnightly and end at or close to 31/12/2020

- The Targets listed across row 5 all need to be adjustable and feed into the lower tracking categories ie if i changed L5 to $550,000, C26 would need to auto-calculate to $21,153 and accumulate going forward

- The spreadhsheet needs to look modern and user friendly, you can add your own ideas, colors, concepts to make it work (company logo colors and design cannot be changed)

I can be contacted anytime for further info.

Nick

Excel

Nº du projet : #23469964

À propos du projet

23 propositions Projet à distance Actif il y a 4 ans

Décerné à:

IgeS

Hi there, There are four cells (column C) that are linked or dependent to the fields in the target (row 5). After that these targets are doubled fortnightly. We can locked these cells after nesting the formulas in it Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 2 jours
(45 Commentaires)
5.4

23 freelances font une offre moyenne de 68 $ pour ce travail

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you to build an Excel Spread Sheet to track Sales Goals please ping me now for discuss more and im free now Sir Thank you Galih :)

$100 AUD en 7 jours
(412 Commentaires)
7.6
Devrits

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects Plus

$100 AUD en 7 jours
(64 Commentaires)
6.2
Muhammad6979

Hello, Dear Sir/Madam, You can see my profile I do have the relevant skill and can provide you up to the mark services within the time frame mutually agreed. Thanks & Regards Muhammad Ilyas Saeed

$40 AUD en 7 jours
(115 Commentaires)
6.3
paulodayto08

Hi Good Day! A serious freelancer here. Please allow me to help you. I can make it automated using VBA Macro. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly Plus

$100 AUD en 3 jours
(76 Commentaires)
5.4
fastwork86

I am Sumit Choudhary. I saw your requirement for an excel vba expert. I have done many projects in excel. Can send you sample if needed. Do let me know if we can take this forward

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
3.8
OgechiS

Hello, I have carefully read your project description and totally understand its requirements. I can assure you that I can prepare the desired spreadsheet within the stipulated time. I place your project as my outmos Plus

$50 AUD en 2 jours
(17 Commentaires)
3.7
Salmandaud

I am an Accountant with more than 10 years of experience including preparation of different management reports and variance analysis. I can design a dashboard for easy understanding and tracking fulfilling your require Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(9 Commentaires)
3.5
ssuet123

Hey Nick Hope you are doing fine. I have full fledge knowledge of Microsoft Excel, Word, Powerpoint, OneNote, etc, etc. I have done enough job in creating dashboards using pivots, creating graphs, and formulas, data Plus

$100 AUD en 2 jours
(3 Commentaires)
3.1
aliikhlaq2006

hello, I am ready for a basic Excel spread sheet to track sales data over the 2020 calendar year on a fortnightly basis. The file 2020_GoalTracker provides an example of the layout and required fields for the new sprea Plus

$40 AUD en 2 jours
(3 Commentaires)
0.6
shimulahemed3116

I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind response.

$70 AUD en 7 jours
(0 Commentaires)
0.0
sagniksengupta09

I am a fast typist and I can complete your faster and please give me one chance to prove myself please and I am good in excel

$88 AUD en 7 jours
(0 Commentaires)
0.0
Mafzalca

1. QUALIFICATION I am young qualified professional having certification in the field of Chartered Accountancy (CA) and MBA (Finance). 2. EXPERIENCE Initially I started from Data Entry, Bookkeeping and gain expertise in Plus

$40 AUD en 7 jours
(0 Commentaires)
0.0
pereragayan160

Hi. I read your job description and I can absolutely help you out with it. I'm confident that I am the best person for this job and I Will make sure I do my very best and make you satisfied with the work. Feel free to Plus

$70 AUD en 2 jours
(0 Commentaires)
0.0
anuragbarve8

Hi Dear... I have read and understood all your initial requirements, and I feel, I would be the best choice for this project, I have more than 1 year of working experience in the industry. I am producing quality conte Plus

$70 AUD en 7 jours
(0 Commentaires)
0.0
mikefloresm

Hi, I will be glad to assist you with your project. Please contact me by chat for help you. Have a Nice Day

$40 AUD en 7 jours
(1 Évaluation)
0.0
Hannachan19

I am pretty sure that I can do the project accurate at a speed of 40-45wpm. I am using Excel for almost 10 years. I am data entry here in the Philippines. Relevant Skills and Experience -Convert word file into excel o Plus

$55 AUD en 2 jours
(0 Commentaires)
0.0
Amityesugade

I have well experience in this data entry. well in planning and making tracking sheet.. You will be satisfy in this work Regards, Amit Yesugade

$80 AUD en 7 jours
(0 Commentaires)
0.0
fmnasir01

Hi, I can do your work, according to your preference. I am very much interested in your project and would like to invite you for further discussion over chat board. Waiting for your positive response. Plus

$40 AUD en 3 jours
(0 Commentaires)
0.0
samshunnahar

Dear Sir, This is Samshunnahar, an Excel Expert would like to work with you. I have 2 years experience on MS-Word, MS-Excel and data Entry. I think, I am good fit for this job. I read project description carefully and Plus

$50 AUD en 5 jours
(0 Commentaires)
0.0