Find Jobs
Hire Freelancers

Excel Management for Airbnb Rental Control

€8-30 EUR

Completed
Posted 3 months ago

€8-30 EUR

Paid on delivery
I am in need of someone with strong Excel skills to develop formulas and charts for my Airbnb rental business. Here's exactly what I'm looking for: I have a excel table with reservations for 2024 (past and future reservations). Let's callit Table1: The table has the following columns: Checkin-Date; Checkout-Date;House Name; Rental Cost Based on this information I need a table with the following New Table: Year | Month | House 1 % Occupation | House 1 Profit | House 2 % Occup | House 2 Profit | House 3 % Occup | House 3 Profit The excel file is on the google docs environment. It would be great if the new table and the carts update automatically.
Project ID: 37812035

About the project

47 proposals
Remote project
Active 3 mos 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
Awarded to:
User Avatar
Good Day, I hope this message finds you well. It's my pleasure to express my interest in joining your team to assist with data collection. With a strong background in Finance, a Commerce College graduation, and over 15 years of experience in educational and analytical roles, I am confident in delivering professional and accurate results. My expertise encompasses Excel functions, Excel management, web scraping, web search, Power BI, data mining, Access, and DBMS. I assure you of my commitment to excellence and am ready to answer any questions you may have. For the specific task of Excel Management for Airbnb Rental Control, here's my proposed approach: Data Analysis and Reporting: - Utilize advanced Excel skills to develop formulas and charts. - Work with the provided table, Table1, containing columns: Checkin-Date, Checkout-Date, House Name, and Rental Cost. Automation and Google Docs Integration: - Ensure the new table and charts update automatically in the Google Docs environment. I am confident in my ability to provide a tailored solution for your Airbnb rental business, bringing efficiency and accuracy to your data management. Thank you for considering my application. I look forward to the opportunity to contribute to your project. Best regards, Christine Zekrian
€15 EUR in 4 days
5.0 (4 reviews)
2.4
2.4
47 freelancers are bidding on average €23 EUR for this job
User Avatar
Hello, I am proficient with Excel and VBA and I can make a macro that will calculate all the information you need, based on Table 1. I could finish this very quick. Please contact me for more info.
€30 EUR in 1 day
4.9 (140 reviews)
5.9
5.9
User Avatar
Hi, Good Day! I can do it for you! As an experienced PMO Analyst, I've spent years analyzing financial data and creating meaningful reports primarily using Microsoft Excel. I understand the ins and outs of handling large datasets, creating formulas, and automating processes to deliver accurate outputs efficiently. I'm well-versed in working with pivot tables and using VBA macro coding for creating complex yet user-friendly spreadsheets just like the job requires. Moreover, my experience with Sharepoint Site maintenance can greatly enhance our collaboration. I can develop customized solutions to automate your Airbnb rental business process using Infopath, Powerapps and Flows. Lastly, my proficiency in Adobe Photoshop can be a bonus for any potential graphical needs you may have moving forward such as producing beautiful visualizations with Ms Excel Charts and Formatting. Joining forces with me means you get a solution-focused professional who is capable of turning raw data into valuable insights and automating your process for better efficiency in record time. Let's make your Airbnb rental management smoother and more profitable together.
€20 EUR in 3 days
4.8 (81 reviews)
5.5
5.5
User Avatar
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). I successfully delivered Dashboard, Scorecard, KPI Tracker, heatmap & ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can support you to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics Excel | VBA | Power BI | SQL | OCR | GSheet
€30 EUR in 2 days
5.0 (28 reviews)
4.8
4.8
User Avatar
As an Excel specialist, I can swear by my formulas and charts savoir-faire to attend to your Airbnb rental management like it's my own property. Your requirement aligns perfectly with my strengths. I am very comfortable manipulating large sets of data in Excel and utilizing complex formulas to automate the necessary calculations. Consequently, I can create a dynamic table that updates itself as new information rolls in – just as you need! Let's collaborate and make your vacation rentals business thrive with flawlessly managed data!
€10 EUR in 1 day
4.8 (5 reviews)
2.7
2.7
User Avatar
Hi there, I can perfectly handle this project for you and deliver the desired outcome in 1hour. Please reach out. I will work on this right away.
€29 EUR in 1 day
5.0 (4 reviews)
2.5
2.5
User Avatar
Hello, I have experience working with Exel automatization and I would like to agree the details to start to work as fast as possible. Thank You.
€19 EUR in 7 days
4.6 (2 reviews)
2.3
2.3
User Avatar
Hello, As a seasoned excel specialist with a keen eye for detail and a commitment to accuracy,I am confident in my ability to deliver exceptional results that meet your project requirements and exceed your expectations. Why choose me: Experience:with 6 years of experience in excel project with excellent data analysis skills Attention to detail: I understand the importance of accurate analysis in decision making process and ensure that each entry is meticulous verified for completeness and correctness Timely Delivery: you can rely on me to complete your project within the specified timeframe. So, I am eager to leverage my expertise and dedication to support your data analysis need and contribute to the success of your project. I am confident that I can add value to your team and help your achieve your goals. Let's talk for further details Thank you
€19 EUR in 7 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Worked in Airbnb data tasks. I am the right person to do this job, I am professional data analyst and can easily work data entry tasks. I have work many project like this one and i am capable to complete this one aswell asI have understood all your project details and I feel my self the best candidate to complete given project with 100% accuracy. I have vast amount of experience in this industry since I am working from 2015 as a professional data analyst. I have huge number of client base in these 7 years. Kindly contact me asap so we can discuss your project in detail. Regards, Sidra
€19 EUR in 7 days
5.0 (2 reviews)
1.9
1.9
User Avatar
I am excited to apply for the position to develop Excel formulas and charts for your Airbnb rental business. With a robust skill set in Excel, I can streamline data, providing valuable insights for your operations. I look forward to contributing to the success of your business. Sincerely, Jan Pril Gallenera Applicant
€20 EUR in 2 days
4.8 (2 reviews)
1.8
1.8
User Avatar
I am an expert in python, c programming, excel and matlab as I am mechanical engineer by profession. I also have experience in report and research writing and have recently written two submitted master dissertations in English language. I have experience in latex writing as well. Also I have Presentation making and article writing experience, biology writing, Video editing and videography are also my add up skills.
€19 EUR in 7 days
4.1 (4 reviews)
1.7
1.7
User Avatar
With my extensive knowledge in Power BI and Excel, I am ideally suited for this project. I have a demonstrated track record of taking complex data and transforming it into meaningful, actionable insights using advanced formulas and functions in Excel. I can efficiently connect your Airbnb reservation table to Power BI to automatically update the new table and charts as you desire. My data processing skills are second-to-none, ensuring I can accurately calculate not only the occupancy percentages but also the corresponding profits for each property. I understand that up-to-date information is key in making informed business decisions, thus, ensuring the automatic update feature is working seamlessly is a top priority for me. Overall, I genuinely believe my abilities align perfectly with what you need for your Airbnb rental business. Let me put my skills to work for you in creating efficient data management tools that will make a positive impact on your business!
€19 EUR in 2 days
5.0 (3 reviews)
1.5
1.5
User Avatar
Being an experienced data analyst and proficient in Microsoft Excel, I am confident that I can efficiently handle your Airbnb rental data management. From scraping, collecting, and manipulating data to producing powerful visualizations and creating automated processes using advanced formulas or VBA, I've got you covered. With my skills in Google Suite and finance, I'll not only create the new table you need but also ensure it syncs with your existing Table1 in Google Docs. Moreover, my proficiency in Power Bi and Tableau can provide you with interactive dashboards that could be extremely helpful for quick insights and future planning. Additionally, Adobe Acrobat expertise ensures any necessary customization or calculation needs for your PDF-based data. Let's get started today to streamline your Airbnb rental control system ensuring efficiency and accuracy with automatically updating results! Looking forward to discussing your project further and bringing value to your business. Feel free to reach out to me!
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i can do your excel table! I have long experiance working with excel and think that you will be pleased with the results! Based in Sweden Best regards
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
If you are in search of reliable assistance for Data Entry, Web Research, then you are definitely at the right place. Please check out my proficiencies below. Proficiency: · Data Entry . Content writing . Resume and cover letters . Top-Notch PowerPoint Presentations · Copy Paste · Web Research · PDF to Excel/Word · Image to Excel/Word · Online Data collection · Typing · Online Influencer research Deliverable Files: · Excel · Google Sheets · Word · Google Docs · PDF · PowerPoint · Google Slides Why should you contact me? · Efficient way of working · On-time delivery · Low-cost packages
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am interested in the job. With a background in data management, I offer meticulous attention to detail and a commitment to accuracy. My skills in data cleansing, analysis, and visualization, enhance my efficiency in data entry tasks. I am also able to present your data into visualized charts using Excel and Power BI. As a new freelancer, I am eager to apply my knowledge to ensure precise and efficient data entry, directly from the sources you provide. I understand the importance of accuracy and am ready to start immediately, promising high-quality work delivered on time. I look forward to contributing to your project's success. Best regards, Amir Ridhuan.
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm Stephen, an experienced professional in both accounting and data management. My strong background in both fields makes me an excellent fit for your Airbnb rental management project. I have expert level skills in Excel and can adeptly manipulate large datasets to generate meaningful reports, automated charts, and formulas. Creating the new table you described from your existing reservation information would not be a challenge for me. I can efficiently parse the Check-in and Check-out dates to generate yearly and monthly occupancy percentages, while also calculating the profit for each house. Ensuring that this table and the charts auto-update in your Google Docs environment is another task I am adept at. What sets me apart is my adaptability and ability to achieve targets within tight deadlines while maintaining quality results. With my extensive experience, I can assure you of streamlined, accurate, and timely management of your valuable Airbnb rental data. I look forward to showcasing my skills in driving your business forward with systematic data management through Excel. Let's get started!
€19 EUR in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
I am writing to express my interest in assisting you with your Airbnb rental business by developing Excel formulas and charts to efficiently manage your reservations and financial data. With my strong Excel skills and experience in data analysis and visualization, I believe I am the ideal candidate to fulfill your requirements. By choosing me to develop your Excel formulas and charts for your Airbnb rental business, you can rest assured that you will receive a high-quality solution that streamlines your data management and empowers you to make data-driven decisions for business growth and success. I am excited about the opportunity to work with you and contribute to the success of your Airbnb rental business. Thank you for considering my proposal, and I look forward to discussing the project in further detail. Warm regards, Dave Keitany
€26 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day, I have experience in handling large datasets, performing data analysis, and creating insightful visualizations using features like PivotTables, PivotCharts, and conditional formatting. Thus, I can work on you with this matter. Best regards, Queen
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir/ Ma'am, I am Krishna Kumar Pandit. I have read your project very well. I am very interested in this project. But sir/ Ma'am, I'm new at this freelancer. But we have knowledge of this project for 4 years. Please give this project to us sir/ma'am I will give 100% correct work on this project.
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, hope you are doing well! I have strong skills managing excels. My current job demands daily use of spreadsheets. I consider myself a detail oriented and very organized person. Thank you!
€15 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PORTUGAL
Lisboa, Portugal
5.0
7
Payment method verified
Member since Apr 12, 2014

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.