Find Jobs
Hire Freelancers

Advanced Excel Template or Access Database

$30-250 AUD

Preklicano
Objavljeno pred več kot 7 leti

$30-250 AUD

Plačilo ob dostavi
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 projekta: 12526657

Več o projektu

42 ponudb
Projekt na daljavo
Aktivno pred 7 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
42 freelancerjev je oddalo ponudbo s povprečno vrednostjo $200 AUD za to delo
Avatar uporabnika
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 v 3 dneh
5,0 (495 ocen)
8,0
8,0
Avatar uporabnika
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 v 3 dneh
5,0 (146 ocen)
7,3
7,3
Avatar uporabnika
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 v 3 dneh
5,0 (329 ocen)
7,5
7,5
Avatar uporabnika
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 v 10 dneh
4,9 (116 ocen)
6,7
6,7
Avatar uporabnika
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 v 10 dneh
4,9 (59 ocen)
6,4
6,4
Avatar uporabnika
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 v 7 dneh
4,7 (76 ocen)
6,5
6,5
Avatar uporabnika
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 v 5 dneh
5,0 (50 ocen)
6,0
6,0
Avatar uporabnika
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 v 7 dneh
4,7 (158 ocen)
6,2
6,2
Avatar uporabnika
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 v 3 dneh
4,9 (83 ocen)
6,1
6,1
Avatar uporabnika
A proposal has not yet been provided
$277 AUD v 10 dneh
4,7 (29 ocen)
6,0
6,0
Avatar uporabnika
A proposal has not yet been provided
$555 AUD v 5 dneh
5,0 (21 ocen)
5,5
5,5
Avatar uporabnika
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 v 4 dneh
4,9 (34 ocen)
5,4
5,4
Avatar uporabnika
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 v 3 dneh
5,0 (12 ocen)
5,0
5,0
Avatar uporabnika
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 v 2 dneh
4,9 (30 ocen)
4,5
4,5
Avatar uporabnika
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 v 3 dneh
5,0 (27 ocen)
4,4
4,4
Avatar uporabnika
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 v 10 dneh
4,9 (30 ocen)
4,5
4,5
Avatar uporabnika
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 v 6 dneh
5,0 (3 ocen)
3,6
3,6
Avatar uporabnika
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 v 3 dneh
5,0 (10 ocen)
3,7
3,7
Avatar uporabnika
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 v 7 dneh
5,0 (5 ocen)
2,8
2,8
Avatar uporabnika
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 v 3 dneh
5,0 (3 ocen)
2,6
2,6

O stranki

Zastava AUSTRALIA
OAKHURST, Australia
5,0
5
Plačilna metoda je verificirana
Član(ica) od dec. 29, 2013

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.