How To Create Horizontal Tabs, Add Students & A Menu With Icons In Excel [School Manager Pt. 1]

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@chibubichristopher2708]

some lessons are missing how can i watch them

[@iftikharahmad2947]

I am very thankful to you for starting this series. I requested it two months ago and now I am having it. So nice of you. Thanks a lot.

[@ExcelForFreelancers]

That is great. I am very happy to bring this to you. Thank you for your Likes, Shares & Comments. It really helps.

[@TradShowTom]

This is a great tool. The code is simple and short and works so flawlessly. I love that I can create multiple "forms" on one sheet with the end user being able to focus on one section cleanly. Thanks for sharing this with us.

[@ExcelForFreelancers]

For sure, you are very welcome. I am happy to help and share

[@VenemAcademy]

Hi Randy, thnx for this part. It's great. I'm working as an exam's manager on a school in the Netherlands and can provide some workflow cases if you wish. What I'm really looking forward to is the ability not only to administer general data but grades- and results data on subject classes as well. With this and to define graduation criteria can indicate a successful graduation. The grades-systems over the world differ a lot. In the Netherlands for instance, it is common to grade in the decimal system (for 1,0 - 10,0 where 1,0 is the worst and 10,0 is the best grade). But in the US it is common to grade with letters (A through F I believe). So, on the Admin sheet we must define this. Another thing is (I'm a Privacy Officer to ;-)), depending on the role of the app user, some fields of sheets(parts) can or can't be mutate/seen. Therefore, a rightssystem would necessary.

[@ExcelForFreelancers]

Thank you Eric-Jan. Since I don't have the industry experience on this one, your insights are going to be really helpful. Yes for sure inside the Admin sheet we will have a table to define grades and scores of all types. Please feel free to email me with samples, as it will come in really handy. [e-mail] I have also had a few requests for user-rights and multiple-user application so I will probably be adding this in as well. Thanks so much, this will be a great application with your help and feedback.

[@sonamdhendup5194]

Hi I am from Bhutan and I absolutely like your teaching. I'm learning lots from your videos. Keep up the awesome work... Thank you so much

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so happy I can help. Thank you for your Likes, Shares & Comments. It really helps.

[@Sebastien_Frederic]

Hello Mr Austin, I'm one of your biggest students, i learned and still learning a lot from you. I just want to say thank you for this great and wonderful project. I've just finished this part 1 and waiting for others ! Thank you Sir, Keep working ! # From Haïti

[@ExcelForFreelancers]

Thank you so much Sebastien, I really appreciate that and looking forward to bringing you many more every week. Make sure to watch, share and comment on each one. Thanks again.

[@Akulion1]

Love it! Following step by step and making the parts I really need to make one of my work tools get to the next level. Thanks for sharing this and also for explaining everything step by step so wonderfully. You rock!

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@angelacremonte9413]

I did something similar like this in MS Access for a school project. I based it from your vid which is very helpful. It's challenging and tiring but very worth it in the end. You're such a great help

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Angela. I believe you will love this serires.

[@jdinnen1]

Your channel and education method is second to none!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. :)

[@tonybarker4240]

Very much looking forward to this series - thank you Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate your continued support Tony.

[@buriwillie7660]

This is so good... Well done and thank you for giving time to do this School Manger System. Waiting for the next video...

[@ExcelForFreelancers]

It's my pleasure Buri, I am glad you enjoyed it. I can't wait to bring you many more in this series.

[@puskaraparna3084]

year for all of us, for so- it's still ongoing. i respect you for being honest as that's what's been keeping a bit sane recently, just being

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps Puskar

[@hamidfaska3324]

Thank you Sir. You're the best among KZbinrs. I like to follow you cause you explain things much better. You're my hero. Have a nice day!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Hamid

[@momtravelenger]

Hi, I am from Indonesia. I am really glad to find your youtube channel. This is what I want. Thank you Randy. I am ready to be your student

[@ExcelForFreelancers]

For sure, you are very welcome, please follow this series every week. Today we launch Part 10 so make sure you catch up. Thanks again

[@PiyushMedicalKnowledge]

This is really one of the marvelous creation by by the freelancers the Excel freelancer you really did it best

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that :)

[@ruffbean8570]

