Find Jobs
Hire Freelancers

Do some Excel Work

$1500-3000 AUD

Closed
Posted about 7 years ago

$1500-3000 AUD

Paid on delivery
We currently have a spreadsheet call the 'Tracker' that effectively tracks our internal business revenue and expenditure monthly in the form of a profit and loss / balance sheet with add on sheets that feeds into the main Tracker sheet. The Tracker has the trading months listed in columns showing actual revenue/expenditure shown which are input at the conclusion of each month by our financial controller and the forecast revenue/expenditure shown monthly over future financial years. The file is somewhat large and is increasingly likely to include mistakes as it expands. I am looking for someone with the skill to work with MS Excel to assist in formatting the current spreadsheet so that; 1. The cells that have formula's are protected and cannot be altered without authorization. 2. The spreadsheet is formatted visually so that it can be easily readable and printable for review during monthly meetings. 3. Include areas where we can add/remove new forecast revenue/expenses, indirect expenses - possibly having clickable buttons within the sheet so that the actual sheet can only be altered this way. 4. Hide/Unhide financial years and add additional years as required. 5. Include tax tables that can be updated when the ATO makes them available which are linked to employee monthly pay totals. It is also to be linked to new employee's which is linked to the main tracker. There will likely be additional requirements and ongoing work related to developing a template file for our internal use.
Project ID: 13034359

About the project

15 proposals
Remote project
Active 7 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
15 freelancers are bidding on average $1,936 AUD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$1,500 AUD in 8 days
4.9 (347 reviews)
8.0
8.0
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$1,500 AUD in 30 days
4.9 (415 reviews)
8.0
8.0
User Avatar
"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan. 8th February (23)
$2,319 AUD in 30 days
4.9 (452 reviews)
7.4
7.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$1,500 AUD in 9 days
4.9 (231 reviews)
7.4
7.4
User Avatar
Hi, I have excellent experience in Excel and will be pleased to do this job. I will use vba for some parts so you must be comfortable with it. Otherwise please ignore my bid. Thanks
$3,000 AUD in 21 days
4.8 (133 reviews)
7.0
7.0
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$2,500 AUD in 30 days
4.9 (177 reviews)
6.5
6.5
User Avatar
Hello there, I reviewed the Tracker file you shared and like you mentioned it certainly tracks a lot of data. Also, I am assuming this file has evolved over a period of time since I could notice some cells having formula while some having numbers and others having numbers as formulas. So, looks like some inconsistency has crept in it and as you rightly mentioned, it may not be accurate as it grows. I am an expert in designing business spreadsheets and have done more than 300 for clients here on freelancer itself. I can work with you in making your spreadsheet more aligned to your needs and making all formulas consistent, protected etc. While I was able to understand how the spreadsheet is organized, to be able to help you, I will need some more details on how some of the formulas are currently working and what is the process to enter the data etc. Can we have a brief chat on the requirements and I would be able to get going on it right away. Do let me know. Best Regards, Rishi
$1,750 AUD in 15 days
4.9 (163 reviews)
6.7
6.7
User Avatar
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$2,500 AUD in 30 days
4.7 (69 reviews)
6.4
6.4
User Avatar
Hi There, I'm a Mechanical Engineer familiar with Microsoft Word, Microsoft Excel Google docs Spreadsheet, Wordpress, Magneto I Provide certain services : 1. Data Entry 2. Web Research 3. Social Media Marketing 4. Mechanical Engineering 5. Autocad 6. Sketchup 7. Interior Design & Building Architecture 8. CorelDraw & Photoshop I've enough experience about various types of Data Entry, Web Research, Social Media Marketing, Autocad Experience, Building Architecture I want to build my career as a successful Freelancer. Please, let me know what is needed to secure this bid! Thank you for your consideration Murad Eltaher
$1,500 AUD in 30 days
4.6 (92 reviews)
5.3
5.3
User Avatar
Hello, My name is shahid from Kashmir Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years rich experience in the field.I have successfully completed more than 1000 projects in this field you will be glad to know that I am best fit for your project my key skills are. Python Email developer, software architecture and Scrapping expert with 5 years of experience. Linkedin API developer. Using Python, Wordpress , Linux,PHP,MYSQL ,Java ,Javascript, ,Website Design ,Graphic Design,CSS,Research,WordPress ,Magneto ,MATLAB and Mathematica ,Leads ,Web Search ,Machine Learning ,HTML5 ,LinkedIn ,Landing Pages ,Web Services ,Internet Research ,Angular.js ,,Data mining,,Web scrapping,Find contacts, Data Processing, Data Entry, Excel, Leads, Web Search, Data Mining, Linked in, Microsoft Office, Email handling. I am a highly skilled web researcher,data entry provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills. I have successfully completed more than 100 projects ranging from, WordPress , C Programming , C++ Programming, Linux,PHP,MySQL ,Java ,JavaScript ,Website Design ,Graphic Design,CSS,Research,WordPress ,Magneto ,Leads ,Web Search ,Machine Learning ,HTML5 ,LinkedIn ,Landing Pages ,Web Services web research, data entry, Internet Research, LinkedIn , Lead Generation, Google docs & Excel Spreadsheet creation/editing. You can test the quality of my work and also i provi
$1,500 AUD in 0 day
4.5 (10 reviews)
4.7
4.7
User Avatar
Hi there, I'm an Excel expert and can help get the work well done as required. Feel free to contact me and discuss more details. Best Regards, VL
$2,400 AUD in 15 days
4.9 (11 reviews)
3.7
3.7
User Avatar
I can do this work in professional way because i am very good in Photoshop Excel Word and Web search also i am very fast in typing and i will finish the work in the right time.
$277 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Feb 7, 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.