Find Jobs
Hire Freelancers

Excel Dashboard build

$30-250 SGD

Preklicano
Objavljeno pred več kot 5 leti

$30-250 SGD

Plačilo ob dostavi
TARGET PRICE IS <$75 USD FOR THE FIRST 2 DASHBOARDS. Hi - I'm looking for an Excel expert to build a couple dashboards. I will award this to someone in the next 24 hours and it needs to be completed by EOD Thursday Dec. The cleaned dataset and mockup pages are attached. Basically, the dashboards will display the order pipeline for 2019 and 2020. The bar graphs on the top half should change based on the filters that are selected in Rows 2 & 3. The "Top 20" list on the bottom half should update based on the same filters but will incorporate another filter that should not change the graphs. In the dataset, Column A is manually entered to indicate period. The dashboard will be updated very 2 weeks to show the original starting point (FW30 in this example), the current week, and 2 weeks prior. Old data will be deleted every 2 weeks. Columns AE to AJ are calculations to refine the data which is exported from our CRM system. Rows 2 - 31 (Green) are manually entered in and show the target for each individual ... the data may need to be split or re-organized to make some of the functionality streamlined. Key requirements: 1 - The mockups are simple designs for illustrative purposes. I will look to you to create a visually effective dashboard based on the mock up. For example, the number of columns or spacing between rows, etc. in the mock up do not have to be followed. I will update the color scheme later so minimum time should be spent of colors. 2 - The dashboard should be easy to update ... every week, I will copy and paste new data into the dataset sheet and rotate out the oldest data. 3 - the formulas should not be overly complex so that I can make changes on my own, if necessary. 4 - Macros should be kept to a minimum. There are 2 buttons which will require macros. Any additonal macros should be discussed in advance. We'll start this project with a call to answer any questions and further refine the requirements/scope. I have 3-4 additional dashboards that need to be created ... If everything goes well with the first 2, we will discuss extending this project. Thanks for reading and looking forward to working with you.
ID projekta: 18370646

Več o projektu

