Find Jobs
Hire Freelancers

Build a Complex Excel Workbook with Dashboard

$500-1000 USD

Zamknięte
Opublikowano ponad 5 lat temu

$500-1000 USD

Płatne przy odbiorze
Hello everyone, We need an Excel expert to build us a few complex Excel workbooks including dashboards, VBA, pivot tables and so on. (financial knowledge would be helpful) This workbooks will be used by executives and small business owners, so it is important that it looks quite sleek and professional. This job opening is for the first workbook: Basically, the user retrieves his/her inventory data from SAP (or any similar ERP software) and want to input this raw data into our workbook. Our template should take this data and process it with necessary tools such as pivot tables, formulas and VBA. (the workbook should have a robust and clean structure in the background) After putting the raw data, user wants to see the results on a dashboard supported with some pivot charts. For the development of following workbooks, we want to work with the same person if he/she can do this job well enough. The first job is not super urgent (3-4 weeks should be fine). For those who are interested, please fill in and submit this form: [login to view URL] Please write the keyword in the beginning of your application so that we understand you've read the job description (keyword is in the form above) Thanks!
Identyfikator projektu: 18058580

Informację o projekcie

46 ofert
Zdalny projekt
Aktywny 5 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
46 freelancerzy składają oferty o średniej wysokości $773 USD dla tej pracy
Awatar Użytkownika
Hello, Hope you are doing well. I can help with you in your project Complex Excel Workbook with Dashboard. I can assure you the quality job. I have good experience in Data Processing, Excel, Financial Analysis, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$1 000 USD w 6 dni
4,9 (440 opinii)
8,3
8,3
Awatar Użytkownika
the keyword Hello Sir Im excel VBA mcro and formula Expert i already read your project description :) and i love make dashboard for your excel spreadsheet Sir :) please ping me if u interested with me and we can discuss now Thank You Sincerely Galih
$500 USD w 10 dni
4,9 (412 opinii)
7,6
7,6
Awatar Użytkownika
I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and info. The modules can upload external databases. There is a search engine with high search capability to find a specific record (or group). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password. About Me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience in implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace.
$950 USD w 10 dni
4,9 (99 opinii)
7,5
7,5
Awatar Użytkownika
SNOWFLAKE Dear client I have previously carried out a number of projects in excel using macros and formulas in the past. Kindly contact me for further details. Roy
$700 USD w 20 dni
4,9 (472 opinii)
7,3
7,3
Awatar Użytkownika
Someka. Hello, I can build these dashboards for you as i have advanced excel skills and over 10 years in the field. Please check my portfolio to see my work. I am waiting to hear from you in order to discuss a little further about your project and het started. Thanks!
$800 USD w 10 dni
4,9 (66 opinii)
6,9
6,9
Awatar Użytkownika
SNOWFLAKE Hi There, As a financial modeling and dashboard specialist I'm happy to help you on this task. You can refer my profile to see details of my qualifications, experience and reliability, and if you are comfortable with those, we can discuss the project in more details. Best regards Priyal
$800 USD w 5 dni
5,0 (201 opinii)
6,8
6,8
Awatar Użytkownika
Hello? How are you? I have good experiences in "Build a Complex Excel Workbook with Dashboard" as you can see my profile for these (Data Processing, Excel, Financial Analysis, Visual Basic, Visual Basic for Apps). 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.
$833 USD w 3 dni
4,8 (98 opinii)
6,8
6,8
Awatar Użytkownika
SNOWFLAKE I will work with you to automate the importation of the User data and develop the necessary User Interface ‘Dashboard’ to meet your requirements. While my knowledge of financial modelling is not extensive, I invest in Shares and Property personally, so I understand a lot of the terms. My background in Dynamic Systems Modelling will enable me to program any manner of financial model that you can describe or point me towards a decent reference document. I am happy to answer questions via PM if you want to know anything more.
$833 USD w 20 dni
5,0 (41 opinii)
6,0
6,0
Awatar Użytkownika
"Someka" I am good in Excel data sheet automation and processing. Also have experience on Excel VBA. Basically I work on Visual Basic to build any kinds of Windows application. Have more than 15 years of experience on Visual Basic. 15+ years of experience on Computer Language and Digital Electronics.
$1 000 USD w 30 dni
5,0 (11 opinii)
5,6
5,6
Awatar Użytkownika
SNOWFLAKE Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$1 000 USD w 10 dni
4,8 (117 opinii)
6,0
6,0
Awatar Użytkownika
Hi Good Day! A serious freelancer here! I already filled-up the form on the link that you posted. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$500 USD w 5 dni
4,7 (73 opinii)
5,5
5,5
Awatar Użytkownika
Hello there!, I am highly interested in your project I read your project descriptions carefully before bidding. your 100% satisfaction is assured if you allow me to serve. First please chat with me where we can talk about briefly. Regards, Sanju P
$500 USD w 10 dni
4,9 (37 opinii)
5,1
5,1
Awatar Użytkownika
SNOWFLAKE I have built systems that take in data from disparate sources, massages them and converts them for output or to build beautiful reports. I use my skills in pivot, vba and power query to perform such activities. I worked with a Tier-1 company named Infosys for 2 decades and handled a sizeable team. To present data to customers and management i had to do number crunching and excel was the handy tool. I leveraged that expertise when i resigned and started freelancing and have been doing good in freelancer and outside. Unlike many others out here i dont have a team and i will do all the job all by myself. Let us discuss if you are interested. Regards, Gana
$944 USD w 10 dni
4,9 (26 opinii)
4,9
4,9
Awatar Użytkownika
SNOWFLAKE Hi, I am a native English speaking Finance professional with over 15 years experience working in financial management roles using Excel to build a variety of complex models. I am university educated in Commerce and have a post graduate diploma in Applied Finance and Investment. I have built a variety of complex Excel models in the past, including: - complex multi-site budget tools for a financial services organisation; - pricing models to review and analyse the benefits of potential new clients to a business; - detailed salary and wage models, calculating everything from different rates of pay, to superannuation and annual leave; - in-depth transport plans for manufacturing businesses; - reporting tools that use data from multiple financial sources (Oracle, Xero, Hyperion) to provide P&L and balance sheet analysis. I welcome the opportunity to discuss your project further and to work with you. Thanks & regards Melanie
$1 000 USD w 15 dni
5,0 (13 opinii)
4,5
4,5
Awatar Użytkownika
Hi sir, I am a professional certified management accountant have a high level experience in creating financial models and dashboards using excel spreadsheets, I made a lot of professional models in similar ideas, just contact me and I will show you samples from my work, and I am sure that you will like it. Thanks & Regards Ahmed Salama, CMA
$666 USD w 5 dni
5,0 (6 opinii)
4,0
4,0
Awatar Użytkownika
Hi! I am an excel expert use to work with data. I am willing to help you with the task! Hope to talk with you for further data! Regards,
$833 USD w 10 dni
5,0 (1 opinia)
3,7
3,7
Awatar Użytkownika
SNOWFLAKE Hi, I'm an Excel expert with over 5 years' experience of working in Excel formulas like (SUMIF, OFFSET, COUNT, VLOOKUP, GETPIVOTDATA), Pivot tables, Excel tables, Data validation, Auto-shapes, Named ranges, Conditional Formatting, Charts, Excel dashboard widgets, Macros, VBA, etc. I have built various types of dashboards like project dashboard, financial dashboard, marketing dashboard, and more for my clients in the past. I can build an excel dashboard template for your user where, in the future, They can just add values and the rest will all be automated. You can manually input your data or you can connect your apps to Excel, passing real-time data from your app to Excel. As data is updated in your app, your Excel dashboard will also be updated to reflect the latest information. This is a perfect option if you track and store data in another place, and prefer creating a dashboard in Excel. As for my introduction, I'm a CPA and ACA with over 10 years' experience in Accounting, finance, bookkeeping, preparation of financial statements, profit and loss statement, cash flow statement, review and reconciliation of accounts, bank reconciliation etc and I've extensive skills to use MS Excel for Budgeting, Planning, Analysing and reporting purposes. Looking forward to hearing back from you and complete the task as per your requirements.
$500 USD w 7 dni
4,6 (4 opinii)
3,3
3,3
Awatar Użytkownika
I am professionally expert in VBA. I can complete this project in 10days. Let's complete this project. Keyword: SNOWFLAKE
$998 USD w 10 dni
5,0 (5 opinii)
3,3
3,3
Awatar Użytkownika
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and am an expert in Visual Basic for Applications (VBA - Macros) automating complex Excel based reports, having an experience of 18 years. My other accomplishments are - Am and an expert in writing complex Excel based macros with 15+ years of experience. - Have held several senior level positions during my professional career spanning over 18 years. - Have around 5 years of experience handling 8 teams concurrently PAN India as a Senior Manager. - An expert in data visualization tools like Tableau. - Developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. - Have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). Exam is scheduled on 4th December, 2018. - Have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. - Have scored 7 out of 9 in IELTS certification. - Have been certified for Java, HTML, CSS, JavaScript, jQuery, PHP and mySQL by the Cambridge Certification Authority. My niche is that if any error/glitch is present in the project, I will provide support for it up to 15 days post final payment or submission of the project (whichever date is earlier), free of Cost. Thanks & Regards Satish Chandra +91-9999986050
$666 USD w 4 dni
4,8 (2 opinii)
2,4
2,4
Awatar Użytkownika
You can do the work and deliver exceptional results. You will fit in beautifully and be a great addition to the team. You possess a combination of skills and experience that make you stand out from the crowd. Hiring you will make him look smart and make his life easier.
$833 USD w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga TURKEY
Izmir, Turkey
4,9
45
Zweryfikowana metoda płatności
Członek od kwi 28, 2014

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.