Devam Ediyor

programmed excel spreadsheet for tuition centre

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.

Beceriler: Veritabanı Programlama, Excel, Excel VBA, PHP, WordPress

Daha fazlasını gör: best online excel training, excel courses, advanced excel tutorial pdf, excel classes near me, excel classes, excel formulas, free online excel course with certificates, best excel tutorial, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, reformat excel spreadsheet, year plan excel spreadsheet, programmed excel, tuition centre software, excel template call centre, design tuition centre, tuition centre, stock option spreadsheet, option spreadsheet, excel services tuition & lessons london

İşveren Hakkında:
( 7 değerlendirme ) london, United Kingdom

Proje NO: #18430770

Seçilen:

Tanmoy236

"""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 m Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(184 Değerlendirme)
6.7

Bu iş için 32 freelancer ortalamada $222 teklif veriyor

sapotacorp

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 in 4 gün içinde
(1012 Değerlendirme)
8.7
schoudhary1553

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 satisfac Daha Fazla

$250 USD in 4 gün içinde
(308 Değerlendirme)
7.7
zekovicm

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 de Daha Fazla

$199 USD in 2 gün içinde
(97 Değerlendirme)
7.0
periyannas

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. Willi Daha Fazla

$250 USD in 7 gün içinde
(80 Değerlendirme)
6.1
caabdul

Hi, if you can pay the right price I can make it happen for you. Thanks

$500 USD in 30 gün içinde
(49 Değerlendirme)
6.1
hoisticdeveloper

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 Daha Fazla

$120 USD in 3 gün içinde
(16 Değerlendirme)
5.7
SShtv

Hello I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data Daha Fazla

$150 USD in 3 gün içinde
(65 Değerlendirme)
5.7
AkhilWP

I'm master at programming excel scripts and running the macros which I have to extract data from the websites.

$100 USD in 2 gün içinde
(50 Değerlendirme)
5.5
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$250 USD in 5 gün içinde
(68 Değerlendirme)
5.4
JinMeng08

Hello, I have read your requrement in detail. I am WORDPRESS DESIGNER AND DEVELOPER. As you can see my profile, I am professional and loyal to clients and all the clients are satisfied with me. I am good expert of Daha Fazla

$155 USD in 3 gün içinde
(8 Değerlendirme)
4.8
BHARATBEURA

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) sinc Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
4.1
brobb07

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 usin Daha Fazla

$194 USD in 10 gün içinde
(1 Yorum)
3.8
fadata

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 F Daha Fazla

$555 USD in 10 gün içinde
(2 Değerlendirme)
3.5
nitinvarsani

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 in 5 gün içinde
(1 Yorum)
2.3
marloufin

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 Daha Fazla

$250 USD in 5 gün içinde
(7 Değerlendirme)
4.1
soltracker

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 in 3 gün içinde
(2 Değerlendirme)
0.9
sjanda

The British spelling of programme, I don't see it enough even though it's how it should be spelled in my home country! I am a civil engineer with extensive experience in Excel. If you look to my portfolio, I have ma Daha Fazla

$240 USD in 4 gün içinde
(1 Yorum)
0.4
GopalJp

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 Daha Fazla

$100 USD in 3 gün içinde
(3 Değerlendirme)
0.5
GayathriManoj

Hi there, Expertized VBA Programmer, proficient in customized ribbons with VBA and access VBA. I hope, will be able to work with you on this task. I will always work towards quality and ontime delivery. M Daha Fazla

$750 USD in 10 gün içinde
(0 Değerlendirme)
0.0
maria174041

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 in 10 gün içinde
(0 Değerlendirme)
0.0