Hi there, this is not one of the best..it is the best tutorial I have come across after searching every where. I really wanted to keep track of my students assessment data and this is the best. But I will need your awesome assistance to help me out. Thank you so much for this wonderful tutorial and for sending me my free Automated Form Creator. You're a blessing. Thanks.

[@ExcelForFreelancers]

HI and thanks so much. I really appreciate that. If you would like to use this template, for yourself, you can download the final one, Part 20 I believe, then you can write some specifications to secure and customize it. Please then email me with those requirements ([e-mail] ) I can then refer a qualified developer since i am unable to take on any projects. I hope this helps and thanks so much.

[@usfullas]

I absolutely love your style of teaching! I'm very new to VBA & am finding the more I learn, the more I admire what can be done. The trick now is to find the right projects to apply this to & the time to build one of these beauties. Keep up the awesome work!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that LIz. Make sure you join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@edwinseabelo7253]

I think this tutorial will be the same as the Employee Manager, the one you did before and I can't wait for this training

[@ExcelForFreelancers]

I think its going to be better (hopefully) because this one I am going to do from scratch, during video, while the Employee Manager I did before the video, then explained what I did. Thank you for your support and watching these multi-part videos.

[@aamutawasa0]

Just watched part of this video. Excellent presentation.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@georbertathoo]

Thank yo so much Randy. It has helped me learn a lot from you Sir. Very proud of your VBA skills

[@ExcelForFreelancers]

For sure, you are very welcome I am happy to help.

[@DVSgolddust]

Thanks for this good memory refreshment I really needed that :) looking forward to Part2 :)

[@ExcelForFreelancers]

You are very welcome P. Rietveld, I am glad you enjoyed it and Part 2 will not disappoint.

[@patrickhunt6350]

I have not had time to watch all of it yet so you might have said this already, but could the schedule section include one for the teacher, so they know what class to teach. And one for each student, so they would know what class and room to be in. So excited for this. I have been trying to modify the hotel booking one to do this.

[@ExcelForFreelancers]

That makes a lot of sense to have a 'teacher view' and a 'student view' so that when we email schedules out to students or teachers they are very different. I have written down your excellent idea so you can expect to see it in the coming weeks.

[@frantonio1209]

Like always Superb Tutorial, and I wanted to thank you that you took in consideration my suggestion in just supplying the Template with out all the coding. Looking forward to part 2 of this project.

[@ExcelForFreelancers]

HI and thanks Frantonio. I appreciate your suggestion however 99% would want the code as well, so I would have to create multiple downloads. My suggestion would be to download the application with the code, then delete the code and start again so you can practice. I hope this helps and thanks so much.

[@czechyorker]

Another great training coming up. Thank you.

[@ExcelForFreelancers]

Thanks so much. I think you will really love this series.

[@kolavithonduraski5031]

this technique with selecting the "tabs" and showing / hiding the rows ... is easy but effective... i didnt even thought about it... never 😆 Thank you 😎🤙 it is a well strucutured project and video👍

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Kolavit

[@alkolff1031]

Good Morning Randy from mid America. Great start of a really insightful project.

[@ExcelForFreelancers]

Thanks so much Al, I always appreciate your comments. I am sure you will love this series.

[@papnyanamah2748]

Hi Randy, Thanks very much for this amazing work. To be frank, your teaching is addictive. I can’t get enough of it. I always look forward to every post from you. 🙏 You rock 👌

[@ExcelForFreelancers]

Awesome, thank you so much Pap. I really appreciate that.

[@mtani7228]

Thanks millions of time, it the best I have seen. I can't wait the next video please send it quickly

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Mustafe, These videos are released very Tuesday so the next one will be coming shortly. Much appreciated.

[@muhammadirfanabufazy339]

Thank you so much for all these tutorials bro. So much valuable knowledge

[@ExcelForFreelancers]

For sure, you are very welcome Muhammad.

[@wallyandkelly50]

Hi Randy! Thank you so much for this great tutorial. I was able to successfully create this sheet with no errors and it is doing what you showed. My question is.....When you select a different student, is all the information supposed to populate for that student in the general info tab or will that be gone over in one of the upcoming trainings in this series?

[@ExcelForFreelancers]

Hi Wally, thanks so much for your comment and glad you enjoyed the training. When selecting a different student from the drop down list, the selected student should auto-populate the fields. This happens based on code from the Worksheet Change Event. Please feel free to download my sample to check. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy

[@Khanwahid1992]

