Find Jobs
Hire Freelancers

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

$10-500 AUD

Lukket
Slået op over 5 år siden

$10-500 AUD

Betales ved levering
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 :)
Projekt-ID: 17514463

Om projektet

41 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
41 freelancere byder i gennemsnit $240 AUD på dette job
Brug 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 på 4 dage
4,9 (365 anmeldelser)
8,0
8,0
Brug 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 på 10 dage
5,0 (302 anmeldelser)
7,6
7,6
Brug 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 på 5 dage
4,9 (269 anmeldelser)
7,5
7,5
Brug 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 på 2 dage
4,7 (318 anmeldelser)
7,6
7,6
Brug 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 på 6 dage
4,7 (101 anmeldelser)
7,4
7,4
Brug 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 på 10 dage
5,0 (212 anmeldelser)
7,1
7,1
Brug 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 på 3 dage
4,9 (329 anmeldelser)
6,8
6,8
Brug 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 på 1 dag
5,0 (191 anmeldelser)
6,8
6,8
Brug 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 på 3 dage
4,9 (232 anmeldelser)
6,9
6,9
Brug 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 på 3 dage
5,0 (91 anmeldelser)
6,5
6,5
Brug 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 på 3 dage
4,9 (40 anmeldelser)
5,7
5,7
Brug 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 på 5 dage
4,9 (55 anmeldelser)
5,8
5,8
Brug 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 på 5 dage
4,9 (104 anmeldelser)
6,1
6,1
Brug 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 på 2 dage
5,0 (58 anmeldelser)
6,1
6,1
Brug 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 på 10 dage
4,8 (105 anmeldelser)
6,0
6,0
Brug 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 på 10 dage
4,7 (57 anmeldelser)
6,2
6,2
Brug 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 på 3 dage
5,0 (22 anmeldelser)
5,3
5,3
Brug 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 på 7 dage
5,0 (20 anmeldelser)
5,2
5,2
Brug 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 på 3 dage
4,8 (82 anmeldelser)
5,6
5,6
Brug 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 på 5 dage
4,9 (34 anmeldelser)
5,0
5,0

Om klienten

Flag for AUSTRALIA
Australia
0,0
0
Medlem siden aug. 6, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.