Automated School Time Table Using Excel Sheet DevTech Edu Academy #excel@devtecheduacademy

Playlist @devtecheduacademy
#excel #exceltutorial #exceltips #exceltricks #excelformula #attendancesheet #attendancesoftware #attendance #attendancemachine
#technology #tech #technical #timetable #timetableforstudents #timetabletrick #timetablekaisebanye #timetable2024 #timetable
-----********-------------------------------------------
in this session you will learn how to create school time table in excel sheet , with example. after session you will learn automation school time table for class study
Important Formula use in this
Filter
=FILTER(DATA!$E$5:$E$13,COUNTIF(TIMETABLE!E$5:E$13,DATA!$E$5:$E$13)=0)
Match Index
=IFERROR(INDEX(DATA!$J$4:$O$13,MATCH(TIMETABLE!E$5,DATA!$J$4:$J$13,0),MATCH(TIMETABLE!$C$5,DATA!$J$4:$O$4,0)),"")
school time table in excel, school time table in excel, school time table chart decoration ideas, school time table kaise banaye, school timetable making, school timetable making, teacher wise time table, school subject time table, timetable for class 8,school time table ,time table banane ka tarika,hindi mein time table,school timetable making,free timetable software for school, teacher timetable for school,high school time table 2022

Please this link to download this file

***** This work only office 365 version bcz filter not work in other version download and open in office 365
Important Video Watch Link:
How to insert a Video, Youtube link in google slides ! Google Sheet में वीडियो , यूट्यूब लिंक डाले
Automated Fee Management In Google Sheet
Automated Dayswise school time table
Automated School Time Table Multi Section Wise

[muhammadamir]

wonderful lecture about a hectic job.. But Sir, what about in case if there are more than one teachers for a particular subject and more than one section for a particular class????

[manmohankumar]

Thank you for worthful effort sir. I tried the first function, I found there is no FILTER instead there is FILTERXML in my Exell version. So what change can we make or is it possible to create with filterxml ?

[apsammapublicschool]

dear sir, this video is very helpful and is you kindly provide total period allotments per teacher it will be much helpful. thank you

[purnimakundu]

Plz give more different kinds of works in advance Excel

[sanjaykumarmhetar]

Very Nice Sir
Please send link of this file

[mnaveedkhan]

your website link is not i want to download the sheet from the link that you hv provided in description. Very helpful video

[sachindavid]

Sir there is a spill error while computing formulae in second period in time table

[MMarndi-fsxt]

Agar hr class Mein section ho toh kaise lagenge period

[javedamu]

What about days. There is no mention of days like if a teacher takes English in second period M, T, W and Hindi on TH, F, S in the same period.

[mubashirhassan]

If we have two teachers of same subject how to solve this issue

[sciencemonikamehta]

3 section, 3 subject teacher ho then how to make

[deepikaloona]

How to use if more than 1 teacher same subject to different sections

[SRPKUNENE]

How to add up to 35 teacher and grades for big school?

[pulipativamsinadh]

Very nice 👌 👍 can u please send me the link

[Azharbrp]

Validation lagane k time table me subjects cell select krke jab validation me jata hu to status sheet hi open nahi hota hai kese select

[bhupendrasutar]

आपके लिंक से एडिट करणे नाही कर सकते क्या

[tariqjaveed]

sir this file is not downloading please solve this issue

[salmansami]

if every subject has different time duration. Like math 45 min and English 30min. then how to do this