Thanks for this. It is very best and helpful tutorial for me. I have seen many tutorials for school management but it is my full stop video. I am excited for next part. Please upload next part Asap.

[@ExcelForFreelancers]

THanks so much. I will have a new one each Tuesday. It will be available here in just 36 hours: kzbin.info/www/bejne/baewg32ie9uclbM

[@egvNY]

Impressive & Outstanding Randy, !!! one could simple ran out of superlatives to describe this application, you have setup a new bar in Excel applications and customization.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Edward. I look forward to your feedback and ideas in this series.

[@SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing tutorial. I was actually looking for it for quite some time.

[@ExcelForFreelancers]

Thank you Syed, A lot of people have suggested it so it is about time I started this. Thanks again for your continued support.

[@Sajjad_1jm]

بارك الله بكم وبجهوكم ❣may god bless you many thanks

[@ExcelForFreelancers]

Its no problem, I am happy to help and share سجاد جاسم محمد عبد النبي

[@mdnasirahmed4686]

This is absolutely amazing

[@ExcelForFreelancers]

Thanks so much. Very kind of you Nasir

[@VinodKRamachandra]

Hey Randy, thanks a bunch for high quality tutorials. 8 minutes into the video. One suggestion. To select a student, i feel it will be a better approach if we use IDs. These can be alphanumeric. Because two students in the same class can hàve same name. Since it is part 1, would be easy to make changes if you want to. Apologies if i jumped the gun

[@ExcelForFreelancers]

Hi Vinod, thanks for your suggestion. I do actually have Student ID's however i can add a search/enter field to load students based on entering the student ID which may help. Thanks for the nice suggestion.

[@VinodKRamachandra]

@@ExcelForFreelancers Thanks. It will make things a lot easier.

[@preciousdadzie8106]

The long awaiting has finally dropped. Can't wait for it. Let's do up to Part 10. With the ability to email parents individually of their arrears and student results from excel.

[@ExcelForFreelancers]

Yes good idea. We have both Parents and Student emails, so in my Email & Notification Center I will include the ability to email parents and not students in some cases.

[@angkholdiy4004]

im from Philippines, great tutorial. thank you

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@JAVEEDAHMADDAR]

Was waiting for this from a long time part 2......

[@ExcelForFreelancers]

Thank you Javeed, Happy to share and help.

[@MrAitch_]

What I like to do with sheet codenames is prefix them with 'ws'. This has 3 benefits, 1. it is visually apparent in your code that you are referencing a worksheet 2. when you type 'ws' intellisense shows only your sheets and 3. you are unlikely to have any other variables with that name.

[@ExcelForFreelancers]

Thanks very much for your suggestion Mr. Aitch. Much appreciated.

[@akkintouch]

Scheduling please ... with daily and weekly and monthly options..along with predecessors.. I have been trying out the hotel management app.. but not going anywhere.. hope this series could help.. Hope u could include that Randy.. please 🙏

[@ExcelForFreelancers]

Hi and thanks Avi, yes most certainly we will be doing Day, Week & Month Scheduling Views since that is really an important part of this application. Thank you for your Likes, Shares & Comments. It really helps.

[@slminc]

Nice one - Thank you Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@shareefuddottu77]

good work king, love you

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@chumkiisrat3065]

Absolutely amazing

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Chumki

[@akcomputers456]

waow sir nice and one of the best school manager system, wait for next video

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@cryptogenie01]

Only source of best education on excel

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Farrukh

[@johnhendy803]

Great app I'm trying to adapt for a different purpose, learnt a lot and slowly getting there :) Just need to figure out why my SaveUpdate macro won't call and run the SortNames macro - nothing like a challenge :)

[@ExcelForFreelancers]

Hi John, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@SamOCoker]

I am having this same challenge

[@renedijkstra8323]

Hi Randy, what an amazing tutorial!! Sad though that some of the formulas won't work in Dutch Excel 365. What can I do about that?

[@ExcelForFreelancers]

HI and thanks I am sure we can get that fixed for you. Can you post your issues in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this and many are Dutch. Thanks so much.

[@excelofoin2622]

Hi, Randy. I'm enjoying your practicals. But I'm stuck. I don't get the part where you are creating the color change based on conditional formatting. Please can you walk me through it.

[@ExcelForFreelancers]

