
Open
Posted
•
Ends in 3 days
Paid on delivery
I'm looking for an Excel expert to create a comprehensive mastersheet to manage commercial tenants renewals. Requirements: - Handle multiple data types - Functionalities: - Automatic reminders for upcoming renewals - Status tracking for each item from unit number to size to tenant name group name RD REd renewal status current rate monthly current rate per sqm previous discount avg monthly sales RTS TOR Budget and Benchmark - Data visualization (charts/graphs) - Rent vs Budget vs Benchmark vs RTS comparisons Ideal Skills: - Advanced Excel proficiency - Experience with data visualization - Strong organizational skills - Ability to set up automated reminders
Project ID: 39735092
68 proposals
Open for bidding
Remote project
Active 21 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
68 freelancers are bidding on average $127 USD for this job

As an accomplished Full-stack Developer with over 7 years of experience, I am well-versed in leveraging Excel to handle diverse data types and establish automated reminders—two essential needs for your comprehensive tenant renewals' mastersheet. I have a sound understanding of data visualization, an integral requirement for this project. My experience at significant companies like DXC Technologies and Elite Services has honed my organizational acumen, equipping me to skillfully track each unit's data from size to tenant name to renewal status. Aside from being proficient in Excel, I possess a wide array of complementary skills that could potentially amplify the quality and depth of the mastersheet, such as data processing, VBA and Macros coding, as well as my aptitude for Python and R-programming. These additional skills make me an excellent fit for handling your project requirements precisely. Not only will our partnership be marked by superior speed and accuracy—a track record I've upheld conscientiously—but also by my unwavering commitment to ensuring total client satisfaction. With my EST availability spanning 8:00 AM to 12:00 PM, I'm determined to add value to your project at a timeline tailored to your convenience. Let's connect further to delve into your exact expectations and how I can exceed them for you. Choosing me would mean choosing top-notch quality work with a relationship focused on long-term successes! Sandeep
$180 USD in 3 days
8.6
8.6

