Excel Date Maharaj Part-1 | Interview Oriented Realtime Excel Questions and Solutions

[@anuragsharma2668]

Thankyou ji

[@pramodbhavsar4488]

Sir your every any excel function use is excellent simple but very logical and use simple way in examplain by you I salute your knowledge . I always wait your youtub videos everyday . Thank you sir

[@Innozant]

Thanks Pramod Ji🙏❤️

[@tejpalsain1507]

बहुत बहुत बढ़िया सर जी। धन्यवाद।

[@Innozant]

Thanks Tejpal Ji❤️🙏

[@aqeelahmadengr3]

Value added things. Informative videos. Good work.

[@Innozant]

Thanks Dear ❤️🙏

[@dilipshedge8503]

Thank you so much, you are doing wonderful job

[@kishorpanara4191]

Dear Sir you are great great great and again great Thank you sir

[@Innozant]

Thanks Kishor❤️🙏

[@bhoopendraraghav9781]

Unique teacher....

[@Innozant]

Thanks Bhoopendra ji❤️🙏

[@gulshanmehta6997]

Definitely it is real time problems, solution. Thanks Sir🙏🙏🙏🙏🙏

[@Innozant]

Thanks Gulshan Ji❤️🙏

[@pradeepjangid490]

गुरु पूर्णिमा पर आपको नमन

[@Innozant]

Thanks Pradeep Ji🙏❤️

[@rajivranjan-mf6zu]

Difficult requirement and Great solution Thank you sir...👌👌👌

[@Innozant]

Thanks Rajiv Ranjan ji❤️🙏

[@sandeepaswal8944]

Sir I love your all interview questions. Daily I follow your all videos. Thank you so much sir. You are great mentor❤

[@Innozant]

Thanks Aswal sahab.You are reallh veru dedicated person .God bless you

[@VikashKumar-mz9cm]

Bahut achha sir ❤️❤️❤️

[@Innozant]

Thanks Vikash ji

[@mumbaisejalgems8767]

very nice, really appreciate your way of teaching, big thanks

[@Innozant]

Thanks Dear..God Bless you .❤️🙏

[@jayantabhattacharyya628]

Dear Sir Superb Date Maharaj video. Every Date question is very useful & interview oriented. Especially the third question is very very important. These will definitely enhance my excel skills. Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta 🙏❤️

[@createyour6681]

Very great sir

[@Innozant]

Thanks 🙏❤️

[@AnupKumar-oe2jb]

Thank you so much. Thanks a lot

[@Innozant]

Thanks Anup Ji

[@anilkachhwaha7815]

Great Sir Ji

[@Innozant]

Thanks 🙏❤️

[@deepankaramarnath4500]

Too good,

[@Innozant]

Thanks ❤️👍

[@sushilaswal8950]

You are hero sir Very useful tric

[@Innozant]

Thanks Sushil Ji❤️🙏

[@researchr]

Your video is helpful for skill 🥰

[@Innozant]

Thanks dear ❤️❤️🙏

[@prasenjitmandal5486]

You are amazing sir

[@Innozant]

Thanks Dear 👍🙏

[@chandanmishra1758]

Thanks sir . After watching your video grow my skills and I cracked the interview. And company offering me 4 lacks package. Thanku so much sir ❤️

[@ayanbose9626]

wow amazing and congratulations sir, well what is the profile that you are selected for.

[@Innozant]

Congratulations...Wow..Mishra ji...God bless you..Party the baati hai dear ..😀M truly happy for you..Have a wonderful career ahead. Ye 4Lac to shuruwat hai...aap learning kabhi mat chorna ..humesha kuch naya seekhna.

[@chandanmishra1758]

@@ayanbose9626 senior mis executive

[@chandanmishra1758]

@@Innozant bilkul sir first learn the. Earn is my moto. By the way party Kahan Karen agar Delhi ya ncr me aap rahte ho to batayein isi bahane apke Darshan bhi ho jaayenge 🙏.

[@hsgusain2054]

Excellent Sir

[@Innozant]

Thanks dear🙏❤️

[@satishojha6240]

Excellent sir 🙏🙏🙏. good night sir

[@Innozant]

Thanks Satish Ji .Good Night🙏❤️

[@veerdhadra]