Hi and thanks so much. If you use an adjacent cell value, you can apply conditional formatting based on that adjacent cell (Or you can use shapes, which is probably faster and better and uses less memory like in the sample i gave you in your other comment)

[@mpb-d6n]

Could somebony explain to me what the Adv. Filter criteria does?

[@ExcelForFreelancers]

Hi Matheus, when using the this will filter out and exclude any values that are blank or empty. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@excelofoin2622]

Hi Randy, your tutorials are awesome. Can you help me the change in color based on click using conditional formatting. I've been stuck there . Thank you

[@ExcelForFreelancers]

Hi and thanks so much. Programming different colors in VBA with conditional formatting is extremely time-consuming. If you want to use multiple colors in multiple conditions use shapes instead. It's faster, easier to program and works extremely well. I show you how to do that here: kzbin.info/www/bejne/eX_So6GAbJqgkK8 I hope this helps and thanks so much.

[@saacidsaciid4415]

Randy Austin, thank you so much. What I want to request you in the second tutorial is that when I click on update button and didn't make any changes in the Target cells I want to get message box "please make at least one change to update student" then if the user makes change, save that change. That's all teacher. I'm sure you can. And you will in the second party. Thanks again.

[@ExcelForFreelancers]

Thanks very much for your suggestion. I will try to get this added. Much appreciated.

[@tressatuliau9426]

I totally love learning this. I do have a question though. I have more rooms than you do. for some reason I can't get them all to display and I receive this error Case Is = "Room" Room = .Range("CH" & ResultRow).Value 'Room SchedCol = Schedule.Range("P2:BB2").Find(Room).Column It is the last row of this that is erroring out. Where should I look?

[@ExcelForFreelancers]

Hi Tressa, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@judithavraham2460]

Shalom! thank you for your great videos. very informative and even though I felt that on this one, I was very much out of my depth, I was able to follow and do it all -. All apart from the last few minutes - the Student_SortNames ! it copies from different cells even though I formal is $ absolute. it's driving me crazy. - the sorted names column is two to the right of the full names column, and it seems that somehow the "Student_SortNames" copies from two columns to the right of the actual formal in the "full names column" - I have tried to figure it out but it's just driving me crazy. i want to move on the next tutorial but without this working, I don't think I should. thank you

[@ExcelForFreelancers]

Hi Judith, Thanks for your comment. I know it can be tricky at times. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@golamambia1296]

Love to watch your tutorial,❤️ from India

[@ExcelForFreelancers]

Awesome! Thank you Golam

[@bestscenes1469]

I can't wait for part 2

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I can't wait to bring it to you. Thank you for your Likes, Shares & Comments. It really helps.

[@HongkongTelecom1]

thank you, brother.

[@ExcelForFreelancers]

You are very welcome. I am happy to help Rashad

[@AndrewOgwang-p5l]

Thanks so much for this wonderful training. My question is how can I track the updates on fees balances. Calculation of fees balances automatically

[@ExcelForFreelancers]

Hi and thanks so much. You can set up a schedule of fees with an alert based on date, and update the balances. Next week I will have a Debt Manager coming that will help you with this. I hope this helps and thanks so much.

[@AndrewOgwang-p5l]

Yes thanks so much for this wonderful reply

[@richardschemionek8152]

Good day Randy Thank you very much for your videos and step by step instructions. I have the following question about the School Manager. How can I enter a change of address? That means I want to add a new address to an existing record. Is that possible? Kind regards Riccardo

[@ExcelForFreelancers]

Hi and thanks for your Comment Richard, If you want to have multiple address via a single record you can do that in a new table as long as the addresses are linked with a single ID such as "Student ID". All of the addresses can them be displayed in a small table in the Student Information. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@ashrafkader1972]

Thanks Randy

[@ExcelForFreelancers]

For sure, you are very welcome Ashraf

[@alonjon3606]

yo bro, really thankya. Big respect

[@ExcelForFreelancers]

Glad it helped. Thank you very much, I really appreciate that Alon

[@esempatv818]

Good work Rand

[@ExcelForFreelancers]

Thank you very much. So nice of you Esempa TV

[@checkyart]

This is awesome! Thank you for this amazing tutorial. I was wandering if you could do also a Fb group manager for admins (to take track of all the members, the roles, and the 'bad' members like a black list). btw thank you so much for this tutorial!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I will certainly consider the FB Group manager training in the near future. Thank you for your Likes, Shares & Comments. It really helps.

