Find Jobs
Hire Freelancers

programmed excel spreadsheet for tuition centre

$30-250 USD

Kansellert
Lagt ut over 5 år siden

$30-250 USD

Betalt ved levering
I am looking for someone who is very experience in programming excel spreadhseet. I am happy for someone to suggest me alternative if it can be done cheaper. As my business is small I need someone to programme a spreadheet to make it easier for us to do adminstration. Below is the description. I am running a small tuition centre and need an excel sheet programmed to do basic administration task. I need spread sheet to be able to do the follow task: I need sections to be restricted . such as staff detail, rota and accounting dashboard should not be accessed by everyone. 1. Registration Details of students and parents details 2. Staff details 3. Pupils attendance 4. New enquire sheet 5. Rota sheet 6. Accounting dash board Sales and Payments 7. Monthly Fees 8. Main Dash Dashboard 9. End of the day figures 10. Expected students Monday to Sunday Registration Details of students and parents details When students registered they fill in an application form and we need to add their personal details on the spreadsheet. This also includes their parents details. Each student is linked to a parent and we do not want to duplicate the parent entry. Therefore we want this to be done in 3rd form of normalisation. Also, each students has a package they are signed up to . Its different and I want to set this packages in spread sheet so it can be chosen from the list. Spreadsheet should also have an option if we manually want to set a package or price for a particular student. Staff details Just basic staff details need to be saved so we can managed Pupils attendance Students are signed up to different packages. I want a excel dashboard where we can search for a student name when he or she come to the centre . Then it should show list of classes taking place on that day and staff should be able to assign student to one class or more. This should get logged automatically in a sheet for us to see attendance on daily basis. New enquire sheet When a new customer call or makes an enquiry in the centre we should be able to log in some of their details and classify that as a potential lead. Then we should be able to add status: assessment books, not interested, follow up or something similar. Also, we should be able to book an appointment for new query. This should also reflect on a calendar and dashboard . Rota sheet We need a rota template set so we can assigned staff timings from Monday to Sunday. Then after rota section I need a section which will calculate their total hours for the week. Staff are paid on different rates for the total hours they work. So I need a column to select how many hours on rate 1 and how many hours on rate 2. Sales and Payments: any payment taken on daily basis should be logged on this page. Meaning cash or card payment. Monthly payment due In this section we need to have a name of students and name of parents set. This should have a section which will atomically tell us the price of students as some students are charged weekly and some monthly. Then it should automatically calculate how much payment is due. Some pay by direct debit, some by cash. We should be able to set this. On this sheet the name of parent needs to be taken from our direct debit sheet if the student is paying by direct debit. It make it easier to keep track of. Dashboard : This should includes detail as: Number of students enrolled Overview off attendance: daily, weekly and monthly New registrations this month Sales Targets Outstanding payments/payments cancelled End of the day figures: Number of students attended, total new enquiries, payments made by card and cash, absence students Expected students Monday to Sunday have total number of students expected on each day , then we should be able to identify absence.
Prosjekt-ID: 18430770

Om prosjektet

