Find Jobs
Hire Freelancers

Advanced Excel Template or Access Database

$30-250 AUD

Cancelado
Publicado há mais de 7 anos

$30-250 AUD

Pago na entrega
I have an excel sheet in which in manually update 1. Store Sales 2. Inventory 3. Expenses 4. Supplier Analysis 5. Profit ( Overall and for each item) 6. Return. [login to view URL] & Loss Statement 8 Balance Statement All this data is taken from EBay Sales Record Sheets Ebay Fees and Rates Fee Paypal statement Manual Inventory Sheet I need an automated sheet or Access database - where i could just download the above excel sheets and upload ( or Copy paste) and it can collate all information that I need.
ID do Projeto: 12526657

Sobre o projeto

42 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
42 freelancers estão ofertando em média $200 AUD for esse trabalho
Avatar do Usuário
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.
$250 AUD em 3 dias
5,0 (495 avaliações)
8,0
8,0
Avatar do Usuário
Hi there. If your data doesn't exceed million records I recommend we stay in Excel and make a "backend" & "Frontend" structure. I have prepared many similar studies and clients were quite happy. Let me tell you how we will do it: 1) I will create a backend in which you will copy and paste your raw data. 2) Then I will set the formulas / pivot tables and connections. (which you dont need to care about) 3) And finally we will create a nice looking and easy to use dashboard where you can manage your analysis supported with charts. Let me know what you think. Thank you.
$315 AUD em 3 dias
5,0 (146 avaliações)
7,3
7,3
Avatar do Usuário
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
$250 AUD em 3 dias
5,0 (329 avaliações)
7,5
7,5
Avatar do Usuário
Hey, i am an expert in excel and have done almost similar projects for some of my clients. i can create an automated system that will allow you to import the files and create the necessary reports on click of a button. please do review my ratings to see how i have been rated excellent for my excel work. look forward to working with you. thanks and regards, Rishi
$277 AUD em 10 dias
4,9 (116 avaliações)
6,7
6,7
Avatar do Usuário
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.
$300 AUD em 10 dias
4,9 (59 avaliações)
6,4
6,4
Avatar do Usuário
Hi there, if you'd really like to have a professional Ms Access(from your Excel sheets) software for your project , here is my introduction: I’m an Access/VBA 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
$555 AUD em 7 dias
4,7 (76 avaliações)
6,5
6,5
Avatar do Usuário
Dear the client, I read your job posts very carefully, You want to keep track of your profit and expenses by category, suppliers... My name is Hai. I'm an expert in both excel VBA and financial analysis 1. FOR EXCEL, I have helped many SMEs create advanced VBA financial model, automatic financial reporting... 2. FOR ACCOUNTING For past 5 years in accounting & Audit practice, I gained excellence in the fields of internal control system, accounting, and financial analysis. My expertise is greatly focused on budgeting and business planning. However, I also have full expertise in using SAP, SAGE ERP, and ORACLE. I worked for Deloitte for 2 years. I also served many types business from start-ups to large corporations in banking, airlines, manufacturing. I also have some experience in preparing annual business plans for start-ups and banks. Contact me, I'll give you the best offer Best regards
$300 AUD em 5 dias
5,0 (50 avaliações)
6,0
6,0
Avatar do Usuário
Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in Excel and Access both, I can provide you efficient solution for your manual editing excel sheet. I would suggest you to use MS Access, in which I can provide you forms which you can use to maintain inventory, expenses details etc. and also on checking feasibility can connect it with EBay and your data maintenance process will be get automated and you will have less loads of work in maintaining it. Waiting for your response for detailed discussion. thanks.
$144 AUD em 7 dias
4,7 (158 avaliações)
6,2
6,2
Avatar do Usuário
Dear Sir, I am based out of Jersey City, NJ, USA. 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/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 AUD em 3 dias
4,9 (83 avaliações)
6,1
6,1
Avatar do Usuário
A proposal has not yet been provided
$277 AUD em 10 dias
4,7 (29 avaliações)
6,0
6,0
Avatar do Usuário
A proposal has not yet been provided
$555 AUD em 5 dias
5,0 (21 avaliações)
5,5
5,5
Avatar do Usuário
Hi My expert team is ready for the project. They can handle advanced Excel Template or Access Database. Please contact with me. Thanks.
$250 AUD em 4 dias
4,9 (34 avaliações)
5,4
5,4
Avatar do Usuário
Am suitable to help for the automation as am an accountant myself, and have done such automations using excel all the way to P/L B/S many times for new companies. Hence, I have high confidence of meeting your requirements with the least explanation on your side. (E.g. the balance sheet will balance of course) If you can send me your manual files, I should be able to get this done in quick time! Looking forward!
$100 AUD em 3 dias
5,0 (12 avaliações)
5,0
5,0
Avatar do Usuário
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$111 AUD em 2 dias
4,9 (30 avaliações)
4,5
4,5
Avatar do Usuário
Hey, I see what automation you want to implement. You want just to update the input tabs and the rest to be calculated automatically. I've done that before using VBA script, advanced formulas and dynamic pivot tables. Let's start this together and I will participate with improvement ideas from my experience to make your life easier. I recently finished a tool that was looping trough the excels files from a folder in order to import and process them based on some configurable parameters. I would like to mention that I'm more interested in the quality of the deliverable and customer satisfaction in order to get a good review than the money. Therefore we can negotiate to get to the amount that you're comfortable with! I invite you to discuss further the solutions that we will implement in your project. Best regards, Marius
$70 AUD em 3 dias
5,0 (27 avaliações)
4,4
4,4
Avatar do Usuário
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. Your kind response is being awaited.
$238 AUD em 10 dias
4,9 (30 avaliações)
4,5
4,5
Avatar do Usuário
Hello there. I'll develop your solution using an Access database. This is my approach: 1) I'll develop the relevant tables, relationships and queries that link the different reports you have listed 2) I'll write code to automatically import your source data (.csv, .txt or whatever format we agree) into the database 3) I'll set up the forms you need to simplify data entry Let's get started asap! You can expect: 1) 100% money back guarantee if pre-agreed acceptance criteria are not met! 2) Error-free solution 3) Timely submissions. Do get in touch, share your source file(s) and and let's refine your requirements. I have completed work like this recently (please see the "CSV Reader" reference in my reviews)
$110 AUD em 6 dias
5,0 (3 avaliações)
3,6
3,6
Avatar do Usuário
hi. I have extended ms excel and ms access experience. In addition I also have much vba programming experience. please let me know ,how I may assist.
$70 AUD em 3 dias
5,0 (10 avaliações)
3,7
3,7
Avatar do Usuário
I have done similar projects in past in which I created a tool which maintains excel sheets for a broker. I can both automate excel sheets or write a Java code to maintain your sheets. Thanks for going through my proposal. Hoping to get back response from you soon.
$222 AUD em 7 dias
5,0 (5 avaliações)
2,8
2,8
Avatar do Usuário
I will create an access database with the templates based on your excel sheet. Create necessary formula and links. Then whenever you want, you can download your excel files from the web and and run a macro in Access. This will import the data from respective files and generate the report based on the latest data. Please share your sample data and I can provide you a perfect solution.
$200 AUD em 3 dias
5,0 (3 avaliações)
2,6
2,6

Sobre o cliente

Bandeira do(a) AUSTRALIA
OAKHURST, Australia
5,0
5
Método de pagamento verificado
Membro desde dez. 29, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.