Learn new excel tricks from Microsoft Excel expert💻✨
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- Learn new excel tricks from Microsoft Excel expert💻✨
Relative, Absolute and References : • Why we use $ Sign in E...
If formula in excel : • How to use IF formula ...
🚀 Elevate your Excel game with the latest tricks from a Microsoft Excel expert! 💼 Dive into advanced techniques, time-saving shortcuts, and insider tips to boost your spreadsheet skills. 📈 Subscribe now and become an Excel pro! 💻✨
#ExcelTips
#microsoftexcel
#productivityhacks
-----------------------------------------------------------------
Masterclass batch enquiry : skillcourse.in...
For Data analytics Live Masterclass enquiry Contact
: + 91- 8591597259 (Whatsapp us : "Masterclass Enquire")
-----------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_c...
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
For Short tips : / @skill-course
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more_pro
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My TH-cam Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Sir excel ka sath ka sath combination kon ka kra
Very nice sir. Well explained. I am from Pakistan. And what is the name of Asif sir channel
4 din pahle hi mere dimagh me ye saval Aya tha ki kash Aisa hota . Aur aaj mil gaya.
Thank you so much 🙏🙏🙏🙏
agar aapke paas 365 nahi h to automatically s. no. ke liye for use kro B5 me =IF(D5"",ROW()-4,"") aur heading dalo B4 me serial no.aur c4 me name aur b5 ko drag kr do door tak ab C coloum me entry krte jao aur automatically serial no. aayega mai ye for mula ms excel 2019 me use krta hu
Great
Make video for date of birth in words and words to number
🙏🙏🙏🙏
Sir Blender Software Ka Full Tutorial Banaye Learn More Channel Par PLZ Reply Kab Banayege namaste 🙏
First cmment 🎉
Lekin ye to table me convert karne de # SPILL! Error aa raha hai
Zakkas❤🎉
Mera to 2019 vala version h phir bhi nhi ho rha h
Sir =Row()-1 Searial Number ka Formula Hai
Sir office 7/10 v ho jeyega
If formula or Row Formula se
Sir mai aapka course buy karna ka think kar rah hu kya yeh update aapke course mai available hai
Hanji ye naye formulas bhi update kiye hai humne
Bhai kr liya kya course purchase
@@rajasthanwalaa Nahi kyu?
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
सर जी excel में उदाहरण 90.45.600 कैसे लिखें दशमलव संख्या कैसे बढ़ाये और टोटल भी डबल दशमलव मे आए कृपया कोई वीडियो मे समझाये
3 comment mera hai😅 bhut accha video 🎉🎉❤❤❤❤
Perfect explanation. Thanks Mr. Asif and Mr. Satish. From Kuwait
Sir power query ki videos app se kyu hta di😢
Nice🎉
Sir maine skill course me chatgpt in excel course me apply kiya tha but exam. Ke baad bhi certificate download nahi ho raha hai plees mere ko certificate dedo mera plees satish sir and aasif sir
I love ❤️ too all satish sir teams
Ji jarur aap info@satishdhawale.com pe aapki query raise kijiyega ji
Course kesa hi bhai 99 wala
@@rajasthanwalaa sabhi course achhe hai bhai pahele aap free course karke dekho pher aap ko pata chal jayenga
Best of luck 👍 bro
And thanks question puchne ke liye
Sir aggregate to lengthy we use short formula on there
=if(B2="","",row(1:1)) and drag formula please check my formula
Otto count sl no
Formula
A2 call put
Formula
=If(B2="","",ROWS($B$2:B2))
Enter.
Otto sl no
Sir.
I have got error in using =if(B2="","",aggregate(3,5,$B$2:B2)) formula like #Name?.
Please help on the same.
Pranaam Sir
Mera naam sourabh hai,
Mai abhi BCA ki padhai kar raha hu
Sir appse 1, help chahta hoon
Please mna mt kijiyega
Sir Actually, Mujhe BCA ki Sememster Fee submit karni hai
Isiliye Sir Mujhe Ek Job ki argent Jarurat hai , mai aapko youtube pr bahot time se dekh rha hu aur aapse bahot kuch sikha bhi hai
Mai aapke sath kuch kaam karke karke apni semester fee submit karna chahta hu
Please sir mujhe koi bhi kaam de dijiye mai TH-cam se related aur computer se related sare kaam kar sakta hoon
Please sir help kar dijiye
Mai poori mehnat aur imaandari se aapka kaam karunga
Papa ki Financial Condition acchi nhi hai, isiliye mai khud TH-cam pr 2 Channel run kar raha hu but abhi wo monetise nhi hain isiliye mai aapke sath kaam karna chahta hoon
Please sir kuch bhi kaam de dijiye
Salary bhi jyada mat dijiye
Aapko jo bhi sahi lage de dijiye, bus room ka rent bhar sakun itni de dijiye mai poori mehnat se aapka kaam on time kar dunga
Thank you sir thankyou so much ki ap ne itni pyari pyari or intrusting computer video ap ne hamare liye banai or hame computer ke software ke bare me sikhaya padhaya or itne pare or intrusting tatike se ap ne hame ms word ms excel powerpoint photoshop page maker coreldrow bahut ache tatike se hamako padhaya ot mene coching nahi balki apki video se ghar pr hi sab kuch sikha or apka padhane ka tarika ap samjhane ka tatika mujhe bahut pasand aaya thank you sir thankyou so much sir thank you thankyou thankyou sir👍
सर हम excel में हम किसी नम्बर के कुछ डिजिट रिपीट करने होवतो कैसे करेंगे क्योंकि entry करते समय starting kuch नंबर same रहते है
I use always it........
1 question ❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓
Agar sirial number 1 se start nhi karna hai 1001 se start karna hai
🕉️🇮🇳☪️✝️☦️Res Excel Experts Master🙏 Mine PC is Windows -7 please 🙏 guide.
पी के पंवार 🙏
Aasif sir jab muskurate hai to un ke gaal mere ko bahut achhe lagte hai
dua hai ke aasif sir aur satish sir aur jitne bhi aap ke team members hai un sab. Ko allah aaise hi muskurate rakhe
(آمین )
Good afternoon 😂
Sir. Window 7 PAR YE FORMULA KAM NAHI KAR RAHA HAI
Waah mja aa gya 🎉❤
If three words randomly appears in s particular cells. So how can we count these words appeared
Sir, is there any formula to mark a cell yellow in Google sheet where the date is 2 month before or after current date
Sequence+ CountA purana formula h sir...or M10 Mint kaise le liye maap dono ne usko samjhane me
I'm interested in becoming an expert data analyst and then move to Dubai
Very helpful video....Please bring such videos for different formulas in Excel in future.
Clear sir thanku so much 😊❤
What about the sequence formula if there are hidden rows, will the serial be affected or it would remain same
Sir aap webinar ka video TH-cam pe upload kyo nhi karte hy.
Please sir TH-cam pe upload kar dijiye jise kavi v dekh skte hy
Sir i am getting a spill error using the sequence formula with count a
Like me ❤
2019 MAIN SEQUENCE FORMULA KLAISE LAYA ?
Clear
Super
This can be achieved by this formula also:
=IF(B2="","",SUBTOTAL(3,$B$2:B2))
I have been using it for so many years. This formula serves two purposes:
1. If you delete data starting from B2, the serial number will also be deleted, and the subsequent cells will maintain the serial number sequence. For example, if we delete data from B3, the serial number in A3 will be deleted, and the serial number in A4 will start from 2.
2. If you filter your data, the serial numbers will follow the sequence based on the filtered data. For instance, if you have more data and Delhi is mentioned five times. When you filter your data by Delhi, the serial numbers will range from 1 to 5. This eliminates the need to correct the serial numbers after filtering.
Sir, i want to learn online courses like data entry, advance exel and advance tally.
Sir delete kiya 4 ya 5 no. Ok, but if add some data in between already rows. Sometime we add data according to date. But kuch time baad pata chalta hai ek date missing ho gai, tab hame upar ja kar date add karte hai, or pura column likhte hai, tab bhi kya ye sequence formula kaam karega
👍👍👍😊
Very nice
Sir agar main middle ka kohi cell blank rakhu or uske baad ka row main serial no. Blank cell se pehela cell ka serial no. ke baad continue Nehi aa Raha hai.. Bo blank cell ko v pakar ke aa raha hai.. plz give the solution...
How can we attend your classes from Pakistan
SIR MERE PASS AK EXCEL SHETBME JIS MERE STOCK ITEM KE KAME OR OR UNKI SIZE HAI TO MUJH YE CHAHIYE KI ME STOCK ITEM KE MANE KE STARTING KLKE2NWORD TYPE KARU OR VO STOCK KA ANAME PURA AA JAYE
Excellent Teaching...Asif Sir your Genius...The way of Teaching is Simple and Very Effective....Thank you
Sir koi aisa tarika hai hai jo kewal number ko ki count kare jaise A1 me 5kg 4 pkt ho aur B1 me 5t , 4l td hai to sabhi ko jodne par kewal number ko jode ya guna kare kaise kar sakte hain
Everyday some Jabardast dhamal type of contents given by U both Sir.. Really appreciate it 😇😇👍👍🙏🙏👌👌
Thank you so much!!
Excellent teaching. Thank you Sir. 🙏
Dear hum excel ke 2019 me sequence function kaise use kare pls
Master class
Kindly fill the form given in the description
bakwas video, sab purana trick he jispe uper already duniya bhar ke video youtube par he, isme ye batao naya kaya he, han naya ye he ki apne subcscriber ko naya tarike ke kese bevkuf banaya jaye
Superb video
Lekin excel 2007 me kaise hoga ?
Sir,
I want to learn power pivot Please design the course...
Video link : th-cam.com/video/9QiW7jefEms/w-d-xo.html
sahib
type 1 in A1
in A2 type this formula
=if(B2="","",A1+1)
pull it to whatever length you want
Correct ji
Change your teaching partner
Nice❤
What if there is a blank cell between name ? 7:02
Sir u r great teacher of excell.
labour's Teacher or Slave's Teacher
Clear Sir, Very Nice
What if there is a blank cell between name ?
Hello, can I get your contact number to discuss something in excel for automation?
e trick bahut purana ho chuka hai. Shayad aap log ab Jaan pa rahe hain.😂
WPS me kr skte ho jinke pas 365 nhi hai
Sir office 2021 mein bhi available nhi h aggregate formula.
Hi, can we contact directly and sit for training upon our work related required information can be provided?
Sure kindly contact info@satishdhawale.com
Nice ❤❤❤
Vrey Good
Those who don't have aggregate function in older version of excel can use if formula as
=if(B2="","",COUNTA($B$2:B2))
Mind-blowing formula🎉
Wow .... Acche se explain kiya sir aap dono ne 🎉
Hmm❤
Sir Excel se tally me entry kaise kare
raw ke bichme ek ek raw chood di to
Wps not working this trick
Bahut hi acchi jankari di sir, thanks
The new Excel trick is amazing. Thank you very much for giving such amazing information. (Asif Sir ❤👌)
Bahut accha Asif sir great ❤
सर फ़िल्टर फंक्शन के साथ काउंट फॉर्मूला यूज करना भी सिखाइये। with लॉजिक
Nice.
Thanks.
Shakeel Ahmad
Karachi, Pakistan.
Koinsa verjan h in excel me
Firstly I thought why its need but now it's amazing trick
Sir m apki sari video deaktha hu
Sir mere pass ek excel sheet hai jisme students ka data hai jisme student name, father name, mother name or mobile num hai. Isme bahut se siblings hai. Sibling ke father name, mother name or mobile num same hone. Ham un siblings ki ko kaise separate kar sakte hai ki ek ke niche dusre ka name aa jaye. Matlab ki sabhi siblings sath sath aaye.
I think mobile number will be the unique field simply sort the data by mobile no.
I think you should repeat the formula twice so we can understand better and get chance to write in our notebook
Got it explained very well. I am your customer of your pen drive course.
Sir AAP jaisa fast nahi hai
Well done Asif Sir
=if(B2="","",row(1:1))
I am full satisfied
Awesome Hai Sir.