[@nicolassaumont7525]

Thank you so much for those explanations, it's so cool ! Can anyone can help me figure out how to fix the problem that appears at 1:51:06 please ? I can't find the answer in the video, I probably missed it... Thanks again !

[@ExcelForFreelancers]

Hi Nicolas, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@ahmadfaraz9833]

Great job Randy 👌

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Ahmad. Please make sure to watch each week in this series and you will learn how to build an amazing application.

[@wendylatimer4184]

Hello Randy, Thank you for video. I am having trouble with the conditional formatting for the Sel. Tab Col. When I click on the tabs, General Info etc. the number doesn't recognize the column number.

[@ExcelForFreelancers]

Hi Wendy, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@abcdef-mh9ix]

hi Randy, i used to follow your tutorial and always amazing. i want to ask you one thing. how you set an ID number to begin from 1001 or please demonstrate me which tutorial i shall attend to know this. thanks a lot

[@ExcelForFreelancers]

Hi and thanks so much. Assuming you have no data in your database and you want to set the Next Student ID to 1001 you would use a formula like this =IFERROR(Max(Stud_ID)+1,1001) I hope this helps and thanks so much.

[@VS-rh8rq]

This us great great lesson and will be comprehensive application. Any chance of including a lesson on how to run this application on secondary basis with all data being reinstated with master copy in case of unintentionally or intentionally temper of application. This borders around protection and security of application i guess.

[@ExcelForFreelancers]

HI Vimal thanks so much for your suggestion. I am sure you will love this. If you save this application in any type of a cloud folder such as Dropbox, OneDrive or Google Drive, each saved version is already stored on a server, protecting the data. That is probably the best and easiest solution since it does not require any additional programming. I hope this helps and thanks so much.

[@glennloterte4556]

WOW.... This is great.. Thank you Randy Austin.

[@ExcelForFreelancers]

For sure, you are very welcome. Make sure to catch Part 2 right here: kzbin.info/www/bejne/baewg32ie9uclbM

[@chandaatanu]

Very cool and nice tutorial. Thanks for your help with the codes.

[@ExcelForFreelancers]

For sure, you are very welcome Atanu

[@practicalhandsome9290]

PC but I'm going to start using Mac very soon and making tutorials on how to use soft soft on Mac effectively

[@ExcelForFreelancers]

Thats a great idea. Many people would enjoy this :)

[@sharmaneaurora6332]

Hello, can you please make a video tutorial on how to automate weekly Accounts Receivable Reporting. To calculate the accounts balance automatically based on Collection:Given there's 1 Check to settle one Account, 1 check to settle multiple accounts or vice versa. Thank you! Godbless

[@ExcelForFreelancers]

HI Sha, thanks very much. I have all of that, along with a complete Accounting system, inside the Accounting application developed in the Mentorship program. You can learn more about that here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/

[@ahmedeltayfy717]

So Great Mr.Randy wawoooooooooooooo

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Ahmed

[@FrederikLawson]

Hi Randy How to have an "In-Cell" or PopUp Calender for a Date field ?

[@ExcelForFreelancers]

HI and thanks, I have that available for download and training here: kzbin.info/www/bejne/hn2ke2NugbVqoac I hope this helps and thanks so much.

[@noemimarcolini6188]

Hi Randy, I was wondering if there was a way to add students doing copy paste from a old database, without adding a student at a time...

[@ExcelForFreelancers]

Hi yes and thanks, you can use my Data Import Manager training to do that (just search my channel) I hope this helps and thanks so much Noemi (You can also just copy and paste the students from your database to the current application)

[@bestgamertv1556]

Hi Sir do you have tutorial for making billing statement excel to pdf with dynamic tables? Thank very much!

[@ExcelForFreelancers]

Hi and thanks, I have one video that may help you called Conversion Manager here: kzbin.info/www/bejne/eYOshZeqnbKMorc I hope this helps and thanks so much.

[@kamalraj2050]

Amazing advice

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Kamal

[@zainababubakar9084]

looking forward to the complete series

[@ExcelForFreelancers]

Thanks its going to be a long one but certainly a lot of fun and a lot of learning.

[@zainababubakar9084]

@@ExcelForFreelancers Is it possible for the application to include an instant picture and fingerprint capture during the initial general information capture for students and teachers database?

