Find Jobs
Hire Freelancers

Improve existing excel sheet

£20-250 GBP

Mbyllur
Postuar about 5 years ago

£20-250 GBP

Paguhet në dorëzim
Hi, we are an properties management company. We are looking for expert to improve the spreadsheet we are currently using to improve our efficiency and minimise the manual input. Attached a copy of the spreadsheet we are currently using. Essentially, we are hoping to improve the spreadsheet, ideally 1) a sheet for all the lease activities (new lease and renewal), 2) a sheet for all sheet for all the properties information (address, no. of bedrooms, parking space, owner), 3) a sheet for all our client details, 4) a sheet for rent in and out record (it's currently done manually, we are hoping this can be generated automatically from the lease activities sheet), 5) a sheet for producing monthly statements for our client, 6) a summary sheet summarising monthly fee income, lease activities, company overview (no. of properties under management, no of client) and 7) an input page for date input into 1), 2) and 3). Perhaps we can discuss further once you have a thought a about the above requirements.
ID e Projektit: 18776789

Rreth projektit

25 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
25 freelancers are bidding on average £200 GBP for this job
Avatari i Përdoruesit
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£220 GBP në 3 ditë
4,9 (309 përshtypje)
7,8
7,8
Avatari i Përdoruesit
Dear Employer, I understand what you need and will be able to help you on this. Please message me so that we can discuss a bit more. I am an excel expert with over 12 years of experience. Thanks and Regards, Ash
£200 GBP në 7 ditë
5,0 (157 përshtypje)
7,3
7,3
Avatari i Përdoruesit
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.
£200 GBP në 3 ditë
4,9 (288 përshtypje)
7,2
7,2
Avatari i Përdoruesit
Dear Sir/Madam, I just went through the attachment and your project description and happy to help you on this task. I am an expert in advanced excel skills and have a strong finance background, and have already developed a lot of similar customized financial models for businesses across the world. You can refer my profile to see details of my qualifications, experience and reviews, and if you are comfortable with those, lets discuss this in more details. I assure you that I will go beyond your expectations, and look forward to hearing from you. Best regards Priyal
£250 GBP në 3 ditë
5,0 (237 përshtypje)
6,9
6,9
Avatari i Përdoruesit
Hello? How are you? I have seen the project - "Improve existing excel sheet." As you can see my profile in these fields((Accounting, Data Entry, Data Processing, Excel, Word)), I have been working for 7 yrs as a great assistant for the clients. When I work in the project, I prefer to work by asking and answering each other for the project status. So that, i always try my best to deliver great result without any issue. I will get paid once you have satisfied the result. If I did not deliver good result on time, I will not get paid. Therefore, I wanna work with you if you do not mind. Hope to work with you. Thank you.
£155 GBP në 3 ditë
4,9 (75 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hi, I am certified for Microsoft Office, Microsoft Excel, Word and Access. I am good command over data management in Excel Dashboard, Spreadsheet as well as in Microsoft Access Database. I have 15 years’ experience to handle Databases as well as I have completed many projects and my profile feedback section is showing my abilities and client recommendations. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered on time and after checking when you completely satisfied then you can release money. You can see a great level of communication level and customer support. Looking forward for great business deal and good start for future relations. "
£111 GBP në 2 ditë
4,8 (166 përshtypje)
6,7
6,7
Avatari i Përdoruesit
Greetings! I am qualified accountant with ten years of experience in excel and lease accounting. Please PM to discuss. Thank you.
£240 GBP në 3 ditë
4,8 (84 përshtypje)
6,9
6,9
Avatari i Përdoruesit
Hello client I have gone through the requirements in the project brief very minutely. I can set up the entire spreadsheet for you with all the requirements you mentioned. I will make it in such a way that it is very easy to use for all including excel savvy as well as excel naive. Also I will make the sheets password protected so that the formulas dont get disturbed. Kindly contact me for a discussion. Roy
£200 GBP në 4 ditë
4,9 (298 përshtypje)
6,7
6,7
Avatari i Përdoruesit
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
£250 GBP në 5 ditë
5,0 (126 përshtypje)
6,2
6,2
Avatari i Përdoruesit
I am excel and vba expert, lets discuss further once you have a thought a about the above requirements. Mohsan
£150 GBP në 3 ditë
5,0 (71 përshtypje)
6,2
6,2
Avatari i Përdoruesit
Ok Sure
£166 GBP në 3 ditë
4,9 (87 përshtypje)
6,0
6,0
Avatari i Përdoruesit
Hi. I am an affiliate chartered accountant (CPA) and a professional accountant since 2009. I have advanced level proficiency in excel and using it for approx. a decade now. I have prepared numerous templates, reports, dashboards etc on excel making sure minimum manual data entry requirements and maximum output. Please contact and discuss the details. I can prepare your excel reports with better quality
£85 GBP në 3 ditë
4,5 (89 përshtypje)
6,0
6,0
Avatari i Përdoruesit
Hi there! I have taken a look at your workbook and would love to chat further about it. Most of what you are after would be achievable using a series of data tables; however some programming will be required to generate the rent in and out records so it would be great to know what OS you are on, version of Excel you are using etc. The benefit of using data tables is you don't need to have a heap of blank lines with formulas waiting for new data, instead the formulas automatically flow down when you add a new line to the table (even if they are over-written in earlier rows). It also makes look-ups and drop-downs much neater (e.g. in cell I17 on the statement tab you have a heap of blanks in your drop-down because it is currently referencing potential future entries, this can be made to auto-grow to incorporate new entries when using tables). Looking at the project, I would also suggest adding in a sixth sheet where you can detail additional revenue and expenditure. This way this will be maintained as a historical record (currently it looks like this would be over-written each time you generate a new month / client report); or alternatively documenting this within the rent in / out record sheet. A little about me: I am an Australian business analyst with over 20 years experience delivering Excel based solutions for business. I love building deceptively simple, stable, user friendly solutions in familiar environments like Excel. Cheers Katie
£200 GBP në 3 ditë
5,0 (25 përshtypje)
4,9
4,9
Avatari i Përdoruesit
Hello! This is not actually an offer to improve your workbook, but just as an idea of how to really improve it. Drop the Excel format for this. What you are trying to do is to create a database in a file format which is not meant to be a database. Usual scenario in almost all such cases is that the user ends up entering repetitive data, then the user forgets to enter something, enter the same data a different way and finally end up not knowing what is where and what has been done. The first rule in the database is that one data can be entered only once. What I am suggesting is to replace your Excel file with Access database. We could discuss details further in the chat. Of course, if you like the idea in the first place. Regards, Branislav Mihaljev
£222 GBP në 3 ditë
4,9 (20 përshtypje)
5,1
5,1
Avatari i Përdoruesit
Hello there, I have carefully gone through your requirements of making an excel sheet that can minimise your efforts of manual intervention. I will create an automated excel sheet where there will be only 1 page of input and for rest the sheet can automatically provide you information. Message me so that we can discuss in detail your requirements. Thanks
£150 GBP në 3 ditë
4,9 (36 përshtypje)
5,2
5,2
Avatari i Përdoruesit
I have developed other Excel based property management solutions. MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
£230 GBP në 4 ditë
5,0 (28 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Hello: I'm a six years experienced excel developer working for a corporate. Couple of VBA projects I worked on are: • Auto reporting from raw file by VBA • Auto emailing with attachment by VBA • Auto website interaction by VBA What I understand is you need below: • “Lease activities” sheet require some formatting (for easy understanding of users) & a little bit play of excel formulas. • “Properties information” sheet is just like a database sheet. It’ll require some formatting as well. • “Rent in and out record” sheet need some macro to be coded as you need automation here. • “Monthly statements” & “Summary” sheet need some formulas or macros depending upon how you need it. • “Input page” is just a simple sheet which will be referred to other related sheets. What you can get from me: • Get your demo project for free! Meaning, let’s say I’ll do 20% of your project milestone for free. If you don't like it then surely you can cancel mine & award the project to some other freelancer. No harm in that right? • Post project support. If anything goes wrong after project it's not like I’ll turn my back on you! • Lowest cost. • Good communication. What you can’t get from me: • If you are in a tight schedule then I’m not your guy since I’m a passive freelancer. I work 15-20 hours per week for freelancing. If you are really interested then PM me to discuss further so that I can start developing a prototype. Thanks,
£80 GBP në 5 ditë
5,0 (7 përshtypje)
4,1
4,1
Avatari i Përdoruesit
Hello I would love to help with your property spreadsheet. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I look forward to speak to you soon. Kind regards Steve
£222 GBP në 5 ditë
5,0 (7 përshtypje)
3,9
3,9
Avatari i Përdoruesit
I am ready to help you on your project Improve excel sheet. I am an accountant and expert in Microsoft Excel including VBA or Macros development. I have developed many excel automation process and would like to do it for you as well. Kind Regards Gopal
£100 GBP në 5 ditë
5,0 (10 përshtypje)
3,0
3,0
Avatari i Përdoruesit
Hello I have gone through your requirement and I am interested in making the excel sheets. I have got expertise in MS Office and web research. Excellent with time management and organisational skills. Do message me for further details. Thanks 100% accurate work within stipulated time frame. Welcome to my profile: Skilled in planning and organizing with the ability to complete tasks on deadline since 8 years. Accurate, fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately.  An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support to a large department.  A proven track record of efficiency and accuracy in managing multiple functions, solving problems, maintaining confidentiality and producing quality work. Education - Masters in Commerce (Economics) and  Masters in Education My services- Shopify Transcription PDF to Excel PDF to word Data entry (typing speed 50 wpm) Data processing Hand written to word, excel, PDF File renaming with accuracy Excel service (removing duplicate, sorting columns, email list cleaning etc.) Image editing Bookkeeping/accounting Video editing Form filling Internet research An experienced user of Google, Google sheets
£200 GBP në 8 ditë
5,0 (5 përshtypje)
2,6
2,6

Rreth klientit

Flamuri i UNITED KINGDOM
Inverness, United Kingdom
0,0
0
Anëtar që nga shk 21, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.