Find Jobs
Hire Freelancers

Build me an excel/numbers client management system with auto colour coding

$10-500 AUD

Closed
Posted over 5 years ago

$10-500 AUD

Paid on delivery
Hi, I am Alexandra. I am a Speech Pathologist and would love help with a table that helps ensure all paperwork is done before due. I have had something similar when running a personal training business but didn't set that one up myself. I am after a number (or excel if required) table to manage clients. I would like a column for names (auto alphabetical), birthdays which automatically shows age (years and months) in the next column. I would like to be able to write a date that a report was done (for example) and then that will highlight eg green 46 weeks later, orange 48 weeks later and red 50 weeks later (eg 2 weeks before due again). Plus some other things. I would love to head from you if you can help :)
Project ID: 17514463

About the project

41 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
41 freelancers are bidding on average $240 AUD for this job
User Avatar
Hello, I can help with you in your project Build me an excel/numbers client management system with auto colour coding I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, PHP, Visual Basic. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 AUD in 4 days
4.9 (365 reviews)
8.0
8.0
User Avatar
Hi Alexandra! This can be done easily and quick, at least for what you are describing. Note that the table must be sorted manually in order to display data in alphabetical order, Excel cannot do that automatically. We can discuss the details in chat if you like. Best regards, Branislav Mihaljev
$283 AUD in 10 days
5.0 (302 reviews)
7.6
7.6
User Avatar
Hello, Alexandra! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. What you need, according to your brief, is conditional formatting and a set of formulas that will calculate time intervals. At this stage, I don't think that you need VBA code to deal with your requirements, but in case you need something more advanced then the code is the only option. I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'd like to talk further about this project with you whenever you're available. Please, let me know when it's a suitable time to communicate. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$250 AUD in 5 days
4.9 (269 reviews)
7.5
7.5
User Avatar
greetings! We will design an Excel spreadsheet with functions and codes so that we the cells will be automated as per your requirement. Please reply to my bid so that we can discuss further. Looking forward to hearing from you Thanks Brad
$88 AUD in 2 days
4.7 (318 reviews)
7.6
7.6
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$211 AUD in 6 days
4.7 (101 reviews)
7.4
7.4
User Avatar
I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$527 AUD in 10 days
5.0 (212 reviews)
7.1
7.1
User Avatar
Dear Client, I underrstand your requirement. I can set up a nice and easy to use interface in excel with all the automations like color coding etc, to solve your purpose. As far as my experience is concerned, I have done lots of projects in excel in the past using macros and formulas. I woulld love if you go through my profile once. Hope to hear from you soon. Roy
$250 AUD in 3 days
4.9 (329 reviews)
6.8
6.8
User Avatar
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing such Excel based solutions every single day. I can create an Excel Workbook exactly as per your requirement. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$50 AUD in 1 day
5.0 (191 reviews)
6.8
6.8
User Avatar
Hi Alezandra, how are you? My name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$250 AUD in 3 days
4.9 (232 reviews)
6.9
6.9
User Avatar
Hi Alexandra, Your client management tool project sounds very interesting and I think I would make a great fit! I have over 17 years of corporate experience working in Excel creating advanced automated dashboards, report, tools and calculators which included beautiful graphical displays of data/information. I enjoy creating complex algorithms using Excel formulas, and automating tasks for my clients using Excel is one of my favorite things to do. All of your requirements make perfect sense. I can automate the sorting of the names, and the birthday formula also will not be an issue. The auto highlighting of the rows based on the most recent report date can also be done using conditional formatting. Are you currently using any type of sheet to manage your clients today? I operate my home based Excel business full time using the skills I've obtained throughout my corporate career. I have attached a portfolio which includes screen shots of some of my most recent Excel based work if you’d like to take a look. Hopefully I can hear more and we can work together! Thanks either way for reading my proposal and best of luck, Shaun
$200 AUD in 3 days
5.0 (91 reviews)
6.5
6.5
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved programming, scripting, excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope Looking forward to hear from you. Regards
$333 AUD in 3 days
4.9 (40 reviews)
5.7
5.7
User Avatar
Hello I can help you to get it done quickly. I have 10+ years experience in php/mysql development. Thanks Guru Venkat
$83 AUD in 5 days
4.9 (55 reviews)
5.8
5.8
User Avatar
I have excellent command on MS Excel and can achieve all the objectives you mentioned. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$250 AUD in 5 days
4.9 (104 reviews)
6.1
6.1
User Avatar
With the current scope of whatever is explained in the project description, I could get an excel done and delivered to you in couple of hours except for auto ordering of name in alphabetical order. If you are very particular about auto-alphabetical ordering, it can only be done by writing a macro. If you are okay with couple of clicks, it can be done without the macro too. I am a Microsoft Certified Excel professional and I can definitely help you in setting up the excel that you require. Text me on chat and I will be happy to discuss further on the project.
$94 AUD in 2 days
5.0 (58 reviews)
6.1
6.1
User Avatar
Hello Sir, I have read your job description regarding Build me an excel/numbers client management system with auto colour coding. I have 6+ year of experience in Data Processing, Excel, Microsoft Access, PHP, Visual Basic. I have strong expertise to accomplish this project in decided time frame. Lets discuss in detail so that we never skip basic thing during project implementation. Thanks & Regards
$283 AUD in 10 days
4.8 (105 reviews)
6.0
6.0
User Avatar
Hi, Alexandra I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current project via Ms Excel or better(in my view) via Ms Access- very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$500 AUD in 10 days
4.7 (57 reviews)
6.2
6.2
User Avatar
Hi, Greetings of the day! I have read and analysed your project requirements in detail and am confident that my team of developers is more than competent in delivering your Automatic Excel sheet. We have worked on several Corporate & E-Commerce projects so far. Please Give Response For Our Proposal. We can discuss in details. We look forward to working with you in the near future. Best regards, Meenakshi
$444 AUD in 3 days
5.0 (22 reviews)
5.3
5.3
User Avatar
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$277 AUD in 7 days
5.0 (20 reviews)
5.2
5.2
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a complete system to accomplish your requirements. I will design excel file with vba programming to perform auto formatting, combo to selecting options, command buttons to execute tasks etc. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$230 AUD in 3 days
4.8 (82 reviews)
5.6
5.6
User Avatar
Hi, I'm an advanced excel expert. Please message me over chat so that I will sure help you in this project. Please check my profile as I did similar work on past and received completion review. Thank you!
$466 AUD in 5 days
4.9 (34 reviews)
5.0
5.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Aug 6, 2018

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.