28 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VB and Macro) to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash Flow Projections, Budgeting and various other customized and tailored analysis and computations. I will be happy to discuss in detail.
$100 SGD v 1 dnevu
4,7 (83 ocen)
5,9
5,9
28 freelancerjev je oddalo ponudbo s povprečno vrednostjo $127 SGD za to delo
Avatar uporabnika
Hello, Hope you are doing well. I can help with you in your project Excel Dashboard build. I can assure you the quality job. I have good experience in Charts, Data Processing, Excel, Excel Macros, Excel VBA. We have worked on several similar projects before! We have worked on 425+ Projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. Thanks,
$180 SGD v 3 dneh
4,9 (388 ocen)
8,1
8,1
Avatar uporabnika
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$150 SGD v 3 dneh
4,9 (119 ocen)
7,1
7,1
Avatar uporabnika
Hello? How are you? I have good experiences in "Excel Dashboard build" as you can see my profile for these (Charts, Data Processing, Excel, Excel VBA). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 SGD v 3 dneh
4,8 (98 ocen)
6,7
6,7
Avatar uporabnika
Hello, I can build the dashboards you want with the functionality you want as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work and similar dashboards to the one you want. Thanks!
$80 SGD v 2 dneh
4,9 (55 ocen)
6,8
6,8
Avatar uporabnika
Hi, You won’t select the right candidate without knowing what your project on building Excel dashboard will look like. Fortunately, I can complete a part of your job before you award the project. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Excel 2. VBA 3. Data Entry 4. Data Processing 5. Chart I am passionate about flawless results and I can assure you of a job well done. Please refer to my reviews for more details. Looking forward to discussing the project details with you.
$150 SGD v 3 dneh
4,9 (64 ocen)
6,6
6,6
Avatar uporabnika
I have experience of excel , vba and dashboard, please review my profile. Mohsan
$250 SGD v 3 dneh
5,0 (92 ocen)
6,4
6,4
Avatar uporabnika
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$125 SGD v 3 dneh
4,8 (72 ocen)
5,8
5,8
Avatar uporabnika
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$150 SGD v 7 dneh
5,0 (20 ocen)
4,8
4,8
Avatar uporabnika
I am professional Data Entry Operator and high skilled for this project, so I am don your project timely.
$100 SGD v 3 dneh
4,4 (63 ocen)
5,1
5,1
Avatar uporabnika
Dear Sir/Madam, I would like to work for your project of dashboard development. I am having expert level knowledge in excel ,VBA or Macros,Formula,Coding etc. I have developed many dashboard. Please consider mu profile for this job and request to have faith in my proposal as I will be delivering you satisfactory and quality work. Thanks Gopal
$150 SGD v 3 dneh
5,0 (15 ocen)
4,6
4,6
Avatar uporabnika
Hi, I am an Excel Expert with very good knowledge of dashboard making, formula and VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
$133 SGD v 3 dneh
4,4 (46 ocen)
4,6
4,6
Avatar uporabnika
Hello, No data is attached. please send some example of data so that I can understand your requirement in better way. Hope you are doing well. I can help you in your project About me & what I can provide - • 5 Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • Have worked directly with client for an MNC IT Company. • HIGH ACCURACY. • Work in TIGHT DEADLINE. • Can start working IMMEDIATELY. • 100% SATISFACTION. • Minor modification possible even after Payment. Please ping me for more discussion.
$50 SGD v 3 dneh
4,9 (29 ocen)
4,0
4,0
Avatar uporabnika
Hello i am an expert in data analysis experianced in data visualization, i understand the requirement of this project, i can deliver quality work if awarded Regards
$77 SGD v 3 dneh
5,0 (6 ocen)
3,6
3,6
Avatar uporabnika
Hi, I can deliver it within the defined budget for 2 dashboards, and within 2 days. I reviewed the attached file, and read the job description thoroughly. I would recommend a PowerQuery+PowerPivot approach for this requirement, which would make it very easy to use, debug and maintain. This will also align with your goal of minimal vba. I have expertise developing PowerPivot based dashboards, and since I am an UX/UI designer, I go for pixel perfect alignment. Please review a few samples in my portfolio section. Request you to consider my proposal and let me know if you have any questions. Please note that, I am not a generic provider, and pay real attention to the project requirement, approach and my prospective clients to have a long term association. I would look forward to work with you on this project, and I can guarantee that you will not look elsewhere for any further similar requirements. Request you to initiate a chat so that I can give you an overview of the approach I am suggesting. Regards, Anish
$111 SGD v 3 dneh
5,0 (3 ocen)
3,3
3,3
Avatar uporabnika
Hi, Top rated Data Analyst, with several years' experience and over 50 completed research projects in Data analysis, data visualization, Data Entry, and Report Writing using R and Excel. I hold a BoS in FINANCIAL ENGINEERING. I would love the opportunity to complete your project and help your achieve your objective. Simplifications; 1. A detailed discussion to clear any misunderstanding. 2. You timeline and expectations on this project. 3. Any guidelines that you feel I should consider as I work on you project. Note; 1. I will always deliver your project on time 2. Don't worry about the price am flexible and open to discussion. 3. You can always reach me through the chat. Have a lovely time and thank you in advance. Thank you. Eric M.
$83 SGD v 3 dneh
5,0 (4 ocen)
3,5
3,5
Avatar uporabnika
Hi, honored to get in touch with you. if you decided to award me with this project "i hope :)" then i am offering the following: 1. USING EXCEL POWER QUERY, i will make excel read your data from an excel file or CSV and i will make it fixed so that every 2 weeks as indicated you can just replace the file with the new file "i will even make independent on the file name i will make excel read from a specific folder". 2. i will create a dashboard that meets your requirements but also it will be dynamic so whenever you replace the file in the specific folder and just refresh the dashboard then it will pick up the new data set. 3. minimum formula will be done on the power query, so you will find the end result all set. 4. no use of macros at all, all will be built using excel power query and it is Microsoft new way of doing any data analysis please note that this is transferable to Microsoft Power BI, and MS power BI is using the same power query, just in case you wanted to move to Power BI thank you and looking forward working with you
$50 SGD v 1 dnevu
5,0 (2 ocen)
2,1
2,1
Avatar uporabnika
Hello, I have good experience in data analytics and worked with large sets of data. I have built similar dashboards in my previous projects. Let me know if you would like to discuss more details about the project.
$222 SGD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi, I have 4 years of experience using Excel and developing macros/dashboards. I am happy to work on this project and am sure I can deliver in time. Looking forward to it. Thank you
$250 SGD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have 3 year advanced excel experience.
$111 SGD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
My Greetings, I will go down strictly straight down to the chase: 1. Your first two (Dashboard) Completion Task's Deadline Time is 4 days (to the next Thursday) 2. I will not write any "Macros", this is not how this it's actually named; It will be coded with using VBA inside Microsoft Excel. 3. I just saw your Excel Book with the three (03) Worksheets and It seems to me I nice and pretty easy project as well. See my whole profile inside VBA inside Microsoft Excel. I'll be waiting for your asking question if you have some before hire me. Keep in Touch, and Smile :)
$74 SGD v 4 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava SINGAPORE
Singapore, Singapore
5,0
9
Plačilna metoda je verificirana
Član(ica) od okt. 21, 2018

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.