Microsoft Excel - Dashboard and VBA

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I always take project to completion. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra

I am financial specialist and guru in Excel over 35 years. I create creative and complex financial models in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, suitable sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors. I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a variety of businesses including, startups, retailers, power plants, farms, equipment manufacturers, among others.

Hi there, Your project immediately caught my eye and I feel I would be a great fit. I have over 15 years of corporate experience working in Excel creating advanced automated dashboards, reports and calculators which included beautiful graphical displays of data/information. I enjoy creating complex algorithms using Excel formulas to extract meaningful conclusions from Excel data to help clients use the data to improve their businesses. Also, creating charts and graphical representations of data in Excel is one of my favorite things to do. I'd love the opportunity to help you with the automation requirements you have for your existing dashboard as well as enhance it visually. I have a few portfolio items on my Freelancer home profile if you want to take a look, and I have a more detailed file with numerous screen shots of my work as well – I can send it over for your review if you’d like. I know I have bid over the set budget - I totally understand if you are firm at $30. Hopefully I can hear more and we can work together! Thanks either way and best of luck, Shaun

Hi, I can do anything with vba coding in excel spreadsheet. If you can send me your existing spreadsheet (with some data sample) and more explanation of what you want to enhance for either the automate functions or the design, I can give you my thoughts and working mockup sample. Feel free to check my profile page. Over than 270 projects, I've never failed. All completed 100% and on Budget, on Time. Cheers, Daniel

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav

- Can get the dashboard enhanced and modified as per the requirements. - Have good expertise in Excel and have done graphs, dashboards KPI on Excel (Freelancer projects.) - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.

Hello, I am Luis from Venezuela and it will be my pleasure to help you redesigning your excel dashboard. I am an engineer and I work everyday with excel, visual basic and reports so I am able to design your dashboard in a professional and visual way. Please contact me by chat and then we could discuss better your project and watch your file. Kind regards, Luis Romero

Hello, I have a lot of experience with Excel and VBA and I can provide a lot of examples. Please contact me for more information.

Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. You may view my profile to know about my expertise. I have 44 reviews with 5 Star rating. I pray and hope that you will consider me for this job and I will see a messege from you soon. So why you are thinking? Let's discuss about your project................ -Sajib

Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Design/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, Adobe packages, 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..

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

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, Creating Dashboard, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. Please message me to get my sample work. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/Excel/VB. I’m a ms Access/Excel/VB programmer, a mathematician and a full time 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. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

Can you send me your dashboard and data, so I can make a concept to proof it to you. About the experience, you can see my review to check if it's enough or not. I hope we'll discuss further, Thanks

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details and the price is negotiable based on the project.

Dear I am an excel professional having hands on expertise in developing dashboard for analytical purpose I will do your project as per your requirements. best regards humayoon

Dear Sir, It is good If you can send to me your excel file and tell me what do you want. I will write a macro for you. Please review my profile you can see I already done some marco project in the past thanks Pham