30 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 USD om 3 dager
4,9 (271 omtaler)
7,1
7,1
30 freelancers are bidding on average $220 USD for this job
Brukeravatar
Dear MALIKALIKHAN! After carefully reviewing the experience requirements for the job description, we feel that we are suitable for the job. Best regards,
$167 USD om 4 dager
5,0 (1201 omtaler)
9,3
9,3
Brukeravatar
Hello, I have gone through your job programmed excel spreadsheet for tuition centre and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satisfaction. I have the good knowledge of Database Programming, Excel, Excel VBA, PHP, WordPress .Please ping me for further discussion.
$250 USD om 4 dager
4,9 (602 omtaler)
8,5
8,5
Brukeravatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$199 USD om 2 dager
4,9 (216 omtaler)
8,2
8,2
Brukeravatar
Hi there. I have read your project i can provide you quality work in Excel programming i can provide you work in cheap price and fast as well. I love to work hard and satisfy my Client. I will be willing to work with you Soon... My Skill set is : Php, laravel, CodeIgniter, Smarty, Zend, symphony. Angular, React, Node, MongoDB, Javascript, JQuery, Ajax, Jason HTML5, Css3, FlexBox, CSS grid, SCSS, Bootstrap PSD Conversion, Designing, logo, Flyers... Android, IOS with React Native, Ionic, PhoneGap and any Hybrid app Progressive Web App(PWA) developer...
$120 USD om 3 dager
5,0 (68 omtaler)
6,9
6,9
Brukeravatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered seventy five excel vba projects in the last one year. I have read thro the requirements at a high level, and its doable. Willing to take up your project. Thank you, Regards.
$250 USD om 7 dager
5,0 (194 omtaler)
7,0
7,0
Brukeravatar
Dear Sir/Madam, I would like to offer you my services for your project programmed excel spreadsheet for tuition centre. I am an Accountant and Microsoft Excel Expert including VBA or Macros development. I can make sure to develop your process in Microsoft Excel according to your project description.I have developed many dashboard before. I perform variety of financial and accounting job including the following: *Bookkeeping *Accounting *Taxation *Payroll *Tax return filling *Financial modeling,projection or forecasting. *Process development *Business Plan *SOP I am also experience in Accounting Software Implementation,Integration,Data Transfer or Migration etc. I assure you quality job. Please message me for any questions or queries and I am sure to answer or reply there. Thanks Gopal
$100 USD om 3 dager
5,0 (36 omtaler)
6,7
6,7
Brukeravatar
Hi, what you need is small php Web app with mysql db. Let me develop it for you. Excel is not meant to do the job you requested. I can provide you multi user with access management app. Lets talk about this. Regards Fatih.
$555 USD om 10 dager
5,0 (16 omtaler)
5,9
5,9
Brukeravatar
Hi, if you can pay the right price I can make it happen for you. Thanks
$500 USD om 30 dager
4,9 (54 omtaler)
6,2
6,2
Brukeravatar
I'm master at programming excel scripts and running the macros which I have to extract data from the websites.
$100 USD om 2 dager
5,0 (52 omtaler)
5,6
5,6
Brukeravatar
Hello, Myself Bharat. I’ve read your project details & can see that you’d like to have a Virtual Assistant for your day-to-day business activities. I have been working as a full-time freelancer (Virtual Assistant) since 2016 with different freelancing sites. I can provide services on Data Entry, Web Research, E-mailing clients, Form filling, Copy and Paste Work, Application Form Filling, Image to Excel/Word, E-commerce Products Listing, WordPress Data Entry, Managing social media accounts- Insta-Gram, Twitter, Facebook, Google+ & other virtual assistant tasks. I am a quick learner and flexible worker. I always have internet access and ready to handle any administrative tasks. If you have any questions, do not hesitate to contact me. Have a nice day.
$50 USD om 1 dag
4,9 (51 omtaler)
5,7
5,7
Brukeravatar
1. Excel expert with extensive vba programming experience. I can help you with your data entry process and also offer possible alternatives. 2. I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. I would start by committing to 10 days but this depends on the scope and could change 4. I have an extensive background in Excel. I would love to know more about your project.
$194 USD om 10 dager
5,0 (1 omtale)
3,8
3,8
Brukeravatar
I can do the task for you in ms Excel however i would suggest ms acess as an alternative as it is more suited for the type of records that you want to maintain. I can do it in ms access as well.
$200 USD om 5 dager
5,0 (1 omtale)
3,1
3,1
Brukeravatar
Hi, I've been in excel vba and ms access for 3 years and currently creating company tools for users reporting. I can help you with your project by creating vba macro for you. Please let me know to discuss further your requirements. Thanks, Marlou
$250 USD om 5 dager
2,3 (7 omtaler)
4,1
4,1
Brukeravatar
yes buddy,,a very easy project to do,,,apart from it, i will help u to automise ur centre, u will feel brotherhood......................
$90 USD om 3 dager
5,0 (3 omtaler)
0,8
0,8
Brukeravatar
Hi. My name is Rafael, I'm a computational system engineer and I have 7 years experience programming softwares on Excel VBA and some other languages with a good performance and good looking. I have a great backup of similar softwares modules as you asked for database, with security levels and other functions, which will improve its development time and quality. It would be a pleasure working with you.
$150 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I have a diversified work experience in audit and consultancy. I have prepared accounting manual of large to medium size of organizations. This demonstrates my capability and competency to handle this project. Most important is that being auditor i am well experienced to work under deadline and pressure.
$155 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hello! I have more than 5 years of experience in financial modelling and Excel. I developed sophisticated Excel spreadsheets and model which allow to automize the processes of calculation, data integration, etc. I am highly interested in you project and will be glad to assisit you in preparing of such comprehesive spreadsheet as you described it. I pay special attention to design and structure of Excel works, so that the user can easy use and review it. Sincerely yours, Simon
$210 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I want to work this job please hire me I am very poor
$155 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I’m your guy for this work. Based in UK, Scottish born. Build spreadsheets such as this for a living. Cv below ******* Craig has extremely strong skills in Excel and as well as being an advanced user, comfortable with all facets of the software, has ran excel training groups and provided email helpline support for Excel issues across companies he has worked for. He has vast experience building advanced Excel models to be used in industry (energy, financial and public sectors) and very much enjoys coming up with solutions and problem-solving issues relating to data management and visualisation. Craig’s Excel experience involves building various models (to request) to present or convey data/information to clients. This not only involves using advanced functions (vlookup, hlookup, match, index, array functions etc.) but also paying close attention to quality control and quality assurance procedures when building a model/workbook.
$222 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Please state. You will be happy to take this order. Because I also carry out such orders. I invite you to contact Maria.
$222 USD om 10 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED KINGDOMs flagg
london, United Kingdom
4,9
12
Betalingsmetode bekreftet
Medlem siden nov. 6, 2008

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.