"""""""""""""""""""ADVANCE EXCEL EXPERT"""""""""""""""""""""""" ""Sir, I will build an advanced Excel mastersheet to track commercial tenant renewals with automated reminders, status updates, and visual dashboards. It will include detailed comparisons (Rent vs Budget vs Benchmark vs RTS) and interactive charts for clear insights. EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Certified business Accountant with more than 10 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 4 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, Power BI, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 400+ 5 stars reviews here. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Regards Arman Kakar "
$99 USD in 1 day
7.6
7.6

Hey! I’m an Excel expert with over 9 years of experience in creating custom solutions for managing complex data. I can design a mastersheet that streamlines your commercial tenant renewals and helps you keep everything organized and automated. Here's how I can help: * Build a comprehensive mastersheet that tracks tenant renewals with all required fields * Implement automated reminders for upcoming renewals and key milestones * Set up status tracking with visual indicators for each tenant (unit, size, renewal status, etc.) * Create dynamic charts and graphs for rent vs budget vs benchmark vs RTS comparisons * Use Excel VBA and macros for data automation, ensuring efficient updates and reminders With a focus on data visualization and workflow efficiency, your tenant renewal process will be smooth and transparent. Are there any specific date ranges or particular benchmarks you’d like to include in the reminders, or should I set them based on your typical renewal schedule?
$140 USD in 7 days
7.2
7.2

Hi, I create reliable and efficient Excel automation using VBA macros and advanced formulas customized to fit your exact needs and workflow. What I Can Help You With: Excel Automation & VBA Development VBA Development Excel Macros Automation Complex Formulas Custom Functions Dynamic dashboards, charts, and visual reports Pivot tables & data summaries Automating Repetitive Excel Processes with VBA Macros Custom Excel spreadsheets tailored to your needs Generating PDF Reports from Excel Data Converting PDFs to Excel Worksheet
$220 USD in 7 days
6.7
6.7

Hello zeynebn7 I hope you're doing well. I understand you're looking for Excel Mastersheet for Renewals I am the ideal candidate for your project. I have read the provided job description and I understand what you are looking for. I have over 10+ years of experience Visual Basic, Data Processing, Excel, Statistics, Excel VBA, Excel Macros, Data Visualization, Data Analysis, Automation, Data Management .Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. ✅ No Upfront Payment ✅ Release Milestone After Completion ✅ 100% Project Completion Rate You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$100 USD in 2 days
5.8
5.8

Hi zeynebn7, Thank you for considering my proposal. I have carefully reviewed your project requirements and believe my 8+ years of real-world and freelance Excel experience make me a suitable candidate for this project. I would love to assist you in creating a comprehensive Excel mastersheet for managing commercial tenant renewals. I am confident in my ability to handle multiple data types, set up automatic reminders, track statuses, and create data visualizations. I believe a chat discussion would be beneficial to further understand your needs and ensure a successful project outcome. Looking forward to connecting with you to discuss your project in more detail. Regards.
$30 USD in 1 day
5.9
5.9

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$140 USD in 2 days
6.0
6.0

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
$120 USD in 2 days
5.6
5.6

I am a versatile Electrical Engineer and Data Scientist with expertise in engineering, software development, data analytics, and academic writing. My skill set spans PCB design, FPGA programming, embedded systems (Arduino, MATLAB/Simulink), and signal/image processing, enabling me to deliver robust hardware-software solutions. On the software side, I develop scalable applications and automation tools in Python, R, C/C++, Java, and Google Apps Script, and build AI/ML models (CNN, RNN, LSTM) for forecasting, analytics, and decision-making. I transform raw data into actionable insights using Power BI, Tableau, Excel, and Google Sheets, delivering professional dashboards and financial models. With experience in business analysis, finance, and academic research, I ensure every project is backed by technical precision, clarity, and professional reporting — from concept design to data-driven solutions.
$140 USD in 7 days
4.9
4.9

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I ensure the delivery of robust and efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, and pivot tables; advanced array formulas; charts; pivot charts; Power Query; mail merge; email through Outlook and Gmail; add-ins; customized macros; and automate repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$100 USD in 1 day
4.2
4.2

Hello there, With extensive experience in statistical and predictive analytics, My proficiency in SPSS combined with my programming skills in Python will not only ensure an effective data analysis but also allow for flexibility and automation, optimizing efficiency throughout the process. Throughout my career, I have consistently proven my problem-solving mindset transforming complex datasets into clear and actionable insights that clients can use to drive their business forward. Data cleaning and transformation is an often-overlooked area of importance; however, it's where precise analysis begins. My vast experience in this area ensures thorough sorting of your data for accurate analysis - leaving no stone unturned. Lastly, I recognize that clear communication is vital to successful project completion. I assure you of my commitment in communicating regularly and effectively throughout this project, leaving no room for ambiguities. Trusting me with this project will not just avail you of a qualified individual but also someone who is dedicated in leveraging their knowledge and experience for unparalleled client satisfaction.
$30 USD in 1 day
3.9
3.9

✅ EXCEL EXPERT HERE! ✅ Creating an automated mastersheet for tracking commercial tenant renewals can streamline your processes significantly. Would you like me to implement automatic reminders integrated within your existing Excel data? With over 7 years of advanced Excel expertise, I can help you manage multiple data types effectively. I have extensive experience with data visualization, ensuring that your charts and graphs provide clear insights into rent vs budget vs benchmark comparisons. Additionally, I’ll set up reminders that will help you stay ahead of renewals, along with robust status tracking for each of your units. I’m eager to bring your vision to life and optimize your tenant management process. Let’s discuss your specific requirements in detail! Best Regards, Nguyen
$140 USD in 7 days
4.0
4.0

Hello, I'm interested in your project as I'm an expert in Excel and project management in general. Please contact me for more details and to discuss the project. Have a nice day. Best regards, Anis
$50 USD in 7 days
4.2
4.2

As an experienced data analyst and Excel expert, I possess the unique and specialized skills necessary for your project. Managing commercial tenant renewals requires not only advanced Excel skills, but a keen eye for data visualization and analytics. Over the years, I have honed these skills through numerous projects, integrating functions such as automated reminder systems and comprehensive data tracking which are integral to your needs. I guarantee that the mastersheet I will create for you will encompass all of your requirements with monthly tracking of rent, budget, benchmark, and comparisons. Moreover, my experience with data visualization will enable me to present the copious amounts of information in a way that is easily digestible yet informative for your team. From creating detailed charts/graphs for individual units to accurately tracking renewal status for each tenant, I ensure that these functionalities are seamlessly incorporated into the mastersheet. My organizational skills also allow me to handle multiple data types efficiently while ensuring their accuracy.
$30 USD in 1 day
4.1
4.1

As an experienced Excel and VBA developer, I have the technical skills and knowledge to provide an all-encompassing solution for managing commercial tenant renewals within a comprehensive Excel Mastersheet. My proficiency in handling multiple data types and my ability to set up automated reminders will ensure no renewal deadline slips by unnoticed. Additionally, my expertise in data visualization (using Power BI and Tableau) would be beneficial for analyzing rent versus budget versus benchmark comparisons. Moreover, beyond just being a specialist in Excel, I am also well-versed in other areas like HTML, CSS, WordPress, SEO, Google Ads, and social media marketing - this means that I can bring a more comprehensive perspective to your project. That said, my primary focus is on creating efficient solutions with the help of macros and automation; exactly what your project entails. Given my experience and deep understanding of effective data management structures and workflows, I believe that I would be an ideal candidate for this task. Together, we can create an automated and easily manageable system that will not only streamline your tenant renewal process but also provide actionable insights into your monthly sales performance using easily understandable visualizations. Let's join forces to give your commercial tenant renewals the attention they deserve!
$250 USD in 1 day
4.1
4.1

Hello, I have reviewed the task requirements and I am confident in my ability to meet them. With over 8 years of experience in Data Analytics, Automation, and performing various calculations and analyses, I have honed my skills using tools like VBA, Macros, Power Queries, Pivot Tables, and advanced Excel formulas. My expertise spans across several areas, including: Microsoft Excel: Advanced formulas, VBA/Macros, Dashboard creation, Data Analysis, and Web-Scraping. Adobe Acrobat: Creating and editing fillable forms, as well as scripting. Google Sheets: Advanced formulas, custom scripts, and dashboard development. Adobe Creative Suite: Proficient in Photoshop, Illustrator, InDesign, and Acrobat. WordPress: Experienced in managing and customizing websites. I am highly skilled in Microsoft Excel, Adobe CS & CC, Google Sheets, and WordPress. I am looking forward to your response. Thank you, Afshan
$100 USD in 1 day
3.5
3.5

Hi.I can build you a powerful, user-friendly Excel mastersheet that manages all tenant renewal details in one place. It will include automated reminders for upcoming renewals, clear status tracking for every field you listed, and smart dashboards with charts comparing Rent vs. Budget vs. Benchmark vs. RTS. With advanced formulas and conditional formatting, the sheet will not only keep your data organized but also give you instant insights at a glance.
$110 USD in 3 days
3.5
3.5

Hi, I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visualization Dashboards and i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks
$140 USD in 2 days
3.9
3.9

I am PhD writer with over 7 years of experience in various writing fields. I have completed thousands of projects, ensuring 100% accuracy and meeting client requirements. You can trust me to deliver plagiarism-free work within the agreed deadline while maintaining your privacy. I specialize in creating diverse content, from assignments and quizzes to business plans, sales and marketing plans, SEO articles, blogs, and more. Feel free to join the chat box and give me a try. I am dedicated to fulfilling and surpassing all your expectations, and I guarantee you won't be let down. I'm looking forward to hearing back from you. It's my portfolio link. https://www.freelancer.com/u/Stopsolution I’d love to hear about your Project. Message me!!
$30 USD in 1 day
3.9
3.9

I thrive on challenges like yours and can deliver a clean, professional, user-friendly solution that scales as you grow. I see you need a comprehensive Excel mastersheet for commercial tenant renewals. In a similar project, I boosted efficiency by 60% through automation and data visualization. Although new here, I’ve spent 4+ years mastering Excel, data visualization, and automation. Let's align on your priorities in a quick 10-minute call! Regards, Christopher Venter
$150 USD in 30 days
2.6
2.6

Doha, Qatar
Payment method verified
Member since Aug 26, 2025
$5000-10000 USD
$10-30 USD
₹1500-12500 INR
₹600-1500 INR
$5000-10000 USD
$30-250 USD
$10-30 USD
₹1500-12500 INR
$10-30 USD
$30-250 USD
$250-350 USD
₹12500-37500 INR
£20-250 GBP
$1500-3000 AUD
$30-250 USD
$250-750 USD
₹600-1500 INR
$1500-3000 AUD
$15-25 USD / hour
min $50 USD / hour