Suoritettu

Link & Configure MS Excel Sales Dashboard to my Excel Data file

This job entails linking an Excel Sales Dashboard, found on the internet, to my existing Excel Data file that contains customer sales data. The dashboard contains the following charts, Sales By Region (which my data calls Zones), Sales per product, Sales per Customer, Sales per Salesman, and there is a larger chart that can display all those fields and is user selectable and there is an annual sales comparison chart. Please take a look at the Sales Analysis Dashboard attached to see all the fields. The Dashboard appears to use the Excel IF Error, Sumifs, IF and Offset functions to link to the main data files. Due to the sensitive nature of my main data file I would like the freelancer to Teamviewer into my pc and do the changes there.

The current Dashboard, attached to this auction, only has 4 regions, 12 products, 12 customers and 12 salesman however I have 14 Regions (I call zones), 10 Salesman, 36 products and hundreds of customers. I would expect the Freelancer to compile the lists and link my data to the sales Dashboard and maintain the same calculations. Due to the larger amount of names my data contains under each sales field I would like the top row of charts to only list the top 10 products, Zones/Regions and Customers however we would keep the same design format as the Dashboard and be able to access all the data under the main selectable chart. For someone with advanced Excel knowledge this should be pretty straightforward.

Taidot: Excel, tietojenkäsittely, tiedonsyöttö, Microsoft Office

Näytä lisää: data multiple excel file single file, excel vba create data file, data text file excel, exporting data dat file excel 2007, resume pharma sales data reporting excel vba developer, extracting data mdb file excel file, need programmer importtext file excel data base, parse data text file excel, simple internet research data entry excel file, extract data pdf file excel, write xml data file using excel vba, link data internet excel, grab data different excel file, input data existing excel file, large data file excel project, link date receive date complete data excel, excel macro writers data file, script move data excel file excel file, convert stata data file excel file

Tietoa työnantajasta:
( 218 arvostelua ) Norwalk, United States

Projektin tunnus: #20197675

Myönnetty käyttäjälle:

Taisho

Hello, I can connect your data set with the existing dashboard through TeamViewer. I checked the attached file and everything seems clear. I have experience in creating and modifying dashboards, including proficiency Lisää

$70 USD 2 päivässä
(56 Arvostelua)
5.0

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lisää

$200 USD 7 päivässä
(222 arvostelua)
6.9
best4best

Hi, I have gone through the template and can link and configure it with you existing dashboard as per your requirement. Please take a look at my portfolio for Excel projects here: https://www.freelancer.com/u/best4bes Lisää

$100 USD 3 päivässä
(192 arvostelua)
6.5
mascotindia123

Hello, It would be great to get on board and support the growth of your company. I am great at data entry, very accurate and also experienced in databases - I know how important it is to have clean, well structured d Lisää

$140 USD 7 päivässä
(10 arvostelua)
4.9
daniyal3214

I can definitely help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to develop highly dynam Lisää

$70 USD 1 päivässä
(49 arvostelua)
5.4
Developer000

Feel fee to contact me forLink & Configure MS Excel Sales Dashboard to my Excel Data file .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to Lisää

$140 USD 3 päivässä
(15 arvostelua)
4.7
chintuag

Dear Hiring Manager, I have read the project details and have also gone through the attachments shared. I have worked on similar projects and would like to offer my services for your project. My expertise includes, b Lisää

$171 USD 2 päivässä
(7 arvostelua)
3.8
HarleyJohnson

I Will Do Data Entry,Data Analysis,Data Mining,Internet Research I specialize in : ? Offline and Online Data Entry ? Data Mining ? Data Analysis ? Copy Paste Task ? Data Capturing From Any Website ? Google Spr Lisää

$100 USD 5 päivässä
(3 arvostelua)
3.4
FlynnRider913

Hello I'm ready to start with you. I read your project details carefully. I have got good experiences with Excel. I can satisfy your requirement as you want, asap. I'm very interested in this kind of work and hope to w Lisää

$49 USD 3 päivässä
(5 arvostelua)
3.3
Rizwannader

I say only this work is very easy for me.

$31 USD 1 päivässä
(0 arvostelua)
0.0
Kathriny

Hello I have read your instructions and I am interested in the project. You won't regret ever working with me. I have worked as an operations manager, an admin clerk, and I also work as a IT programmer. I look forward Lisää

$100 USD 5 päivässä
(0 arvostelua)
0.0
riyan230

i am an sales analyst at one of cigarette industries Relevant Skills and Experience Sales Analyst

$166 USD 3 päivässä
(0 arvostelua)
0.0
sohaghasan592

i am xpert

$144 USD 7 päivässä
(0 arvostelua)
0.0
VikaKarlinska

Hi, why me? I am very fast doing with kind of work. Will be happy to assist you with your task. I have proficiency level of Excel. BR

$100 USD 5 päivässä
(0 arvostelua)
0.0
SPANDA185

my name is subhashis.i have 5 year experience in preparation of dashboard and excel dynamic work..Plse hire me

$61 USD 3 päivässä
(0 arvostelua)
0.0
wassima15

Dear Recruiter, I read your requirements and understand very-well I am familiar with Excel and Word spreadsheets and can get started right away. I look forward to hearing from you.

$100 USD 3 päivässä
(0 arvostelua)
0.0
brinesh27112000

i can do it because i am an professional in exel so its not an matter for me.

$111 USD 4 päivässä
(0 arvostelua)
0.0
manigokul430

I will get this job done right. Very fast and perfect will do it on time. Tell me it works like this I will complete the work THANK YOU!!!

$140 USD 7 päivässä
(0 arvostelua)
0.0
$55 USD 3 päivässä
(0 arvostelua)
0.0
$155 USD 3 päivässä
(0 arvostelua)
0.0
johnlatyarz

mndfbckdbljkvjkjdnvsydghdcnvvbfxgsncbjkhrjfbvbvscdmnbcjjbcftyfvxcxfavhuctyeiwrhfnchjhscvnsaxcxsfasacb f

$140 USD 7 päivässä
(0 arvostelua)
0.0