Respected sir I m from Pakistan. Your way of teaching is mind blowing. I appreciate your way of teaching and pray for your success. May God bless you ever. Thanks
sir now, your subscribers are unhidden. i can't believe. apke bs 69k approx subscribers hai. jabki ap to hum sbke liye kitni jyada mehnt krte ho. sir ap jesa teacher mene ajtk nhi dekha. you are great sir. i hope ki apke jld hi millions me subscribers ho ❤️
Thanks Deepak ji for your love ,support and concern. Yes underrated ,but maine kbhi bhi views pane ke liye nhi padhane ke liye video banaya hai tabhi aap mere channel par ek bhi short videoa kabhi nhi dekhe honge..Keep learning..keep exploring ❤️👍
Sir Thank you for the tricks. In case of summing k values more then 3, then I make some changes to the formula you explained. SUM(IFERROR(LARGE(IF((range as explained in the video = value to lookup), range of values to sum), ROW(INDIRECT("1:30"))),0))
bhaiyon aur baheno ye channel me Dilip Jha ji Analytics padhate hai, fir bhi 70K hi subscribers kyun, jladi se jaldi 1lakh subscribers tak pahuchaiye is channel ko
Sir I am running my small business on self made excel program. I have a workbook of about 25 customers sheet and a sheet containing customer directory where I have hyperlink their names with their respective sheets. It was my long desire that by some how I can fetch the last payment date from every customer sheet on the directory. Thank you very much you solved my problem by indirect and counta combination function. Now another issue raises, the indirect and counta combination fetch the last date cell it didn't distinguish either it is last billings date or last payment date. I want only the last payment date on my customer directory sheet can you please help me solve this problem?
Sir i want to sum net total of vendors coming many times in different rows, through sumif i am able to do but i need one vendors one total in last of vendors line , any suggestion....
Hello sir...can i make a career transition into data analyst after working in 13 years in operations and m only b.com graduate and m 34 years old...is it still possible?
Finally....Right time ..Amita,Age is not a barrier as you are not Fresher and also not pretend to be Data Analytics Fresher. Who knows that You are Fresher? Only one person that's YOU😊 A simple Bcom having greate communication skills and Good skills of Analytics tools.e.g. Power BI/Tableau is getting awesome 15Lac + Package. Start your journey Now ,I assure you won't regret for this decision as Data Analytics and Data Science is Great career option Now. Still issue and unable to prepare your self for career transition,Will guide you for the same,Conny us via whatsapp/call for career guidance.
Data ko table me convert kerne ke baad auto filter use nahi hota .jaise quick excess tool bar mein auto filter add kerte hai aur wo doosre no per hai aur main alt+2 enter kerta huun filter nahi hota. Normal data mein kerta huun to ho jata hai. Please bataye.
@@Innozant option mein setting mein jaker quick acccess tool mein adker liyA hai. Table converted data mein alt+2 press kiya to header per filter aa jata hai, lekin jaise hum paticular cell pe jker alt+2 presa kerne se cell wali item sare filter ho jni chahiye but header per filter aa jata hai, cell items filter nahi hote fir header pe jaoo drop down mein filter kerna padta hai. Normal data pe alt+2 press kerta huuun to cell wali item sab filter hoti hai. Table format mein nahi. Plz aap ik baar check kare aur solution bataye sir
Please files alg alg share krin jo aaap videos bana rhy hus hisab say file aaap k master files m match nhe krte please is ko set krin Har ek video k alg file link share krin
@@Innozant I have got a new job as mis officer because of you sir thank you so much Really I have no words for you sir Until you day by day release a new analytical skills tips which very helpful for all .. Jai guru dev
बहुत अच्छा लगा सर जी।
बहुत बढ़िया।
Thanks
Thanks for Trick #3. 🙏🙏👌👌👌👌👌👌
Very great sir
Nice sir apke video se ham sabko ek New motivation milta hai life me kuch New achieve karne ka thank you so much sir
Thanks..keep growing
Really appreciate sir ❣️aapne bhot kuch sikha diya
Thanks Lavi..God bless You dear❤️👍
Aage badhiye life me yhi wish
Respected sir
I m from Pakistan. Your way of teaching is mind blowing. I appreciate your way of teaching and pray for your success.
May God bless you ever.
Thanks
Thanks dear
Great.... You always rocks...
Good to see you back
Thanks dear
🙏 PRANAM SIR 🙏🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼
Very much helpful 😍🤘
Thanks dear
Effective Excel trick sir... ❤️🙏
Thanks Sunil.
Happy learning
I learn lot of things from you. Thanks
gr8 sir ji👌👌👍👍
Fantastic video sir 🙏🙏🙏🙏. Good night
Thanks Satish Ji .Good night..hope aap sahi hain aur acha kar rhe hain life me
Great learning
Thank you sir
Thanks
Sir. Very nice top 5 tricks of excel tutorial plz upload a tutoriel upon time calculation in ms excel .
I will thankful to you .Regards
Thank you sir
Fantastic Sir
God bless you
Sir very nice.
Thanks for sharing Jha sahab
Thanks dear
sir now, your subscribers are unhidden.
i can't believe. apke bs 69k approx subscribers hai. jabki ap to hum sbke liye kitni jyada mehnt krte ho.
sir ap jesa teacher mene ajtk nhi dekha.
you are great sir.
i hope ki apke jld hi millions me subscribers ho ❤️
Thanks Deepak ji for your love ,support and concern.
Yes underrated ,but maine kbhi bhi views pane ke liye nhi padhane ke liye video banaya hai tabhi aap mere channel par ek bhi short videoa kabhi nhi dekhe honge..Keep learning..keep exploring ❤️👍
Thank you once again sir for sharing all effectives tricks
Very useful information sir 👍👍
Sir trick apki no 1 h
Thanks Hemant Ji
Informative video sir 🤓
Thanks Nirupma..Keep Learning ❤️..Keep Exploring
Thanq sir apki wjah se main ajj ek ashi job par hu bus id change hai meri Gaurav bhatia
Kya haal Bhatia ji..aap to gayab ho gye the kuch time se ..God bless you dear
Amazing tricks as always.... 😀
You work really hard to make such career oriented videos sir, thankyou so much sir.😊
Thanks Bhawna for your valuable appreciation dear..Keep learning..Keep exploring ❤️👍
You are amazing sir.❤️🙏
Sir
Thank you for the tricks.
In case of summing k values more then 3, then I make some changes to the formula you explained.
SUM(IFERROR(LARGE(IF((range as explained in the video = value to lookup), range of values to sum), ROW(INDIRECT("1:30"))),0))
Good to see u
bhaiyon aur baheno ye channel me Dilip Jha ji Analytics padhate hai, fir bhi 70K hi subscribers kyun, jladi se jaldi 1lakh subscribers tak pahuchaiye is channel ko
Yahi to trashadi hai Nishant Ji😊
Thanks apke love aur support ke liiye.❤️
@@Innozant Jha Ji, Hum Mithilanchal chi, aaha ke 1Lakh Subcribers takk pahuchawe me bhar sakk koshish karab..
Hii sir😃🔥
Sir power bi ka playlist pura bnayiye
Please, please
Is there any video regarding Store inventory management?? Opening stock, issuance, closing, balance management through Pivot data entry??
Sir I am running my small business on self made excel program. I have a workbook of about 25 customers sheet and a sheet containing customer directory where I have hyperlink their names with their respective sheets. It was my long desire that by some how I can fetch the last payment date from every customer sheet on the directory. Thank you very much you solved my problem by indirect and counta combination function. Now another issue raises, the indirect and counta combination fetch the last date cell it didn't distinguish either it is last billings date or last payment date. I want only the last payment date on my customer directory sheet can you please help me solve this problem?
Sir large or table tricks best for work
Sir i want to sum net total of vendors coming many times in different rows, through sumif i am able to do but i need one vendors one total in last of vendors line , any suggestion....
I'm first viewer
Thanks Mohit♥️👍
@@Innozant welcome sir ji ❤️
Hi sir,
Date format became default format.
How can i set it as number format as default ????
nyc
Sir Please Share the File
Respected sir, we are waiting for excel vba contin....
👍❤️
Just amg waiting for vba
Hello sir...can i make a career transition into data analyst after working in 13 years in operations and m only b.com graduate and m 34 years old...is it still possible?
Finally....Right time ..Amita,Age is not a barrier as you are not Fresher and also not pretend to be Data Analytics Fresher.
Who knows that You are Fresher?
Only one person that's YOU😊
A simple Bcom having greate communication skills and Good skills of Analytics tools.e.g. Power BI/Tableau is getting awesome 15Lac + Package.
Start your journey Now ,I assure you won't regret for this decision as Data Analytics and Data Science is Great career option Now.
Still issue and unable to prepare your self for career transition,Will guide you for the same,Conny us via whatsapp/call for career guidance.
Data ko table me convert kerne ke baad auto filter use nahi hota .jaise quick excess tool bar mein auto filter add kerte hai aur wo doosre no per hai aur main alt+2 enter kerta huun filter nahi hota. Normal data mein kerta huun to ho jata hai. Please bataye.
Range ko table me convert karte hi autofilter khud apply hoga.
Yadi nhi ho Raha hai means options -settimg se disable ho rakha hai.check it
@@Innozant option mein setting mein jaker quick acccess tool mein adker liyA hai. Table converted data mein alt+2 press kiya to header per filter aa jata hai, lekin jaise hum paticular cell pe jker alt+2 presa kerne se cell wali item sare filter ho jni chahiye but header per filter aa jata hai, cell items filter nahi hote fir header pe jaoo drop down mein filter kerna padta hai. Normal data pe alt+2 press kerta huuun to cell wali item sab filter hoti hai. Table format mein nahi. Plz aap ik baar check kare aur solution bataye sir
Please files alg alg share krin jo aaap videos bana rhy hus hisab say file aaap k master files m match nhe krte please is ko set krin
Har ek video k alg file link share krin
Haan direct link broken ho gya hai use theek karna hai free time nikalke
@@Innozant theek hai sir waiting for your response
First comment
Thanks dear
@@Innozant I have got a new job as mis officer because of you sir thank you so much
Really I have no words for you sir
Until you day by day release a new analytical skills tips which very helpful for all ..
Jai guru dev
Taakay hamay koi preshan na ker sakay.