[@ExcelForFreelancers]

Hi and thanks Zainab, if you have a fingerprint reader you can then translate that into a unique ID. This ID can be stored with each student. I hope this helps and thanks so much.

[@ishanverma5678]

Hi I am from india I watched all of your video, it's really Marvelous. Please make gst billing software.

[@ExcelForFreelancers]

Hi and thanks so much. My next series will be an automated time tracking and billing with GST. Thanks again.

[@rezawasil]

thnx sir u r the best excell trainer

[@ExcelForFreelancers]

For sure, you are very welcome Reza.

[@lmt125]

Fantastic tutorial! How can we make Excel be side by side with another app like a browser. I would like to see most of the Excel? I know how to split screen but I need to scroll a bit.

[@ExcelForFreelancers]

HI and thanks very much. There are some ways you can add a browser in Excel and also run them side by side. Perhaps you can add some screenshots and samples of what you are looking for in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@achieng_]

Hi Randy, Thank you for this great video. I have learnt so much. I was following along but on the Sort Names macro, I get a compile error saying that the SkipSort function or sub is not defined. How would I correct the error? I also tried adding more data to my database and when I do that, it sorts all the data in that row including the header. I have typed in all the VBA code exactly as you have in the video. I would really appreciate some assistance. I am watching from South Africa.

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@achieng_]

@@ExcelForFreelancers I have done that and have been assisted on the forum. I appreciate it and am looking forward to learning even more from this page 😃😃

[@HL1334]

Hi Randy, Thankyou for these amazing tutorials. It really helping us alot in learning excel macros. I would like to know is there any tutorial of yours where we can generate class schedules for a college so that we know exactly which room is booked at a particular time slot.

[@ExcelForFreelancers]

Hi Hassan, Thanks for your comment and question. I will be adding drag & drop class schedulers to this application in the coming weeks so please watch and share every week. Thanks again

[@abdiwelimohamed7848]

Hi Randy, am watching your tutorial very nice videos thanks more but i have a question where your create new rules formatting =mod(Row0,2)=o please check if am doing wrong

[@ExcelForFreelancers]

Hi and thanks so much. It looks like in your sample, the last character is a o (letter o) and should be a 0 (number zero) Mod(Row(),2)=0 I hope this helps and thanks so much.

[@abdiwelimohamed7848]

Thanks too that you're helping me, i got it. There's another question which is assigned macro to (New student) it's showing me (the item with the specified name wasn't found) @ExcelForFreelancers

[@ExcelForFreelancers]

Hi and thanks. this usually means that VBA is looking for a specific shape that does not exist on the sheet. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@davobiaz790]

Thanks for the video, your videos are always amazing. Sir, can you pls create an application in excel were on can attach JPEG or PDF files, and also download them.

[@ExcelForFreelancers]

Hi and thanks so much. I have that already here: kzbin.info/www/bejne/onm3Yahor6t1pbM Thank you for your Likes, Shares & Comments. It really helps.

[@jhaymhavz7961]

Good day, Can you create a excel program. Adding data horizontal?

[@ExcelForFreelancers]

Hi and thanks. I will do my best. If you need to have a specific application made for you, please feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@richardbrobbey2512]

I really enjoy the lessons. I want to learn VBA programming itself from scratch. Do you by anyway have videos on that...

[@ExcelForFreelancers]

Hi and thanks so much. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount

[@giftnkomophoya3814]

Hi Randy. This is simply awesome!!! Been following along and creating my own. Seems everything is working perfectly!!! The only issue am having is that when I add New Student the Student ID is not automatically being created. Also, what if there are pre-created Student IDs i.e. A2365, will that be able to work if someone enters these in any order? Thanks for the wonderful work. Gift from Malawi

[@ExcelForFreelancers]

Hi Gift, thanks so much and glad you like the training. Make sure you pull new student ID's from the cell that contains the formula =Max(Stud_ID)+1 Also if you want to combine alphanumeric letters with your id you can use a helper column. One column with only numeric values and another column to combine the text with numbers I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@saulcampos4404]

Hi randy thank you for these videos, they are an excellent source of knowledge! I do have one question Do you suggest we continue using non named ranges for larger projects? Example: on the horizontal tabs instead of having to write out which rows to un hide, would it be better (aka better “code” and “habits”) to name those ranges and use them as such? I even noticed on some loops you like to count out columns rather than do some sort of .count, I wanted to see if there was some reasoning behind this

