Excel Goto Special | Selection tips to use Goto Special options in Hindi | Fill Blank Tricks
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- Learn how to use Excel goto special option step by step.How to Fill blank tricks and Ctrtl Enter
1. How to select comment , Constants and Formulas in excel
2. How to select blank and fill blank cell using ctrl enter
3. How to select current region , current array and objects in excel
4. Row differences , column differences , precedents and dependent in excel
5. How to select last cell,visible cells only , Conditional formats and Data Validation in excel using goto special
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#excelgotospecial #gotospecialinecel#Innozant #exceltipsandtricks #ctrlginexel
Your teaching has taken my Excel skills to next level. Thanks a lot.
Thanks Dear🙏❤️Happy Learning and thanks for supporting.👍🙏
the way you are adopted for teaching is so amazing. i salute you
Ache teacher ki student kadr nahi krte. Itna kam Subscribe
You are the best sir
Khan Sahab ..Logon ko entertainment chaiye hota hai kahan logic le apna dimag kharab karna..😄❤🙏Thanks fpr your love and kind support dear
One thing I noticed
Aap jo b topic lete ho usko briefly pdate ho
👌👌awesome videos
U tube pr kisi b topic ko briefly n pdate sabhi teachers👍
Keep it up sir, Thanks sir, good way of teaching 🙏😊😊
Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️
Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️
Sir your explanation is very nice and smooth and easy to understand subscribed
Thanks
बढ़िया वर्क साहेब आभार
Thanks Atul Ji❤️🙏
I plan to watch all your videos
Thanks .. Start your Learning journey from playlist Basic excel onwards step by step
Good Show
Sir That's a super trick!.. I learnt something new today. You are a very good instructor; very passionate. Made my life easier.
Thanks Sandeep for this wonderful feedback..M happy for you.Dedicated learner you are.👍🙏❤️
Good Morning Sirji, Ek saath go to special maine pahele baar sikhi.. thanks
Thanks dear
INNOZANT तो ग्रेट हैं जी
Deepak Sir की भेंट हैं जी
Excel भरोसे मेरा पेट हैं जी
Deepak Sir तो ग्रेट हैं जी
Thank you so much sir
Sir namaste nice video thankyou so much,sir Excel ke baad data science ka complete package upload kar dijiye please
Excel guruji thank you very much, apke video se mera Ek bht bara problem solve ho gaya, jese india to Canada wala
Thanks Sinha sahab..happy learning dear
Thank you sir ❤
Your teaching technic very easy to understand thank u.
Thanks dear ..God bless you
thanks a lot sir
this one i needed the most, thanks as always...!Respect
Sir u have Great knowledge of excel
Video is very useful
Thanks Anita ji❤️
Sir, knew how use of GOTO option but really add skill in this pop up
Thanks sir ji
Wish you all best
Thanks Subhash.. Recommend you to watch Videos step by step from playlist -Basic Excel to adv.🙏♥️
Very useful video
Thanks you sir for explain go to special so deeply.
Thanks Hemant 🙏❤️👍Happy Learning
Very interesting and useful Sir
Thanks 👍❤️
Your teaching style is very good. 💞💞
Thanks
Awesome explanation I realised improvement day by day in excel thanku very much sir good night 🙏🙏🙏
Thanks Satish Ji,Hope you like the Goto Special concept.GN🙏❤️👍
Hi Satish ji
When I asked it in coaching they said that forget it, nothing special.
😂😂😂
Kash ap mujhe pehle mil Jate
Ab lag raha hai me bhi MIS Interview crack kar paunga just because of you sir
Thanks a lot.
Don't worry Sanjay..Jo beet gyi so baat gayi..abhi Jo apke paas hai wo hai Aapka mehnat..krenge to jaroor succeed.Beat of luck.
thanks dear :-)
Salute sir
Thanks Paresh 😀🙏❤️
👌🏼
Thanks sir
Thanks dear
Excellent teaching sir
Thanks Ram🙏❤️
nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
🙏❤
teaching skills wow
super video sir jee..your voice is too sweet
Thanks Manjhar ..Happy learning
Super sir ji
Thanks Ghanshayam Ji
@@Innozant welcome sir ji
But really thanks to you for your support by you tube free video for learn👍
💐💐💐💐
Seekhte rahiye ,Humesha awesome content milta rhega aapko
Really hat's of u sir...
Thanks Bhoopendra
Hi Sir Goto special me reference kis trhn pass karty hn?
Sheet pr move hony ky liye
Every time getting to learn new things.
Thanks Samat🙏❤️
it helps but why you left constant option and directly go to formula options in go to specials. i have confusion with logical and error in constant.
Go to special did not select blanks after last text either we have to type a additional character at last
video is nice but pl update separate practice file link in description bcoz not able to find file in all folder drive
Link broken ho gya hai...We need to fix all video link..will update it soon
Divide multiply options please cover
Dear is there any formula that gives me laptop or cell registration number. By this formula any other device not use my excel file.
Wow
🙏❤️
THANK YOU SO MUCH SIR
Thanks Mohit Ji,Hope you like the Goto special selection option.🙏❤️
Nice
Thanks
Sir date , week, month,year se related question nhi aate i mean use krna nhi ki kaha pr kasse use kre....
Indirect function par video banayay
Aamir Sahab ye kehne ki jrurat hi nhi h apko🙂Choose finished ab indirect phir offset.Have patience 🙏❤️
❤️❤️❤️❤️❤️
Sir,
How we can do mail merge with personalised attachment. Pls help.
Hi sir facing issue on one excel problem could you please share of ID I will share the problem with you ....please provide the solution on it ....
Sir. Please launch a tutoriel on short keys of ms excel and also tell the when should be used the ctl and enter key and when use contl shift enter and when should b use only enter key also tell on which type of windows ur tutoriel of sum maharaj is work. I use window 8 it does not work for sum maharaj tutoriel tips. Regards.
Thanks Naeemul for your valuable opinion,
in case of standard function use Enter,When there is bulk array use ctrl+enter and if you want to execute single array function then ctrl+shift +enter..
no issue will make more videos of shortcut dear
👍👍👍👍
👍👍👍👍👍
Sir mai ek excel se copy kar ke dusre excel ke paste karta hu to blank past Hota hai please solve
My question is that we made a file.in this files we created some name and their value.now I want to insert blank line in the end of every line.how we can it?
Sir tally erp 9 par videos banay❤️
Tally main nhi padhata hu dear..
Data Analytics & Data Science mera field hai..
Haan kisi dusre trainer ke videos aayenge channel par
🙏🏻🙏🏻🙏🏻👌🏻👌🏻
Koi special word ko serch kr skte h kya kse #N/A
Sir एक सेल को छोड़ कर एक सेल में कॉपी कैसे करते है फिर खाली सेल में दूसरा डेटा की कॉपी कैसे करते हैं
We can also go with f5
Yes..very true
Visible cell ka bhi bahut use hota hai Filter karne pe.
Yes Kundan ji..❤❤
good after noon i tried to use go to but the special command is not visible how to show please help thanks in advance
Which version of excel you are using now
Your teaching is another level but I have a doubt that u r using if formula in this that is also a logical function but why don't show in logical ??? 🤔🤔🤔🙏🙏👌👌💯
Didnt get you mayanak..Offcourse uf function is under logical function category
@@Innozantthank you for your precious time ♥️💕💗
jb ham if use kr rahe the formula pe toh go to special usko logical Kyu nii Bata Raha hai vo if function formula ke andar usko text Bata Raha hai jbki usko logical batana chahiye
kyu batyega text if formula is logical..?
Kya aap online class karwate h
Yes..innozant websitw visit kriye
Operation of go to
Thanks Lokesh.Hope you like it🙏❤️
Tz
Plz sir jaldi batayega,,,,,,
Aap kya chahte hain krna ye btaiye.as answr to apne khud hi bta diya h dear
sir Excel ma all function KO Explain home intert all function🙏🙏
Thanks Karan 🙏❤️
Go to Option me jake, agar muze filter lagake only visible data ko paseSpecial karna h to kaise kare
Answer to apne khud hi bTa diya hai dear..visible cells only bus check kr lekn uske baad copy and paste
Nahi ho raha h
Please jaldi
Maine Vlookup mara h, jo values male h usko filter me jake check laga ke filter kiya aur usko find values ko paste special karna h, lekin nahi ho raha h
I am unable to find and download this file please share the path thanks
It is available under master assignment main link folder
@innozant sir please share the path so that I can download this file
@@bhavyadudeja5969 you may find it in basic excel folder -other option
@@Innozant Sir can you please name the folder name, this will help me in locating this fast
Thanks you so much I am able to locate the file thanks for your prompt response and support
F5 dabANE SE BHI JAYENGE
Ys
YOU DID NOT TELL ABOUT THE SAME OF DATA VALIDATION
Didn't get your query Bilal
Poori vedio धुंधली रही है शुरू से अंत तक
Vido dhundhli nhai hai Nisha..Aaj aapka internet bht slow chal ra hai
isliye dhundhli dikh rahi hai😀
Thank you so much sir
Thank you Sir
Thanks Anjali❤️