Find Jobs
Hire Freelancers

Hire an Excel Expert

$30-250 AUD

Closed
Posted over 6 years ago

$30-250 AUD

Paid on delivery
I sell an a magazine through around 240 outlets each week (this will increase to 2/3 products shortly). I want to create a new system of managing all of our data. Sales data (Magazine Sales & Advertising Sales), I want the system to produce Invoices automatically when the sales are keyed in and manage payments received and outstanding. All expenses to be put into the same system and all of the data used to produce a P & L Account. From all of this data I want to produce a number of reports (Year on Year sales and Waste by Outlet, Delivery Driver & Company Total). Outstanding Debtors. We also produce a delivery document for our drivers so I would want the last weeks sales data to populate next weeks delivery paperwork with the ability to change the route of the delivery driver. I want an outlet control sheet where we enter all details for new outlets, the opening date and if they close the closing date, which delivery driver they are allocated to and the ability to decide whee they appear on the delivery drivers order sheet easily. I want a simple way to move the outlets between Delivery Drivers so that all of the existing data goes with the the change of driver. I will need the flexibility to change IVA Tax percentages. This should be enough to give you an idea of what I require. Thank You Brian
Project ID: 15865289

About the project

23 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $192 AUD for this job
User Avatar
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones $155 AUD - Excel
$155 AUD in 3 days
4.9 (61 reviews)
5.5
5.5
User Avatar
Hi, I viewed your requirements. In my view the best way to build Ms access software. I'll build that , it will be fully functional on your need, with very simple and friendly interface. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $833 AUD - default
$833 AUD in 11 days
4.7 (32 reviews)
5.8
5.8
User Avatar
Please ping me if you are interested with my proposal and thank you... Relevant Skills and Experience VBA Proposed Milestones $250 AUD - fianl
$250 AUD in 3 days
4.9 (34 reviews)
5.2
5.2
User Avatar
My name is Deepak. I work as a full-time MS Access Excel Programmer. I have spent the past 4+ years doing full automation, building custom applications, number crunching, and database management for MS Office businesses, and I am keen to continue developing my career in the field of data analysis, Access Database, Excel and VBA programming.   If you need I can build an access database also with various functionality and reports with same budget. My expertise relies on: 1.         Solid knowledge of table/query design, form/report design, and automation utilizing VB modules. 2.         Expertise in debugging developed VBA codes and fixing them. 3.         Having Experience in Support Access and Excel application with SQL Server backend  4.         Experience in Identifying and understanding the requirements of the clients with respect to the database administration system that needs to be developed. 5.         Well versed with database concept and experience in using SQL statements for data validations.  6.         Have experience in developing Access databases and applications using VBA for data transformation and validation projects. 7.         Experience in design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens with professional UI interfaces. 8.         Developing data models and designing the database architecture as per the given instructions and modifying them to accommodate the system requirements. Installing several security features and granting access levels as per the user privileges set by the client to ensure maximum protection of the database system and avoiding theft of valuable data. 9.         Collecting data from various sources like QuickBook, Excel, MySQL, SQL, Azure and Manipulating, cleansing & processing data using Excel, Access, Macro, VBA, and SQL. 10.       Creating attractive and dynamic Reports in MS Access. 11.       Implementing Google Charts, Map into MS Access Forms, Reports (both offline and online).
$200 AUD in 3 days
4.9 (16 reviews)
4.9
4.9
User Avatar
I am a chartered accountant having experience of more than ten years in accounting and finance. please check my profile for review and trust as I did similar work on past. I am also an advanced excel expert.
$150 AUD in 3 days
4.9 (32 reviews)
4.9
4.9
User Avatar
I am an expert in excel and have worked on various automation projects Relevant Skills and Experience My skills includes: Macros, Web Scraping, User Forms, Reports, Dashboards, Customized Ribbon Buttons, Interaction with external applications (Outlook, PDF, Access), etc Proposed Milestones $75 AUD - Setup $80 AUD - Data Entry Form $68 AUD - Reports
$223 AUD in 5 days
5.0 (13 reviews)
4.1
4.1
User Avatar
Dear i 'll be greatful to you if you give me a chance to prove myself. Please please please Thank you
$30 AUD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
Hi Brian, You have described the requirements well. We would need you to guide us reg the exact data fields to be stored, calculations and reports to be created. We will use VB logic and automate. Relevant Skills and Experience 15 plus years of IT systems development for SWIFT(Virginia), Unisys Corp(London), HSBC bank(Hong Kong) & BHP NZ Steel(New Zealand). Now teaching advanced Excel topics. Proposed Milestones $75 AUD - Detailed requirements/design document submitted to you after initial chats/calls. $100 AUD - First draft solution delivered to you. $25 AUD - Revised solution with corrections if any. $22 AUD - Two weeks operations support as you use my new logic. Additional Services Offered $25 AUD - Enhancement ideas $50 AUD - Quote for enhancement When can we a chat reg detailed requirements ? I am 5.5 hours ahead of GMT
$222 AUD in 10 days
5.0 (4 reviews)
2.8
2.8
User Avatar
I have more than 3 years of expertise in this , creating database and turning excel workbook into an automated model, i work in a US Based consultancy where model development from scratch is my job Relevant Skills and Experience Excel VBA, Object oriented programming Proposed Milestones $33 AUD - Problem Solving and thinking $33 AUD - Backend Development $67 AUD - Code development Additional Services Offered $30 AUD - Frontend with formatting I am new into freelancer but have 3+ years of experience in VBA, Let me know if you are interested because solving this problem statement is easy for me.
$133 AUD in 3 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hello, We have put a glance to your job details and we are quite interested to do this job. Let us tell about our experience. Since last 6 years we are in Data Entry profession. Relevant Skills and Experience Excel, Excel Macros, Excel VBA, Visual Basic Proposed Milestones $250 AUD - Excel, Excel Macros, Excel VBA, Visual Basic Charges
$250 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Certified Microsoft professional and have handled projects with similar requirements in the past. I would love to have a chance to help you on this project. Relevant Skills and Experience - Ability to write quickly without compromising the quality -SEO Article - Timely delivery -Exceptional communication -Over 100+ project completed with perfect 5-star rating Proposed Milestones $250 AUD - Completion Please contact me to discuss the project in detail. Thanks
$250 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It Sounds like you Need a Database. I Built something Similar for another Business, Monarch Welding & Engineering. I Built a System to Track their Timekeeping on Many different Jobs. Relevant Skills and Experience Excel, MS Access, Database Structure, Proposed Milestones $10 AUD - Create Mock up $100 AUD - Add Features as Needed $60 AUD - Deliver Final Product
$170 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have worked on similar projects and sure can create a new one customized on your specific needs. looking forward to cooperate with you. Relevant Skills and Experience Engineering background, Excel Expert, Business Development Engineer Proposed Milestones $200 AUD - A Wish you luck with your business.
$200 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I know, All the functionality of Excel. Relevant Skills and Experience I have 5 years Experience in Account field. Have deep knowledge in P&L and Tax system. Proposed Milestones $144 AUD - Complete work on time as per the requirement. Additional Services Offered $10.01 AUD - Preparing Branch wise Balance sheet As a accounts manager, I have much knowledge in Accounting & Excel.
$144 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Vast experience in excel and it's utilities. Have developed numerous macros using vba Relevant Skills and Experience Excel, Data processing, Data analytics, Macro
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 5+years of experience in working with excel macros
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have created similar system for Buy, Sale which provide invoice generation, Report generation, Demo can be provided. Most of the code can reuse and can deliver suggested functionality quickly Relevant Skills and Experience EXCEL VBA Proposed Milestones $155 AUD - 155
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this quite easily and I can even do it for very small amount because I want good review and feedback after completing this project. Relevant Skills and Experience Excel Macro and VBA Proposed Milestones $1 AUD - Finalize all the Ouput Formats $1 AUD - Finalize the Input data $28 AUD - Deliver the project I can do this quite easily and I can even do it for very small amount because I want good review and feedback after completing this project. I am ready to do it at a lower cost as well but the system does not allow me to bid lower than this. I am expert in Excel VBA & Macro and worked for more than 10 years on excel. I will be happy to discuss this in detail and you can choose to not pay in case you are not satisfied with the output
$30 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
faridabad, India
4.9
37
Member since Mar 9, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.