#142

  Рет қаралды 25,475

Saha Computer Education Centre

Saha Computer Education Centre

Күн бұрын

Пікірлер: 48
@taslimanasreen8432
@taslimanasreen8432 2 жыл бұрын
I have doubt, if i change to new month , automatically all the days should get cleared, and if i go back and select the previous month, all the entries should remain same , how to do that
@stonespider
@stonespider 3 жыл бұрын
I had filled out the google form (given in the description box) requesting this excel template and received it in my mail within a week. Thank you.
@SahaComputer
@SahaComputer 3 жыл бұрын
Thanks for your comment.
@stonespider
@stonespider 3 жыл бұрын
@@SahaComputerI have a question for you. Google sheet is integrated with class exam paper and the students can attempt the exams multiple times but I want to keep only the first attempt and eradicate the multiple exam attempts (duplicate rows result entries, i.e duplicate admission numbers ) via Sorting the 'Admission number' column (since admission numbers are iunique). (The sheet also has a Timestamp column). So how can I create a range, use a a formula etc to remove the duplicate exam attempts (remove the duplicate rows)? Thank you.
@SahaComputer
@SahaComputer 3 жыл бұрын
I want to know about your exam paper. Is it made with google form or any other.?
@stonespider
@stonespider 3 жыл бұрын
@@SahaComputer yes exactly.. Google Form. So the Google sheet I am referring to is the responses sheet.
@SahaComputer
@SahaComputer 3 жыл бұрын
So there is a option to take only one response from one user.
@hrmanager8887
@hrmanager8887 2 жыл бұрын
Sir after preparing the attendance sheet. When I added more employees weekend helpers and holiday helpers didn't highlight. So what do we have to do next, we have to the color by ourselves or another option for an automatic fill-up.
@SahaComputer
@SahaComputer 2 жыл бұрын
you have to increase the range of conditional formatting.
@Sniperguy35
@Sniperguy35 3 жыл бұрын
Hello, I am a teacher online and I want to track my students attendance on Zoom. Will that work for me you think or would you recommend something better? Also, am I able to get this on my email?
@subhodiproy89
@subhodiproy89 3 жыл бұрын
If we select July and when I change to august it all data copied to august ,how to make it correct ?
@SahaComputer
@SahaComputer 3 жыл бұрын
When you completed your July Attendance then copy that sheet and rename it as July'2021 the Clear the master sheet and change it to August and start do your attendance for August. I trying to do what you are expecting.
@sumananag4234
@sumananag4234 2 жыл бұрын
Hello, You have built a very efficient attendance system. However I would like to copy the absentees of a particular day to another sheet. Kindly help.
@SahaComputer
@SahaComputer 2 жыл бұрын
I will try to make and create a tutorial video on it.
@Akshithagowdacp
@Akshithagowdacp 2 жыл бұрын
Hello sir, plz share the link of this video to create the attendance in google sheet
@SahaComputer
@SahaComputer 2 жыл бұрын
Watch this video you can create the file: kzbin.info/www/bejne/ppKUgKyYibmYaNU
@nigelwalker6443
@nigelwalker6443 3 жыл бұрын
Ok...my thing is...I want the students to mark their names when they enter their google classroom...like say, when they are in the google classroom they will click on that google sheet and mark their names for that particular day. So...You need to show what it looks like from the students end....and therefore, I will see it from the teachers end the students attendance as they are entering online in the google classroom. Thanks.
@SahaComputer
@SahaComputer 3 жыл бұрын
You can also do this by sharing a attendance form with student who will do their attendance with this form and the data will be received in google sheet. You can see the report of the attendance database in another sheet of same google sheet file. Presently I am working on it and I will upload the tutorial as soon as I complete.
@manikya9248
@manikya9248 3 жыл бұрын
SIR MERE ATTENDANCE SHEET PE DATE AND MONTH TO CHANGE HO RAHI HA BUT JO DATA FILL KAR RAHA HU BO CHANGE NAHI HO RAHA HA PLEASE HELP
@Sh-iu7mp
@Sh-iu7mp 3 жыл бұрын
If you change month in the above what happens all the attendance are same to the selected month also that's is bad
@SahaComputer
@SahaComputer 3 жыл бұрын
Actually this is single moth sheet, you have to a single sheet for whole year then you can achieve what you want. I giving a reference of a excel video you can watch it. kzbin.info/www/bejne/Z6WqhKOflJl1ldE And I will also make a video for google sheet also.
@jungonzales2301
@jungonzales2301 3 жыл бұрын
@@SahaComputer Do you Have a full year for GoogleSheet?
@SahaComputer
@SahaComputer 3 жыл бұрын
Not yet but I will create soon & upload.
@backofficearchtech6250
@backofficearchtech6250 9 ай бұрын
i want today's present & Absent
@avinashkori1217
@avinashkori1217 3 жыл бұрын
Bhai its a all good but please explained how's ready to format
@SahaComputer
@SahaComputer 3 жыл бұрын
Watch this Video: kzbin.info/www/bejne/ppKUgKyYibmYaNU
@NoorAhmed-xn5yt
@NoorAhmed-xn5yt 3 жыл бұрын
Plz tell how we can make it
@SahaComputer
@SahaComputer 3 жыл бұрын
Send me you mail address.
@NoorAhmed-xn5yt
@NoorAhmed-xn5yt 3 жыл бұрын
nak201617@gmail.com
@SahaComputer
@SahaComputer 3 жыл бұрын
File sent
@muhamadshuhaib
@muhamadshuhaib 3 жыл бұрын
@@SahaComputer shuhaibcyber88@gmail.com
@muhamadshuhaib
@muhamadshuhaib 3 жыл бұрын
@@SahaComputer Sir plz tell to me how build that's?
@Sh-iu7mp
@Sh-iu7mp 3 жыл бұрын
Sir plz show each month attendance saves dynamically through this app
@SahaComputer
@SahaComputer 3 жыл бұрын
You have to create full year sheet.
@ranganathaks748
@ranganathaks748 3 жыл бұрын
How to create above attendence show me please and upload video sir
@SahaComputer
@SahaComputer 3 жыл бұрын
kzbin.info/www/bejne/ppKUgKyYibmYaNU&lc
@divyarani2747
@divyarani2747 2 жыл бұрын
How to make this sheet..... I don't understand you only explain not show how to make.....
@SahaComputer
@SahaComputer 2 жыл бұрын
kzbin.info/www/bejne/ppKUgKyYibmYaNU
#139-Dynamic Named Ranges in Google Sheets (2021)
13:58
Saha Computer Education Centre
Рет қаралды 7 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 769 М.
Wait for the last one 🤣🤣 #shorts #minecraft
00:28
Cosmo Guy
Рет қаралды 18 МЛН
How to whistle ?? 😱😱
00:31
Tibo InShape
Рет қаралды 23 МЛН
Smart Sigma Kid #funny #sigma
00:14
CRAZY GREAPA
Рет қаралды 88 МЛН
How to Build an Attendance Tracker in Google Sheets
14:48
Spreadsheet Life
Рет қаралды 69 М.
Corporate Attendance Sheet, Fully Automated Corporate Attendance Sheet / Sheet never seen before
16:37
𝐎𝐟𝐟𝐢𝐜𝐞 𝐌𝐨𝐧𝐤 𝐔𝐫 𝐄𝐱𝐜𝐞𝐥 𝐂𝐨𝐚𝐜𝐡
Рет қаралды 61 М.
Make Employee Roster Template in Excel
25:47
ExcelDemy
Рет қаралды 36 М.
How to Create an Automated Attendance Sheet with Salary Calculation in Excel
33:18
Automated Attendance Sheet in Excel
41:46
PK: An Excel Expert
Рет қаралды 320 М.
#82-How to Make  Automated Attendance Sheet in Excel - Step by Step Tutorial
32:47
Saha Computer Education Centre
Рет қаралды 1,2 МЛН