Monthly Calendar in Excel | Standard function Oriented

  Рет қаралды 12,719

Innozant

Innozant

Күн бұрын

Monthly Calendar in Excel | Standard function Oriented
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#datecalendar#excelcalendar #innozant #excelcalendar#excelformulaandfunctions

Пікірлер: 121
@aqeelahmadengr3
@aqeelahmadengr3 3 жыл бұрын
Innozant educational channel
@Innozant
@Innozant 3 жыл бұрын
❤️❤️
@itsmalik84
@itsmalik84 2 жыл бұрын
There was a date less in January. January has 31 days. so where to show 31 of jan? should we add a new row? "NO". we would have to show that 31st in 1st row. and for that what formula should be in 1st row??? Plz tell
@sandeepaswal8944
@sandeepaswal8944 3 жыл бұрын
Sir I absolutely love your tutorials. I am learning excel here by watching your excel video sir .it is really amazing.
@Innozant
@Innozant 3 жыл бұрын
Thanks Sandeep Ji..God bless You dear.❤️❤️
@hiranaz5440
@hiranaz5440 3 жыл бұрын
Sir you are great teacher I learn a lot my prayer always with you May God give you more success and good health
@Innozant
@Innozant 3 жыл бұрын
Thanks Hira❤️❤️
@manojkumarsingh3385
@manojkumarsingh3385 3 жыл бұрын
Sir Aap ke Soch ke hum Salute karte Hai 🙏🏻🙏🏻🙏🏻🙏🏻
@Innozant
@Innozant 3 жыл бұрын
Thanks Manoj Ji . Happy Learning ❤️
@ibrahimkvlogs3220
@ibrahimkvlogs3220 3 жыл бұрын
Aapke padhane Ka andaj mera dil choo gya such love you sir god bless you 😍
@Innozant
@Innozant 3 жыл бұрын
God bless you my dear..Happy learning ❤️
@jayantabhattacharyya628
@jayantabhattacharyya628 3 жыл бұрын
Dear Sir Brilliant display of date calendar. Though it is not so easy to prepare whole year calendar in a excel sheet. But this calendar fetchs 30 days in January month. It's very important tutorial for preparing date calendar. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 жыл бұрын
Thanks Jayanta..oh jan 31 ..let me check and rectify
@gauravbanerjee7891
@gauravbanerjee7891 3 жыл бұрын
Guys like pehle click karo, video Baad mein dekhna, becus sir ke video me content knowledgeable, interesting aur life ke liye beneficial hote haain.❤️
@mzams2517
@mzams2517 3 жыл бұрын
Today i started to watch ur videos, super i like ur explanation method.
@Innozant
@Innozant 3 жыл бұрын
Recommend you take start your learning journey from Playlist Basic Excel onwards followed woth Advanced Excel
@vishwaschavan7182
@vishwaschavan7182 3 жыл бұрын
Great visualization Sir. After watching the video, I have prepared calendar for the entire year and will use it for future reference. Its really useful.
@Innozant
@Innozant 3 жыл бұрын
Good👍❤️Happy Learning
@sameenarafiq1339
@sameenarafiq1339 3 жыл бұрын
Informative lecture... delivered in superb way.... Thank you so much Dear Sir
@Innozant
@Innozant 3 жыл бұрын
Thanks Sameena for valuable appreciation ,Really means a lot to me. Kindly find interactive Monthly Calender example sheet from Video description for your practice ❤️❤️❤️
@sameenarafiq1339
@sameenarafiq1339 3 жыл бұрын
@@Innozant Thank you so much for your kind support I am really grateful ....
@anuragsharma2668
@anuragsharma2668 11 ай бұрын
Very nice calendar ❤
@createyour6681
@createyour6681 3 жыл бұрын
Very great sir
@Innozant
@Innozant 3 жыл бұрын
Thanks dear❤️
@kishorpanara4191
@kishorpanara4191 3 жыл бұрын
Great work sir thank you
@Innozant
@Innozant 3 жыл бұрын
Thanks Kishor❤️❤️
@mamtamishra7882
@mamtamishra7882 3 жыл бұрын
Sir uh r v talented.
@Innozant
@Innozant 3 жыл бұрын
Thanks Mishra Ji .Happy learning..Good Night..❤️❤️
@satishojha6240
@satishojha6240 3 жыл бұрын
Best teacher on excel 🤗🤗🤗. good night sir
@sravi991
@sravi991 3 жыл бұрын
Where is 31st Jan pls.... ?
@Innozant
@Innozant 3 жыл бұрын
Thanks dear..Gn
@Innozant
@Innozant 3 жыл бұрын
Didnt get you
@rajivranjan-mf6zu
@rajivranjan-mf6zu 3 жыл бұрын
Gr8 concept sir...👌👌👌
@Innozant
@Innozant 3 жыл бұрын
Thanks Rajiv❤️
@ORANGEPICTURESOFFICIAL
@ORANGEPICTURESOFFICIAL 3 жыл бұрын
Really great learning videos..... keep going sir.........
@Innozant
@Innozant 3 жыл бұрын
Thanks dear..God bless you
@Friend-z-Mania
@Friend-z-Mania 2 жыл бұрын
Great video ❤️
@allinonewithaks9496
@allinonewithaks9496 3 жыл бұрын
Awesome video sir... Thanks 👍👍
@Innozant
@Innozant 3 жыл бұрын
Thanks dear❤️❤️
@L.mkidifrentlife1435
@L.mkidifrentlife1435 3 жыл бұрын
Kash aap mere class wale sir hote to mai to inteligent bn jati sir jee aap bhut bhut best pdhate h
@Innozant
@Innozant 3 жыл бұрын
Thanks Dolly,Itna pyare aur valuable appreciation ke liye .Koi baat nhi ab Best banke dikhao aur ache profile ki job leke dikhao aap mujhe..Wo sabe best rhega❤️❤️
@L.mkidifrentlife1435
@L.mkidifrentlife1435 3 жыл бұрын
Thanku sir jee mai try krungi ki mai achi job hasil kr sku mujhe kam ki bhut zarurt h aur kam mil nhi raha mujhe English bhi nhi aati tipping spead bhi nh h pr exsl me kuch had tk mujhe kafi aane lga h
@Innozant
@Innozant 3 жыл бұрын
Ye sab bhta big issue nhi hai .jisme time denge usme behtar hote jayenge,aur mos profile h b ke liye koi bht typing speed ki jarurat nahi hai .aona excel strong kijiye ,Job ke loye try kriye achi job lag jayegi.Yadi aap Delhi ncr me job krna chahte hain to apko help krenge ydi skills apne upgrade kiya apna to sure.
@L.mkidifrentlife1435
@L.mkidifrentlife1435 3 жыл бұрын
@@Innozant thanku so much sir jee mai ab zyada dhyan dungi excel pr gud night and thanx again sir
@Innozant
@Innozant 3 жыл бұрын
👍GN
@sarojkakitchen
@sarojkakitchen 3 жыл бұрын
Sir Attendence Sheet banao naa oe data automatically month wise save ho dusare sheet mai aisa kuch
@Innozant
@Innozant 3 жыл бұрын
Ok Yogesh ji,Banate h video is topic par
@ramandeep14590
@ramandeep14590 3 жыл бұрын
Thanku for this wonderful✨😍 vdo sir
@Innozant
@Innozant 3 жыл бұрын
Thanks ❤️
@mohiuddinchoudhury1145
@mohiuddinchoudhury1145 3 жыл бұрын
Thank you very much Sir.
@Innozant
@Innozant 3 жыл бұрын
Thanks dear❤️❤️
@mohiuddinchoudhury1145
@mohiuddinchoudhury1145 3 жыл бұрын
Akdin milenge jorur aapse.
@aqeelahmadengr3
@aqeelahmadengr3 3 жыл бұрын
Every video liked
@Innozant
@Innozant 3 жыл бұрын
Thanks dear❤️
@himanshu6231
@himanshu6231 2 жыл бұрын
how to absent employees name highlight according to date in attendance sheet
@sathyanarayana4914
@sathyanarayana4914 3 жыл бұрын
Very beautiful vedio
@Innozant
@Innozant 3 жыл бұрын
Thanks Sathya❤️
@VikashKumar-mz9cm
@VikashKumar-mz9cm 3 жыл бұрын
It's very nice sir👌👌👌💓💓💓
@Innozant
@Innozant 3 жыл бұрын
Thanks ❤️
@t.k.rahimanthiruthikattil6159
@t.k.rahimanthiruthikattil6159 3 жыл бұрын
Sir very interesting but I have a problem... this calender can make in strait column? because I want to calculate my monthly overtime.can u help me.
@Innozant
@Innozant 3 жыл бұрын
Share your sheet
@kunalsharma2661
@kunalsharma2661 3 жыл бұрын
Good morning sir, Sir power query, dashboard, chart ki aur bhi videos aayenge yaa ye khatam ho gye????
@Innozant
@Innozant 3 жыл бұрын
Sharmaji abhi to 20 percent bhi complete nhi hua hai topic.Kuch time se tabiyat saatg nhi de ra tha isliye videos aane kam ho gye the.Again back on track.❤️❤️
@Narendar.pathak
@Narendar.pathak 3 жыл бұрын
Hello Sir good morning very nice video and explanation .par kya saare cell me ek sath cell value change kar sakte hai.agar haan to kaise
@Innozant
@Innozant 3 жыл бұрын
Query nhi aaya aapka samajh..ek baar explain kijiye kya chahte hain?
@Narendar.pathak
@Narendar.pathak 3 жыл бұрын
@@Innozant thanks for reply sir video dekhte samai question tha mind me to puchha par jab practice ki to solve ho gaya
@arunsandhu3087
@arunsandhu3087 3 жыл бұрын
Very important video. app kay fan ki list badti jaa rahi hay sir ji:)
@Innozant
@Innozant 3 жыл бұрын
Thanks Arun ji apke valuable appreciation ke liye .❤️
@durgeshrai8938
@durgeshrai8938 3 жыл бұрын
Bahut acha sir
@Innozant
@Innozant 3 жыл бұрын
Thanks Durgesh Ji❤️❤️
@manishgupta-ee3nb
@manishgupta-ee3nb 3 жыл бұрын
Amazing
@Innozant
@Innozant 3 жыл бұрын
Thanks Manish Ji
@sravi991
@sravi991 3 жыл бұрын
Also, one add on request. At d first instance, pls always mention which ver of excel your education will work properly. E.g. you demo sequence. But trial also will go for a six in excel 2007 usage
@Innozant
@Innozant 3 жыл бұрын
M using office 365 now..What version of excel you are using
@ibrahimkvlogs3220
@ibrahimkvlogs3220 3 жыл бұрын
My second comment sir big fan of you
@Innozant
@Innozant 3 жыл бұрын
Thanks Hemant Ji❤️
@asmrindia
@asmrindia 3 жыл бұрын
Great Sir, Very Beautiful Sir, 1. Aapne Isme Cell C6 Ko Freeze Kyu Nahi Kiya? 2. Result Me January Me 31st Kyu Nahi Aaya, August Ki Tarah? Bataiyega. Thanks Om Sai Ram
@Innozant
@Innozant 3 жыл бұрын
Oho freeze nhi koya hai kya?use rectify kar lena aap
@anilkumarparmar1784
@anilkumarparmar1784 Жыл бұрын
Calender me Holiday ka nam Aa sakta hai Jaisa ki 15 august hai to Independence day
@SandeepRawat-zn7ov
@SandeepRawat-zn7ov 3 жыл бұрын
Make a video on Power bi
@Innozant
@Innozant 3 жыл бұрын
Sure..after Power Qwery and Power Pivot series♥️
@SandeepSharma-rg5rd
@SandeepSharma-rg5rd Жыл бұрын
Sir January 31 kesa ayagi
@sravi991
@sravi991 3 жыл бұрын
Assuming January has 30 days only, it is good.
@Innozant
@Innozant 3 жыл бұрын
Why ..its perfectly fine..kindly apply the formula and check the result
@umeshchandarana8415
@umeshchandarana8415 3 жыл бұрын
Best
@ajgube007
@ajgube007 3 жыл бұрын
Boss Adab, Main Bangladesh se bol raha hu. Main apka video regular dektahu. Mane v chahatahu apkitara Excel may kaj Karu. Magar ai bat samaj nahi pata kaise kon sa palylist se start karu uiski bat konsi playlist dekhu.
@Innozant
@Innozant 3 жыл бұрын
Maine comment me aapke teply kiya hai ki kaise padhna gai plz fillow that
@ajgube007
@ajgube007 3 жыл бұрын
Thank you Boss
@ibrahimkvlogs3220
@ibrahimkvlogs3220 3 жыл бұрын
Sir ek video banaye jisme aap batao mis Ka kaam kaise kya karna hota hai
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 жыл бұрын
First viewer 🙏🙏🙏👌👌👌😎😎
@Innozant
@Innozant 3 жыл бұрын
Thanks Rahul Ji ❤️
@ajgube007
@ajgube007 3 жыл бұрын
Boss ap jode mujhko playlist ka step bata deta jesa first playlist then second playlist.
@Innozant
@Innozant 3 жыл бұрын
Dear..video ke description me already videos in sequence playlist link hain ki kaise padhna hai .saath hi Announcement playlist me video bhi Hai ki kaise sequence me learn karna hai.plz follow that
@PawanKumar-lc3du
@PawanKumar-lc3du 3 жыл бұрын
Thanx Sir ji, please send email ID for sending excel file of calender
@Innozant
@Innozant 3 жыл бұрын
@innozantofficial Waise aap video description se Calendar for year download kar sakte hain..link de diya hai maine updated
@PawanKumar-lc3du
@PawanKumar-lc3du 3 жыл бұрын
@@Innozant sir ji मैने कोशिस की है अगर आप देख लेते थोड़ी मोटिवेशन मिल जाती है
@sravi991
@sravi991 3 жыл бұрын
Sent attachment regarding. This to innozant, via email to u. Request to comment on this after going thru. Also, Request to suggest how remove d watermark automatically displayed on d 1st 3 mths. Xls used is 2007 ver.
@excel_point
@excel_point 3 жыл бұрын
🙏 sir Sir please power pivot aur power point ka series complete kijiye sir kitna wait kerna pdega plz sir 🙏
@Innozant
@Innozant 3 жыл бұрын
Haan..bnate hain ji..ab whi aayega jyada videos ..kuch time me
@excel_point
@excel_point 3 жыл бұрын
Thank you so much sir
@pa2happiness13
@pa2happiness13 3 жыл бұрын
👌🏼💞
@Innozant
@Innozant 3 жыл бұрын
❤️❤️
@sravi991
@sravi991 3 жыл бұрын
31st Jan absconding pls.. pls re do dear teacher.....
@Innozant
@Innozant 3 жыл бұрын
Kindly explain your query dear❤️
@RamnivasMeena
@RamnivasMeena 3 жыл бұрын
@@Innozant There should be 6 rows for including 31st January in Calender. Calender is Upto 30 January Only.
@mehtacomputer
@mehtacomputer Жыл бұрын
I also made a video on this topic, in a very short time
@johndas8173
@johndas8173 3 жыл бұрын
Sir app f4 bhul gaye
@Innozant
@Innozant 3 жыл бұрын
Haan...Linke me File attach kar diya hai dear..kindly check
@johndas8173
@johndas8173 3 жыл бұрын
@@Innozant ok sir
@ziazeniasbd
@ziazeniasbd 2 жыл бұрын
Issy easy way also have
@Innozant
@Innozant 2 жыл бұрын
Yes this is one of them
@starmodern7750
@starmodern7750 3 жыл бұрын
January 31 ka hota hai apny 30 ka dikhaya
@Innozant
@Innozant 3 жыл бұрын
Kahan..sheet check kijiye may be kuch wrong apply hua hoga..Kindly check and Rectify
@tarakmistry2748
@tarakmistry2748 3 жыл бұрын
January will be 31 days but 30 days have passed, the work of a cell is left.(=IF(I12
@Innozant
@Innozant 3 жыл бұрын
Ko fly debug the formula again
@anuj_jain7
@anuj_jain7 2 жыл бұрын
jan mahina 31 ka hota hai bhai ji....aap shuru me hi galt ho.
@Innozant
@Innozant 2 жыл бұрын
Anuj sahab ek baar phirse video dekhen .aur Fir btayen maoj shuru me hi galat hu ya galat concept samjh liya aapne😊
Top 5 Excel Productivity  Tricks | Excel Tips & Tricks
12:16
Innozant
Рет қаралды 17 М.
When Rosé has a fake Fun Bot music box 😁
00:23
BigSchool
Рет қаралды 6 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 68 МЛН
Mastering Excel's SUMPRODUCT Formula
12:21
Innozant
Рет қаралды 85 М.
Create a Calendar in Excel - Tutorial
8:07
TEKNISHA
Рет қаралды 103 М.
Top 5 Ultimate Advanced Excel Tips and Tricks
13:57
Innozant
Рет қаралды 60 М.
Excel Dynamic Filter with Search | Extract Data as You Type
11:51
Excel Dynamic Calendar | How to Create Calendar in Excel | Excel Tips and Tricks
12:32
Technical Computer Classes
Рет қаралды 27 М.