Learn How To Create Your Own Drag & Drop Scheduler In Excel Today [School Manager Pt. 12]

In this week’s training, I will show you how to create your own drag & drop scheduling feature in Excel.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:48 – Overview
5:15 – Refresh Day View
12:47 – Load Lessons Class
13:35 – Update Lessons Class
14:35 – Refresh Day View
18:05 – Go to Sheet Menu
35:40 – Expand Lesson
46:57 – Reset Lesson Height
50:44 – Sort Icons
1:07:07 – Select Lesson
1:42:23 – Check for Lesson Change

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelVBA #SchoolManagement #SchoolScheduling #ExcelTips

[slminc]

This is one of those. Never seen before. The more we see these tricks the more we go crazy on potential opportunities. Well done Randy

[dateseater]

Hi Randy.. I am amazed by the passion and the effort and the hard work that you put in in each of these videos that are running for nearly 2 hours. Hats off to you..Please continue the good work..

[robertswinden]

Many thanks for all your trainings Randy. I don't often comment as I watch them on my TV at night. But I have watched many, and every single one i've seen has been amazing. Also just signed up for the mentorship program, many thanks for the deal. Gives me a few more weeks to save up if I wish to continue.

[AlbertKitamirike]

Another fantastic training session. Thanks Randy for these great ideas.

[czechyorker]

Can’t wait. Thank you for this great training.

[SyedMuzammilMahasanShahi]

Thanks for this brilliant video Randy. It's amazing.

[temyraverdana]

Will be very interesting. I'm counting down waiting for Tuesday

[arlenegriffin]

Randy, something that would be very helpful is to let everyone know that they must have MS Office Excel. Other spreadsheet program such as open office do not work. I bought ms office 2019 so I hope that will work because I hope to sign up for mentorship program soon. Love your training videos. So very clear and easy to understand.

[esempatv]

Randy thanks for the good work. Can I get the complete school manager to manage my small basic school .

[techtrend]

Awesome Great Piece of Knowledge Thank u so much.

[claudclaud]

Thank you very match for all what are you doing it's amazing but it's so difficult to reproduce

[malcolmsokol]

Really having fun binge watching the school series. Learning a lot and the drag and drop scheduling was a real eye opener on technique. But I have a question about when you have a day view and have several classes occurring during the same time slots, which may only partially overlap, how do you check to make sure there are no enrolled students in common or have you taken care of this somehow and I missed this when you presented the enrollment data lesson. Seems to me you can't move if any of the enrolled students in the class being moved conflicts with any of the other classes for other teachers/rooms in the same time slot. Also again, do you check for already enrolled somewhere when you add to a class which should prohibit enrollment.

[sylvainhebert]

SchoolManager pt 12 Module SchedDayView : Erreur ...
.Range("A3:R" & LastRow).AdvancedFilter xlFilterCopy, CriteriaRange:=.Range("BA2:BO3"), CopyToRange:=.Range("CA2:CP2"), Unique:=True

[meka]

I love these session trainings, but I had on problem with the last session in part 11, , at the end the schedule part didn't pop up in my end, and I don't know what I did wrong

[learnwithdounia]

thank u very much sir,
How can i link the Microsoft visual basic with my excel file ?
and i have linux as operating system so is there visual basic for linux ?

[mariannehislop]

Now that everything is moving to the Cloud, and VBA not being supported in cloud or mobile apps, Excel is becoming redundant for us. Trying to find work arounds to keep using Excel so it can be accessed out in the field from a mobile device. Any solutions? Or is there a way to reproduce this in Google Sheets?

[sylvainhebert]

what is "Sched_Lesson_Select" ?

[jigneshshah]

SIR THIS DRAG AND DROP ONLY 3 ROOM BUT I HAVE TO CHANGE LESSON TO ROOM 4 HOW CAN I DO THAT COS ROOM4 NOT SO IN DAY VIEW ALSO IF I HAVE 1 EXTRA TEACHER FREE TO ASSIN THAT CLASS

[lion_]

Hey, Randy This Dev from India,
Just I show your video that's very nice during premium time I ask one question about "Custom_Letter_Creator.xlsm"
How can I make mails body As word document copy and paste in mail body As you use it for attachment.