Make Calendar in Excel 2019

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024
  • How to Make Calendar in Excel 2019. You know that you can make a excel calendar in just 2 minutes for the whole year.
    Special features of this Excel Calendar
    - The calendar in Excel will take the Months name automatically
    - It will Have the dates entered automatically
    - It can be printed on 1 page
    ** Useful Excel formulas and Functions **
    10 Most Used Formulas MS Excel
    • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners || Part 1
    • Learn Basic Excel Skil...
    10 Most Used Excel Formula
    • 10 Most Used Excel For...
    *Most Imporant Excel Formuls Tutorials*
    Learn Vlookup Formula For Beginners in Excel
    • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews
    • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel
    • Create Speedometer Cha...
    Learn the Basic of Excel for Beginners || Part 2
    • Learn the Basic of Exc...
    Create Pareto Chart In Excel
    • Create Pareto Chart In...
    How to Create Dashboard in Excel
    • How to Create Dashboar...
    Excel Interview Questions & Answers
    • Excel Interview Questi...
    To watch more videos and download the files visit www.myelesson.org
    To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy

Комментарии • 91

  • @moraimarosario1756
    @moraimarosario1756 4 года назад +9

    I learned in 10 minutes what I have been trying to learn all my life. Thanks you sir1

    • @jcnetwork7331
      @jcnetwork7331 4 года назад

      how to press =cs+1 for the rest of the date

  • @jessicaquejano3167
    @jessicaquejano3167 2 года назад +2

    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.

    • @GuruJii
      @GuruJii  2 года назад

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @rafouroulyn4364
    @rafouroulyn4364 3 года назад +1

    Thank you you so much from France

  • @ramkumar-im8wd
    @ramkumar-im8wd 2 года назад +1

    So so so much helpful bestest video on u tube thanku so much

    • @GuruJii
      @GuruJii  2 года назад

      Thanks. To watch more video please visit www.myelesson.org/

  • @214Wildbill
    @214Wildbill 5 лет назад +1

    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 😊

  • @subhasispatnaik975
    @subhasispatnaik975 5 лет назад +3

    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 🙏

  • @BikeshJaiswal
    @BikeshJaiswal 4 года назад +1

    month is not changing automatically . How to do it?

  • @manjushakarkare3683
    @manjushakarkare3683 Год назад

    THANKS FOR EXPALINING IT IN SUCH A SIMPLE WAY!!

  • @fj_ideas
    @fj_ideas 3 года назад

    Thank you so much for your easiest way of teaching 👍😊

  • @tikaramrai9746
    @tikaramrai9746 5 лет назад +2

    Very helpful video sir thank you so much

  • @Lucky-ec8yl
    @Lucky-ec8yl Год назад

    Thank You So Much Sir

  • @alig7637
    @alig7637 3 года назад

    Thanks for posting needed to tweak further for my needs but didn’t know where to start. Thank you 😊

  • @tridibju
    @tridibju 5 лет назад +2

    Your style of speaking is amazing...i really like it...the videos are really informative...

    • @GuruJii
      @GuruJii  5 лет назад

      Thanks Tridib

    • @Fendy1
      @Fendy1 5 лет назад

      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.

  • @pinktita1044
    @pinktita1044 2 года назад

    I like the way you teach thank you so much ❤️😊

  • @watsgege
    @watsgege 2 года назад +1

    very clear and informative. 😀👍

  • @dollymaurya2039
    @dollymaurya2039 4 года назад

    aapka treeka bhut acha h smjhane ka sir ji

  • @shilpa3016
    @shilpa3016 2 года назад

    So greatt

  • @battinaraju6421
    @battinaraju6421 Год назад

    Thank you very much sir for this video im practicing with this video

  • @BankimNingom
    @BankimNingom 5 лет назад

    great very very very useful Sir👍

  • @AP-so5cu
    @AP-so5cu 11 месяцев назад

    Thank you so much sir!🙏💖

  • @dooduse
    @dooduse Месяц назад

    Itni khusi 😂😂

  • @S8LAD
    @S8LAD 4 года назад +2

    Thank you! that was fun learning! I like how you laughed at getting the 1st day of the year. :)

  • @markerbok3863
    @markerbok3863 2 года назад +1

    awsome work

    • @GuruJii
      @GuruJii  2 года назад +1

      Thanks. To watch more video please visit www.myelesson.org

  • @divyanshu5552
    @divyanshu5552 3 года назад +1

    Month names is not changing what to do

  • @Serpico85
    @Serpico85 4 года назад

    Thanks a lot very helpful and easy to apply

  • @technicalshiv2876
    @technicalshiv2876 2 года назад

    Super

  • @anjanbiswas1339
    @anjanbiswas1339 Год назад

    Date 1to 9 is OK,but outher date how to copy , please help for me ..

  • @ugurylmaz144
    @ugurylmaz144 Год назад

    How did you determine a month is 30 or 31 days?

  • @subhashdalai4316
    @subhashdalai4316 5 лет назад +1

    Superb sir...

  • @reformerx667
    @reformerx667 2 года назад

    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?

  • @shilpiagarwal1834
    @shilpiagarwal1834 3 года назад

    Thanku so much it is very helpful

  • @abhijitdebnath4718
    @abhijitdebnath4718 3 года назад

    Super helpful video ❤️ thanks sir

  • @Exceltrainingvideos
    @Exceltrainingvideos 5 лет назад

    That was really cool!

  • @AliButt-ho4uw
    @AliButt-ho4uw 4 года назад

    Sir v great thanks full, just simple formula for yearly calendar,

  • @abdiazizaweys7340
    @abdiazizaweys7340 5 лет назад +1

    Interesting its helpful

  • @jcnetwork7331
    @jcnetwork7331 4 года назад

    how to press +C5 or CS+1 enter for the rest of the date thx. how to drag the number

  • @sumondey4288
    @sumondey4288 2 года назад

    Thank you sir 😊

  • @Bloodbynaga
    @Bloodbynaga Год назад

    I didn't know how u dragged to next line after the 29 march

  • @sayedhadifarhang7462
    @sayedhadifarhang7462 4 года назад

    Thanks a lot, it was great.

  • @question3613
    @question3613 4 года назад

    yeyyyy thank you so much!

  • @coolsg10
    @coolsg10 5 лет назад +1

    BY typing MMMM i m getting december.. how to get january?instead

  • @arden083
    @arden083 5 лет назад

    a big help thank you so much !

  • @karmaneval
    @karmaneval 3 года назад

    how did you set the format in one page?

  • @AbdulHadi-us5yb
    @AbdulHadi-us5yb 5 лет назад +1

    How can i get the months name in full. e.g January not Jan.

    • @GuruJii
      @GuruJii  5 лет назад

      The months name is already in full since we are using MMMM as the legend on custom number formatting

    • @AbdulHadi-us5yb
      @AbdulHadi-us5yb 5 лет назад

      @@GuruJii ok Thanks, i used. MMM, i think thats why mine was not the full name. After all Thank you very Much.

  • @SouVannak
    @SouVannak 4 года назад

    Thanks good

  • @sibusisomondlane7585
    @sibusisomondlane7585 4 года назад

    what about for a leap year ?

  • @CristianoGentile
    @CristianoGentile 3 года назад

    This method is how not to make the calendar in Excel 2019...

  • @justzayimnot6884
    @justzayimnot6884 4 года назад

    Thanks

  • @najmulgani2814
    @najmulgani2814 5 лет назад

    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

  • @radhakrishnanradhakrishnan2122
    @radhakrishnanradhakrishnan2122 4 года назад

    Sir i have need which week

  • @sumitkothari5019
    @sumitkothari5019 5 лет назад

    Sir thank for this video. How to make multiple years calendar in simple way.

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp 5 лет назад

    Nice video

  • @Gunjangunja
    @Gunjangunja 5 лет назад

    sir ye proudct mgt or clender jaise sheet apki konsi playlist me milegi

  • @annezadonca3041
    @annezadonca3041 4 года назад

    thank you..

  • @shilpiagarwal1834
    @shilpiagarwal1834 3 года назад

    It is showing jan instead of may

  • @prassubontha123
    @prassubontha123 4 года назад

    months are not coming automatic

  • @vipinkumar-or1ki
    @vipinkumar-or1ki 4 года назад

    This is really amazing

  • @deepakanddeepika9952
    @deepakanddeepika9952 4 года назад

    Cool 😏

  • @Rahul-tq1oc
    @Rahul-tq1oc 4 года назад

    Sir mera march month nhi aa rha hai

  • @abuhamza235
    @abuhamza235 4 года назад

    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

  • @ravaksygaming5302
    @ravaksygaming5302 4 года назад

    Month name not changing automatically

  • @maleshkumarsahu1986
    @maleshkumarsahu1986 4 года назад

    very nice & very easy make a calender but yoyr language a dificoult

  • @ROSHANKUMAR-uo7zd
    @ROSHANKUMAR-uo7zd 4 года назад

    No I no change Feb date starting and ending 😔

  • @abdiazizaweys7340
    @abdiazizaweys7340 5 лет назад +1

    Thanks boss

  • @jcnetwork7331
    @jcnetwork7331 4 года назад

    how you do to drag ctral so that I dun nid to type day by day

  • @azmatullah6947
    @azmatullah6947 5 лет назад

    Please practice file

  • @jcnetwork7331
    @jcnetwork7331 4 года назад

    Can give me your assistance thx

  • @shamimshaikh385
    @shamimshaikh385 5 лет назад

    DEAR SIR IT'S NOT WORKING IN WINDOW 8

    • @GuruJii
      @GuruJii  5 лет назад

      It has nothing to do with windows version dost. It needs to be used in ms office 2007 and above

  • @jainmukesh5555
    @jainmukesh5555 5 лет назад +1

    Hindi please
    Dictaate in Hindi. Any problems

  • @maleshkumarsahu1986
    @maleshkumarsahu1986 4 года назад

    pleas translate in hindi

  • @fazalhanan5478
    @fazalhanan5478 5 лет назад +2

    1st viewer

  • @mushtaqali267
    @mushtaqali267 5 лет назад

    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

  • @spartan5863
    @spartan5863 3 года назад

    "RUclips gives me that benefit"
    i literally subscribed because how naive he is lol

  • @saif1official597
    @saif1official597 Год назад

    I know you can go naw 👍

  • @MohitBumb23Oct
    @MohitBumb23Oct 5 лет назад

    Awaz kahi dekhi dekhi lagti h 😁

    • @Gunjangunja
      @Gunjangunja 5 лет назад

      dekhi dekhi nhi suni suni hoti hai aawaj to

    • @MohitBumb23Oct
      @MohitBumb23Oct 5 лет назад

      Navya g suni suni to shakal hoti hai

  • @GeniusB-hz6dr
    @GeniusB-hz6dr 10 месяцев назад

    Complete waste of my valuable time

  • @vmatefahad9278
    @vmatefahad9278 5 лет назад

    Thanks