Thank you so much. This is very helpful. Don't stop posting videos like this. This helps students like me who doesnt listen during lectures. Hehe God bless.
I have been watching ur vdos since a long time, have downloaded the Excel beginner, intermediate and advance course vdos too, m about to complete the advance one. Your way of teaching is extraordinarily well and helpful. I would b glad if u can make a detailed video only on pivot table and macros covering all their related stuff.thank you 🙏
The problem is that he pauses mid sentences after the verb and before a noun - it's really distracting!!! Examples 1:21 "What you need to do is ...." 3:25 "display just the ... month name!" 5:02 "show ... the ... date" 5:42 "I'll have to do ... this ... last one." 6:24 "February will start on a .... so what I'll do is" 6:38 "See, this has also become ... February." It may be a habit from Indian teachers or professors, but native English speakers do not speak like this - it is unnatural and very irritating. Nevertheless, the guy knows what he's doing, and the content is helpful.
This is very clever and great fun, thank you for sharing. Just one question - since we needed to check the proper calendar for the first day of the year - why not just keep checking it whenever we need to know the date?
To automatically find the day for the first day of the month, Just put the date 1/1 or whole date, 1/1/2019 For that cel go to your settings use this, mmm ddd d It will read "Jan Tue 1". I like the day first, Have a good day 😊
Sir your video is very helpful I have one question I am doing Different School Exam question Paper Typing Work I want How to Generate Automatic Question Paper in Excel I have also Job in school school is automatic Generate Question Paper , In question Paper I have Category, Question and Heading , any, out of Marks for Example (1) Very Short answer? (2) Number of Question 20 but i want only 12 question Print in Question paper. Plz help me
Please share pass fail farmula by subject wise agar student ka ek sabject me between 32-20 mark h to hum usko taraqqi. Denge, agar 33 se upper h to pass denge, agar between 10-19 h to dobara exam lenge, agar 1-9 h to fail kar denge agar 2 subject me between 10-19 h to fail kar denge, please share farmula
AOA may mushtaq Ali from Karachi Pakistan janab apka ye tutorial wonderful hay balkay saray vdos remarkable hain I have learned a lot. Calender may ek problem arahee hay may excel 2019 use kr raha hun jab may February ka data copy krta hun aur phir formula change krta hun to wo March ke first date display krnay kay bajayey Feb ke 29 date show kr raha hay bhaut baar try kia mgr wohee 29 show krta hay pls help me asap Mtq@email. Com Thanks
Thank you you so much from France
Thank you so much. This is very helpful. Don't stop posting videos like this. This helps students like me who doesnt listen during lectures. Hehe God bless.
Thank you. To see our latest videos please visit www.myelesson.org/
I learned in 10 minutes what I have been trying to learn all my life. Thanks you sir1
how to press =cs+1 for the rest of the date
awsome work
Thanks. To watch more video please visit www.myelesson.org
So so so much helpful bestest video on u tube thanku so much
Thanks. To watch more video please visit www.myelesson.org/
Thank you very much sir for this video im practicing with this video
I have been watching ur vdos since a long time, have downloaded the Excel beginner, intermediate and advance course vdos too, m about to complete the advance one. Your way of teaching is extraordinarily well and helpful. I would b glad if u can make a detailed video only on pivot table and macros covering all their related stuff.thank you 🙏
Thanks for posting needed to tweak further for my needs but didn’t know where to start. Thank you 😊
THANKS FOR EXPALINING IT IN SUCH A SIMPLE WAY!!
Thank you! that was fun learning! I like how you laughed at getting the 1st day of the year. :)
Me too 🤣
Thank you so much sir!🙏💖
Very helpful video sir thank you so much
Thank You So Much Sir
Thank you so much for your easiest way of teaching 👍😊
I like the way you teach thank you so much ❤️😊
So greatt
great very very very useful Sir👍
very clear and informative. 😀👍
Super helpful video ❤️ thanks sir
Thanku so much it is very helpful
aapka treeka bhut acha h smjhane ka sir ji
Thanks a lot very helpful and easy to apply
Your style of speaking is amazing...i really like it...the videos are really informative...
Thanks Tridib
The problem is that he pauses mid sentences after the verb and before a noun - it's really distracting!!! Examples 1:21 "What you need to do is ...." 3:25 "display just the ... month name!" 5:02 "show ... the ... date" 5:42 "I'll have to do ... this ... last one." 6:24 "February will start on a .... so what I'll do is" 6:38 "See, this has also become ... February." It may be a habit from Indian teachers or professors, but native English speakers do not speak like this - it is unnatural and very irritating. Nevertheless, the guy knows what he's doing, and the content is helpful.
Sir v great thanks full, just simple formula for yearly calendar,
Thank you sir 😊
month is not changing automatically . How to do it?
How did you determine a month is 30 or 31 days?
Superb sir...
Month names is not changing what to do
This is very clever and great fun, thank you for sharing. Just one question - since we needed to check the proper calendar for the first day of the year - why not just keep checking it whenever we need to know the date?
Interesting its helpful
Date 1to 9 is OK,but outher date how to copy , please help for me ..
yeyyyy thank you so much!
To automatically find the day for the first day of the month,
Just put the date 1/1 or whole date, 1/1/2019
For that cel go to your settings use this, mmm ddd d
It will read "Jan Tue 1".
I like the day first,
Have a good day 😊
That was really cool!
Thanks a lot, it was great.
Super
a big help thank you so much !
Thanks good
I didn't know how u dragged to next line after the 29 march
how to press +C5 or CS+1 enter for the rest of the date thx. how to drag the number
Nice video
how did you set the format in one page?
Thanks
Sir i have need which week
Sir your video is very helpful I have one question I am doing Different School Exam question Paper Typing Work I want How to Generate Automatic Question Paper in Excel I have also Job in school school is automatic Generate Question Paper , In question Paper I have Category, Question and Heading , any, out of Marks for Example (1) Very Short answer? (2) Number of Question 20 but i want only 12 question Print in Question paper. Plz help me
Itni khusi 😂😂
Sir thank for this video. How to make multiple years calendar in simple way.
thank you..
How can i get the months name in full. e.g January not Jan.
The months name is already in full since we are using MMMM as the legend on custom number formatting
@@GuruJii ok Thanks, i used. MMM, i think thats why mine was not the full name. After all Thank you very Much.
BY typing MMMM i m getting december.. how to get january?instead
Cool 😏
what about for a leap year ?
This is really amazing
sir ye proudct mgt or clender jaise sheet apki konsi playlist me milegi
Month name not changing automatically
months are not coming automatic
Can give me your assistance thx
Thanks boss
very nice & very easy make a calender but yoyr language a dificoult
1st viewer
Thanks Fazal
@@GuruJii you're welcome Sir.
It is showing jan instead of may
No I no change Feb date starting and ending 😔
Sir mera march month nhi aa rha hai
This method is how not to make the calendar in Excel 2019...
Please practice file
DEAR SIR IT'S NOT WORKING IN WINDOW 8
It has nothing to do with windows version dost. It needs to be used in ms office 2007 and above
how you do to drag ctral so that I dun nid to type day by day
Please share pass fail farmula by subject wise agar student ka ek sabject me between 32-20 mark h to hum usko taraqqi. Denge, agar 33 se upper h to pass denge, agar between 10-19 h to dobara exam lenge, agar 1-9 h to fail kar denge agar 2 subject me between 10-19 h to fail kar denge, please share farmula
"TH-cam gives me that benefit"
i literally subscribed because how naive he is lol
AOA may mushtaq Ali from Karachi Pakistan janab apka ye tutorial wonderful hay balkay saray vdos remarkable hain I have learned a lot. Calender may ek problem arahee hay may excel 2019 use kr raha hun jab may February ka data copy krta hun aur phir formula change krta hun to wo March ke first date display krnay kay bajayey Feb ke 29 date show kr raha hay bhaut baar try kia mgr wohee 29 show krta hay pls help me asap
Mtq@email. Com
Thanks
pleas translate in hindi
Hindi please
Dictaate in Hindi. Any problems
Awaz kahi dekhi dekhi lagti h 😁
dekhi dekhi nhi suni suni hoti hai aawaj to
Navya g suni suni to shakal hoti hai
I know you can go naw 👍
Complete waste of my valuable time
Thanks