Find Jobs
Hire Freelancers

I need to create a consolidated excel dashboard from a number of separate dashboards

$250-750 USD

Zamknięte
Opublikowano około 8 lat temu

$250-750 USD

Płatne przy odbiorze
Description of excel work: I have a number of branches located at a single client's various premises. On a daily basis my managers capture HR stats into their Client's branch's template. I need to create a consolidated Dashboard using data from the various branches files. This will be performed on a monthly basis. I need the option to add or remove branches without breaking the consolidation formulae. I have created a template which the client has approved already (look and feel). Design and target audience: I will provide colour scheme, client logo etc Extra notes: - My client is in the financial service sector and data accuracy is of the utmost importance. - I propose to save the excel files in Dropbox and consolidate the numbers from there in a separate consolidation report - I would like to set cell validation rules so that the managers will not be able to capture alpha characters into numeric fields and vice versa. - At the moment the client has contracted our services at 11 of their branches, but this could expand / or reduce
Identyfikator projektu: 10379540

Informację o projekcie

38 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
38 freelancerzy składają oferty o średniej wysokości $445 USD dla tej pracy
Awatar Użytkownika
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.
$500 USD w 5 dni
5,0 (478 opinii)
8,0
8,0
Awatar Użytkownika
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 regards
$522 USD w 5 dni
5,0 (305 opinii)
7,3
7,3
Awatar Użytkownika
I am specialist in financial information and an expert in Microsoft Excel and VBA. With these experience and knowledge, I have built for over 25 years many Financial/Costing Reporting Systems and business plans modelled for small medium enterprise and global companies. I offer my support for implementing financial and costing tools in Microsoft Excel for small/Medium business. Areas of expertise: Visual Basic Application (Excel). Developing of consolidated financial statements applications, business plans modelling, feasibility studies and measurement reporting tools for global companies. Business valuation (NPV,IRR, DCF). Accounting, consolidating, forecasting, budgeting and costing.
$833 USD w 10 dni
4,9 (94 opinii)
7,5
7,5
Awatar Użytkownika
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. 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. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$300 USD w 5 dni
4,8 (192 opinii)
7,2
7,2
Awatar Użytkownika
Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent) with 5 years of experience in the field of accounts and finance. I have 8 years of professional experience in Microsoft Excel including working with financial modeling, dashboards and automation. Please contact with further details if interested. Regards CA Raghav Bansal
$388 USD w 5 dni
4,9 (95 opinii)
6,6
6,6
Awatar Użytkownika
Hello, My name is Chris and, as you can see from my profile, I have 15+ years experience working with Excel/VBA and 12+ years teaching them (all levels). I certainly can do excellent work with your project. I will need of course samples of the branch template files. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$450 USD w 7 dni
4,9 (75 opinii)
6,6
6,6
Awatar Użytkownika
I am Microsoft Certified Excel Expert. Let me know your requirement in detail and I should be able to help you.
$311 USD w 3 dni
5,0 (54 opinii)
6,1
6,1
Awatar Użytkownika
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$250 USD w 5 dni
4,8 (80 opinii)
6,1
6,1
Awatar Użytkownika
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I'll do your ms Access modifications. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD w 10 dni
4,7 (36 opinii)
6,0
6,0
Awatar Użytkownika
I have worked on excel/VBA/automation and can help you with requirement to complete your task. Looking fwd to get a response from you.
$555 USD w 10 dni
5,0 (9 opinii)
5,3
5,3
Awatar Użytkownika
Hi, Your project is in two parts. The first part is to check the values of the fields. I can put validation fields for this purpose, but you will likely come with different questions. The second part is about the consolidation. All files would be collected in a folder, and a macro will run, macro will take values from each branch and copy on the intended worksheets. I don't want to use macros for the first part, but we may have to do this, after negotiating further how to continue. I think it would take 3 days of my time, I gave the offer thinking about this. I will arrange the graphs taking new branches into account. So data ranges etc would be updated while the graph is being created. I have completed many projects more or less like this one, and I am sure that if I am awarded we won't have any problem. If you decide to award me please note that, I won't accept the offer, unless you verify your payment, and update other information. It would take my time, and I do not know you, during the development I will share you the files, and I don't want you lost during some phase in development. Best REgards, Serdar Yalcin
$560 USD w 10 dni
5,0 (24 opinii)
4,7
4,7
Awatar Użytkownika
Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am an experienced MS Office, VBA, Graphic Designing, PDF and Data Entry expert. Your kind response is being awaited.
$485 USD w 12 dni
4,9 (30 opinii)
4,6
4,6
Awatar Użytkownika
Greetings! I have 15+ years experience with MS Access/Excel/VBA, so technician part of your task is well known for me. Moreover, one is quit interesting for me, especially because some time ago I created something similar for HR statistics for group of restaurants. In that task we used another approach for consolidating data: every restaurant's responsible person just sent monthly reports to group's HR manager by email, mailing software filtered ones copying to separate folder, so, result Excel file collected data locally. Moreover, one checked if all remote reports are fresh, i.e. if the consolidated data are complete. It gave possibility to hide statistics of any restaurant against others. However, I describe it to let you know about one more option, not to insist on. One more restriction was that I cannot use any VBA coding, only formulas in cells (because different people use different versions of software, but VBA in not compartible, for example MS Office vs OpenOffice), so it is also possible in many cases. So, I'm ready to participate in your project, so please feel free to contact me. Looking forward to see both files' templates or specifications: for branches and for central dashboard. Regards, Sergey
$330 USD w 10 dni
4,9 (11 opinii)
4,5
4,5
Awatar Użytkownika
Dear Employeer, I have read your project description. I have completed many of this kind of projects in the past. I could do it in a short time. And since I have an experience, I can give more guidance to you in this project if required. Please let me know when shall we start work on it. Thanks!!!
$250 USD w 5 dni
4,6 (32 opinii)
4,3
4,3
Awatar Użytkownika
hi, We are a team of engineers that are working also as Freelancers, from Romania. We are more interested in customer satisfaction and rating than the financial part of projects. If chosen, we guarantee that we will finish the JOB within the deadline specified. Also, the payment is negotiable and we can discuss further about this aspect, if required. We have a many Macro/Visual Basic projects in Excel that we can show, if you want looking forward for your answer, Mihai
$278 USD w 5 dni
5,0 (7 opinii)
4,0
4,0
Awatar Użytkownika
Hi, I am having 20+ years industry work experience in the area of IT, Finance & Banking. Also, I have 3+ years of experience in Economics, Business Analytics and Advanced statistics projects using software such as R, SPSS, Minitab, Matlab, Excel Data Pack, AIIMS, etc. and statistical tools and methods such as Multiple Regression Analysis, Correlation, Market Basket Analysis, Linear Programming, Monte Carlo Analysis, Principal Component Analysis, ANOVA/MANOVA/ANCOVA, Time Series, ARIMA, ARMA, ARCH, GARCH and financial analysis such as Financial Projections, Ratio analysis, Balance sheet and P&L Analysis, Cash Flow analysis, Fundamental analysis and Technical analysis. I also have good knowledge and experience of Project Management tools and body of knowledge such as scope and time management, budgeting, critical path, and network diagram, etc. I have performed economic analysis such as Price and Demand, Prices and Production, Demand and Supply, Free Trade, National Income, Balance of Payment, Exchange Rates and relative prices, Equilibrium in Forex Market, Money, Interest Rate and Exchange rate, Aggregate demand, etc I am B.S c(Electronics), PGHDSM (Systems Management, NIIT), GMTP(Financial Management, ICICI), PGDM (Marketing, AIMA), EPBABI(Business Analytics and Intelligence, IIM Ranchi). I am sure; I will be able to take up your project most effectively, if given opportunity. It will be great to work for you. Requesting to share the details of the work asap. Thanks :)
$555 USD w 10 dni
5,0 (1 opinia)
3,5
3,5
Awatar Użytkownika
Hi, I'm very interested to work on this task you having right now. I have well experience and capable to done this for you. I will do all my best I can to complete on time and keep in mind to make you satisfied with the result I can provide. Message me as I'm willing to work it now. Thanks!
$250 USD w 5 dni
5,0 (5 opinii)
3,2
3,2
Awatar Użytkownika
Hello Sir, Being a Software Engineer i can do your job easily, i have 5 years experience with desktop application development, come to chat for detail conversation about your project. Regards Sibghat Ullah
$350 USD w 10 dni
4,8 (3 opinii)
3,0
3,0
Awatar Użytkownika
Hi there, I have 20+ years experience writing excel automation for my clients. I am available at your convenience to discuss your requirements or answer any questions you may have about my ability. I can provide references at your request.
$555 USD w 5 dni
5,0 (6 opinii)
2,9
2,9
Awatar Użytkownika
I am from engineering background having good English and computer knowledge. I can do it. You can hire me for that.
$277 USD w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga SOUTH AFRICA
Johannesburg, South Africa
0,0
0
Członek od maj 1, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.