Superb..!!!!!!!!

[@Innozant]

Thanks ❤️🙏

[@onlyexcel493]

Good efforts sir

[@battlefansshorts8941]

Thank you sir ❤

[@Innozant]

Thanks ❤️

[@kanchanyadav1240]

thank you

[@Innozant]

Thanks Kanchan ji .hope you are learning now

[@dqfashionfactory6470]

Daily one topic I'm improving day by day

[@Innozant]

Thanks dear

[@rewawaleashu1554]

Nice class

[@aqeelahmadengr3]

Plz add more videos on date mahraj list

[@Innozant]

Offcourse this is first video of Date maharaj ..will upload morr videos

[@Chandan_Kishor]

Kindly make video on MS access 🙏

[@Innozant]

Ok.. noted

[@naveenkumarsharma9445]

Sir, pls suggest the way to learn excel and get into financial analyst domain. Please reply

[@Innozant]

Dear start your learning journey from basic excel followed with other associted tool to start your career in data analytics.Will guide you furhter if you stuck somewhere

[@Altaf_Alam]

Sir we can also use sumifs formula to find the total stock of a specific month 😃

[@gauravbhatia7987]

Thnq sir 🙏🙏🙏

[@Innozant]

Thanks ❤️🙏

[@vishalbhati912]

Sir last wale sawal me. ek helper column leke usme text formula lagake or fir sumif lagake bhi kar sakte he na. Jyada easy or chhota formula rahega

[@Innozant]

Haan attempt krke share kren kaise krenge 👍

[@vishalbhati912]

@@Innozant ok. Sir jarur

[@vishalbhati912]

@@Innozant kzbin.info/www/bejne/jJ3IaqOdd6-phpI sir this is the link for that solution which im talking about. Achha lage toh Please Reply Dena.

[@AbhishekKumar-nb4et]

Hello sir Please tell me that ..kya sirf advance excel sikh ke job kar sakte hai

[@Innozant]

Offcourse..As Mis Executive job lagne me koi prob nhi .bht saare candidate mis executive profilr par sirf adv excel ke base par achi salary par hain

[@AbhishekKumar-nb4et]

Thanks sir 🙏❤️😊

[@AbhishekKumar-nb4et]

Aapne mera confidence aur bada diya🙏❤️😊

[@Innozant]

Mehnat kariye quit mat kariye..m sure yyou will get good package job...Best of luck

[@sekharispassion]

Sir, Thank you for the date formulas. 1. Now we can prepare a calender based on your 2nd workings. 2. Sumproduct formula is good but have to practice to understand the calculation. I think I can use pivot table to get the result by dragging dates to rows field (convert automatically to months) and stock to values.

[@Innozant]

Ok..👍❤️

[@umeshchandarana8415]

Best. But why to multiply by 30 in 1st.?

[@Chandan_Kishor]

Sir please microsoft access par video banaiye

[@Innozant]

Ok..Noted.it wilp take time but will surely make these videos❤️🙏

[@khalidalisubhanallah2947]

Nice video

[@Innozant]

Thanks Khalid sahab

[@durgeshrai8938]

Nyc🙏 sir

[@Innozant]

Thanks 👍❤️

[@pa2happiness13]

Nice sir, Laikin sir Mera wala question upload nahi kiye

[@Innozant]

Kaunsa ques.. telegram par bheja tha aapne?..bht saare queries aate hain..miss ho gya hoga dear

[@pa2happiness13]

@@Innozant Sir ♥️🙏 mai nai telegram Mai nahi bheja comment box Mai likha tha question, KZbin Mai video Views 1k, 2k, 3k, 1m, 2m, 3m etc jis trah aatha hai oh Excel Mai kaisai banaye

[@Innozant]

Are dear bataya to tha custom format me jaake k thoudand laga dijiye...excel tips and tricks me bhi ye banaya hua hai video dear

[@gauravbhatia7987]

Hlo sir, sir meri ik query thi sir maina Large ka formula lga raha tha second salary nikalne ke liye condition ke sath jase two condition hai tab toh ham array ke through solve kar sakte hai but sir large multiple condition ko nhi smj paa raha jaise maine large if ke sath bhi use kiya aur array ke sath bhi but sir output nhi ayi plc app multiple condition ke sath large or small ka function use karke dikha dijiye jaise two condition se yada jaise 3,4 condition then output?

