Sir, we are very excited for your video. I got a offers latter from OLIS INFOSYSTEM private limited as a role of MIS Executive. Without your video, I can't get this JOB. I will never forget,Your contribution. Thanks sir Thanks #innozant
गुरुजी Trick no.2 वली problem से कई बार गुजर चुका हु जब कोई एक्सल फाइल आँन लाइन डाउनलोड करो और उसमे फार्मूले लगाकर risult निकालने की कोशिश करो तो 90% यही समस्या आती है । धन्यवाद आपका आपने इसे कैसे ठिक करना है इसका रास्ता बताया 🙏🙏🙏
Sir really ASI type others options ki video we are more need plz create more videos about this settings sir plz WhatsApp pa reply ki nhi Dy ti hi plz others options explain text days next month's plz we are more needing this option
Sir ap online bhi classes lete ho advance excel ki sir apke apki videos dhek kar basic to advance excel pura complete ho jayega Or agar apse online complete excel padha ho to
Hello sir, I need your guidance. I have learnt excel and currently working as well. Now I want to grow but I am confused that what should I learn next. Either SQL or VBA ?? My coding aptitude is not good. So I wanted to ask that can I learn SQL and get a High salary job or it is mandatory to learn VBA ?
सर! मेरा प्रश्न गूगल शीट से संबंधित है। मेरे पास 4 उपयोगकर्ता हैं और सभी के पास काम करने के लिए अलग शीट है। और सभी 4 शीट का डेटा एक ही मास्टर शीट में सेव होना चाहिए। लेकिन कोई भी उपयोगकर्ता मास्टर शीट में डेटा संपादित न कर पाये.
8:02 sir but is trick se amounta me last wala cell to select nhi hua na. voto apne manually chalaki se video edit krke manually select kr liya. 😂 interviews me hum thodi video editor leke bethwnge jo is step ko edit krle 😂 apko ye bat bhi clear krni chahiye na ki last wala cell select nhi hoga isse.
Deepak Verma ji ek baar data select kren niche tak ..goto special me jayen aur blanke select krke alt = khud bhi press krke dekh lete ti itna lamba msg type hi nahi kara parta aapko..Verma ji jab range select krte hain to last selected scell highlighted dikhta nhi hai but wo already selected rehta hai..aur auto suk krne par subtotal polulate ho jata hai ye baat main ek nahi hajaar baar padha chuka hoon..tried and tested hai..Editor saath le jaane ki jarurat nahi hai..Yadi khudse practice kiye hote ti editor ki jarurat apko nahi parti...aur mujhe to waise bhi nhi krti hai jarurat😁 Ek baar phirse dekhne 8:02 alt equal to press krte hi output flash hua hai na ki editor ne kiya hai na hi maine manual..Bachon wale sawal nhi badon wale counter question krenge aur seekhenge usse to acha lgega mujhe
@@Innozant sir mene bhi ye kyi bar try kiya hai. but the main problem is whenever we try to select blank cells, ho humesha last wala blank cell nhi krta select. even if agr hum apke btaye hue trike se last wala cell ectra select krke chle. vo sirf tabhi select hota hai jb humne us last wali row ya us last cell wale amount ke niche ke kisi bhi cell me pehle kuch na kuch work kiya ho. for example border lgaya ho ya kuch type krke delete kr diya ho. orherwise vo goto special se nhi hota last wala cell select bhle hi hum extra cell select krke chle. i know bhut logo ko meri trh ye problem ayegi. but mene ye sirf ek version me nhi blki excel ke kyi versions me use kiya hai. atleast kuch na kuch work pehle se krna jrori hai last cell ke niche ke cells me. tabhi goto special wala option last blank cell selwct krne pr use select krega otherwise vo sirf beech ke hi blank cells ko select krega. bhle hi ap niche ke 10 15 blank cells extra select krke rkho. ❤️❤️❤️❤️❤️
Great 👍 sir it's very helpful for improving my skills in Excel.
Sir please make video about Dynamic Drop Down List with auto refresh.. like Country state block Na city...
Thank you sir very useful for us.
Very useful
Thank you so much
Sir, we are very excited for your video.
I got a offers latter from OLIS INFOSYSTEM private limited as a role of MIS Executive.
Without your video, I can't get this JOB.
I will never forget,Your contribution.
Thanks sir
Thanks #innozant
Congratulations Abhishek Ji..Have a wonderful career ahead ❤️👍
Bhot bhot mubarak ho
Awesome sir 🙏🙏🙏. Good night
Very helpful 👍🏼
Bahut Sundar sir jee 🙏
Sir,
Thank you for the tricks especially those mentioned in 2 & 3.
In case of trick 5, can I use pivot table to display subtotals as an alternative.
Very Great Sir
Thanks Sir, fruitful video as usually 🙏
Thanks dear
Amazing.... tricks... ❤️
Aa gaye hum bhi sikhne
Welcome
Welcome Shreya...Keep learning ❤️👍
Thanks sir...this video is very helpful 👍
Thanks Komal..Happy Learning ❤️
Amazing tricks
❤❤ thank you so soo much sir
Trick no. 5 awesome
Wonderful video
Thank you sir for showing keyboard shortcuts
Thanks dear
Thank you Guru ji
Thank you sir
गुरुजी Trick no.2 वली problem से कई बार गुजर चुका हु जब कोई एक्सल फाइल आँन लाइन डाउनलोड करो और उसमे फार्मूले लगाकर risult निकालने की कोशिश करो तो 90% यही समस्या आती है । धन्यवाद आपका आपने इसे कैसे ठिक करना है इसका रास्ता बताया 🙏🙏🙏
great, thanks and regard
Thanks Asif
Super sir
Thank-you
Mja aa gya boss
Ever and forever
Thanks sir
I like it🤓
Sir Aap Ke Sath Judne se Success To milega to Sure Mujhe Believe hai Aap pe
🙏🙏🙏
Thanks Manoj Ji..God bless You dear❤️
Nice sir
Sir really ASI type others options ki video we are more need plz create more videos about this settings sir plz WhatsApp pa reply ki nhi Dy ti hi plz others options explain text days next month's plz we are more needing this option
Sir vba pe video banao
Sir ap online bhi classes lete ho advance excel ki sir apke apki videos dhek kar basic to advance excel pura complete ho jayega
Or agar apse online complete excel padha ho to
Haan sahil humare batches chalte hain offline and online,For more information about new upcoming batches kindly visit Innozant website
Nyc sir
Hello sir, I need your guidance. I have learnt excel and currently working as well. Now I want to grow but I am confused that what should I learn next. Either SQL or VBA ?? My coding aptitude is not good. So I wanted to ask that can I learn SQL and get a High salary job or it is mandatory to learn VBA ?
You may proceed with SQL and Power BI .For more info you may connect with us.
Sir please kuchh aur bhi excel deshboard ki video banaiye
Ok..noted
Trick no 2 , mere khyal se sir " ctrl + ~ ". se bhi kam ho jayega. Pls confirm
Super trick sir kaam bhi or load bhi nahi
Sir please POWER BI per bhi video bnaye. Yeh bhi sikhna h
❤️👍
@@Innozant thanks please create
Sir ap be setting ki hn option mein SA is ja kr is ki ban kre GA
सर! मेरा प्रश्न गूगल शीट से संबंधित है।
मेरे पास 4 उपयोगकर्ता हैं और सभी के पास काम करने के लिए अलग शीट है। और सभी 4 शीट का डेटा एक ही मास्टर शीट में सेव होना चाहिए। लेकिन कोई भी उपयोगकर्ता मास्टर शीट में डेटा संपादित न कर पाये.
8:02
sir but is trick se amounta me last wala cell to select nhi hua na.
voto apne manually chalaki se video edit krke manually select kr liya. 😂
interviews me hum thodi video editor leke bethwnge jo is step ko edit krle 😂
apko ye bat bhi clear krni chahiye na ki last wala cell select nhi hoga isse.
Deepak Verma ji ek baar data select kren niche tak ..goto special me jayen aur blanke select krke alt = khud bhi press krke dekh lete ti itna lamba msg type hi nahi kara parta aapko..Verma ji jab range select krte hain to last selected scell highlighted dikhta nhi hai but wo already selected rehta hai..aur auto suk krne par subtotal polulate ho jata hai ye baat main ek nahi hajaar baar padha chuka hoon..tried and tested hai..Editor saath le jaane ki jarurat nahi hai..Yadi khudse practice kiye hote ti editor ki jarurat apko nahi parti...aur mujhe to waise bhi nhi krti hai jarurat😁
Ek baar phirse dekhne 8:02 alt equal to press krte hi output flash hua hai na ki editor ne kiya hai na hi maine manual..Bachon wale sawal nhi badon wale counter question krenge aur seekhenge usse to acha lgega mujhe
@@Innozant
sir mene bhi ye kyi bar try kiya hai.
but the main problem is whenever we try to select blank cells, ho humesha last wala blank cell nhi krta select. even if agr hum apke btaye hue trike se last wala cell ectra select krke chle.
vo sirf tabhi select hota hai jb humne us last wali row ya us last cell wale amount ke niche ke kisi bhi cell me pehle kuch na kuch work kiya ho.
for example border lgaya ho ya kuch type krke delete kr diya ho.
orherwise vo goto special se nhi hota last wala cell select bhle hi hum extra cell select krke chle.
i know bhut logo ko meri trh ye problem ayegi.
but mene ye sirf ek version me nhi blki excel ke kyi versions me use kiya hai.
atleast kuch na kuch work pehle se krna jrori hai last cell ke niche ke cells me.
tabhi goto special wala option last blank cell selwct krne pr use select krega otherwise vo sirf beech ke hi blank cells ko select krega. bhle hi ap niche ke 10 15 blank cells extra select krke rkho.
❤️❤️❤️❤️❤️
Sir MIS me to salary hi nahi hai kya kare?
Ye kisne kaha ...Vary krta hai organization that organisation