[@ExcelForFreelancers]

Hi Saul, thanks for your comment. I like using as many named ranges as possible. I like to see them in the code and in formulas. In my big Accounting application I have hundreds of them. I once heard that too many named ranges slows down an application but I have never scientifically tested this theory out. So yes, adding named ranges in these instances will work very well. I hope this helps and thanks so much.

[@asmar8685]

Please I need a help. How can I arrange particular classes on a particular worksheet, for example if I'm building a school manager for primary school, I want each class to have its own list for payments

[@ExcelForFreelancers]

Hi and thanks you can create columns based on class, and then have VBA populate which last based on the class name or type. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@sarahkaan385]

Thank you so much for the tutorial. This is very useful. I am referring to your video and try to build a simplified version on my own. However, I have encountered a issue when trying to create the button. When I click on the new student button, the 'existing student group' button doesn't appear. Wondering if it is linked to the codes that I might miss out during the process. Hope you can guide me on this. Thanks a lot.

[@ExcelForFreelancers]

Hi Sarah, thanks so much. You can check your 'Selection Pane' to see which pictures exists and which don't, or are not displayed. Sometimes groups or shapes do not appear because their width or height moves to 0. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@keitamoussa2229]

Hi Randy!! I was following your first tutorial on my laptop but i got stuck in the VBA. The function "IF Not Intersect is not working here. I really need you to explain this part. Please ☺

[@ExcelForFreelancers]

Hi Keita, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount

[@jcook9784]

Another great learning experience. You mentioned Adioma for icons, but didn't include a link. Also, it doesn't appear they are "absolutely free", save for the free 7 day trial.

[@ExcelForFreelancers]

Hi and thanks so much. Here is the link: adioma.com/icons I have always used the Free option without issue. When you click Download just choose the 'free' option. I hope this helps and thanks so much.

[@jcook9784]

@@ExcelForFreelancers Perfect! Thanks!

[@frijoli9579]

This is very interesting. Is this a multiple user workbook?

[@ExcelForFreelancers]

Hi and thanks. Yes I will be adding multi-user functionality to this workbooks so please make sure to watch each video in the series.

[@peschiber]

Hello, Thank you very much: a great teaching video. I have a basic question: Why isn't the whole app not created with the help of forms? A little hint for people who don't use an English Excel version. First of all, I already failed at the first steps, I got error messages. Why? Because I used in the worksheet the function "=Culumn()". In the German version you do have to use the function "=Spalte()". This is irritating because in the VBA script you have to use "Culumn" instead of "Spalte". Yours sincerely Peter, El Salvador

[@ExcelForFreelancers]

Hi and thank you Peter. I really to wish VBA used a universal language. This makes it very difficult at times. I find sheet forms a lot more flexible than userforms, however we will be using userforms for login & out and other features. Thank you for your Likes, Shares & Comments. It really helps.

[@androidtech1402]

Great work, but could you zoom the point you are trying?

[@ExcelForFreelancers]

Hi and thanks yes I will try to use the zoom feature more when creating or editing these videos. Thanks for your suggestion and feedback.

[@androidtech1402]

@@ExcelForFreelancers Thank you😘☺️

[@roadilguiamat6699]

Thank you for sharing this nice video content

[@ExcelForFreelancers]

For sure, you are very welcome Rohaya. :)

[@edparaiso9218]

Can you help in the conditional formation of columns? When i click it condition did no materialize. Thank you in advance

[@ExcelForFreelancers]

Hi Ed, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@greaterloveministries4228]

Hi Sir, I want to start a school in my village and I want to buy the full school manager application to run it. Your thoughts will be appreciated 😊

[@ExcelForFreelancers]

Hi and thanks very much. You are welcome to download it for free using the link in the description and customize it yourself. I hope this helps and thanks so much.

[@djibysadji9634]

Hi! Your videos are amazing. I am thinking of adding a dropdown list named Grade in sheet Students. The idea behind this is to make the one in cell F3 load only the students of the grade selected in dropdown list Grade. How can I manage it.

[@ExcelForFreelancers]

Hi and thanks so much. You can add a Grade to the database and then, when the grade is changed, you can run an advanced filter in which the grade you selected is the criteria and then the results can be displayed. I hope this helps and thanks so much.