[@Innozant]

Ok .yaad dilana kisi video example me add kar denge

[@munendrarathore01]

Wah...

[@Innozant]

Thanks ❤️🙏

[@Sarita_Classes]

Sir 1 kyun sabhi function main add kar rahe hain...pls reply

[@Innozant]

1 true ko evaluate karta hai na

[@shambhuahir5200]

How to use condition with now formula ? Pls help this topic

[@Innozant]

Kindly ask your query whag you want the do woth this formula association

[@shambhuahir5200]

@@Innozant shambhu ahir

[@shambhuahir5200]

I want to shift change according to time change

[@durgeshrai8938]

Nyc sir

[@Innozant]

Thanks Durgesh❤️🙏

[@umeshchandarana8415]

Sir Macro ka bhi ek lecture lijiye please.

[@Innozant]

After BI

[@lkumar2727]

Power pivot or power query par or video baniye.... Yeh function toh khuch dino baad bhul hi jaane h..... Isse acha power pivot or power query bar focus kijiye

[@Innozant]

Kuch dino baad bhup kyu jaane haij.myadi use krenge to.Yes will make complete tutorial on power query,power pivot and power bi Busy these days for a couple of week will upload more videos soon

[@RahulRoy-po9ct]

🙏

[@piyushthakar7304]

Sir can you resolve one problem I want to sum 3 different tenures years of exp exactly in year and month format. For Eg. 12.9 Yrs, 3.6 Yrs and 2.8 Yrs, when I sum it it gives me wrong result. Can you resolve it how to calculate.

[@Innozant]

Offcourse it shows eeror as its evaluate it as text ..kindky share datasheet @innozantoffciaal telegram id..once m free will see

[@piyushthakar7304]

@@Innozant Sir I am not able to send you xl file as it is showing as resteicted

[@shambhuahir5200]

How to calculate any date with now formula pls explain

[@Innozant]

Koi situation dein jab ye apply kren ya main khud koi example base ye dono formula aapko applg krke dikhau

[@shambhuahir5200]

@@Innozant khud bataiye sir

[@shambhuahir5200]

@@Innozant example base formula bataiye sirji

[@shambhuahir5200]

Sir jese ki ek colume me now formula apply Kiya hai or dusri colume me mujhe result chaiye ki agar time 15:00 jyada ho to "b" shift Likha aana chaiye

[@shambhuahir5200]

Pls replay

[@YasirKhan-mb1iy]

I used "=MONTH(DATEVALUE("1"&A3))" to get the month number, and "=TEXT(DATE(2023, A5,1),"mmmm")" for the month, but your solution,was easier

[@prashaant6471]

योर वॉइस इस लाइक मिस्टर योगी जी

[@Innozant]

Hahahaha ❤️

[@sakachauhan9472]

Sir 1 kyu lgate h pls btaye

[@Innozant]

Us Month ka 1st date

[@shambhuahir5200]

Mene 2 quireies Ka pucha tha sir Kari din Aapne replay hi Nahi Kiya

[@Innozant]

Ok..kis name se hain..will chack and try to reply you dear

[@shambhuahir5200]

Telegram me bhi to Kabhi replay kardo sir...

[@Innozant]

Dear bht jyad query aate hain ek din me,..reply krne ki koshish hoti hai meri but sbke puche gye prob ka solutions utne kam time me possible nhi hai

[@somisharma4847]

Very helpful vedio sir. Sir pls start the cls on VBA

[@Innozant]

Thanks Sharma ji..yes will start this series 👍❤️

[@Ashok_8889]

Sir Date Validation ke liye koi video banaiye .jaise ki mujhe ek data entry google form ya google sheet pr karwana hai ab mai unhi logon ka Date of birth fill karwana chahata hu jinki age 18 se 30 aaj ki date me ho chuki Hai. Aap se anurodh hai ki kuchh aisa date validation lagaiye ki jo today() formula ke sath kam kare. Asha krta hu ki mera prashn aap ko samajh me aa gaya hoga. Thanks Ashok Verma (8840256464)

[@Innozant]

Yes Ashok Ji..bnate hainnrelated videos apke query ka..Thanks