Learn new excel tricks from Microsoft Excel expert💻✨

Рет қаралды 91,039

3 ай бұрын

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/master-class/
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_course
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.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
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 KZfaq 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

Пікірлер: 189

@sunilmavli464 3 ай бұрын

4 din pahle hi mere dimagh me ye saval Aya tha ki kash Aisa hota . Aur aaj mil gaya. Thank you so much 🙏🙏🙏🙏

@as.ja93 3 ай бұрын

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

@mitulp.mandalia6123 3 ай бұрын

Excellent teaching. Thank you Sir. 🙏

@sam6524 3 ай бұрын

Perfect explanation. Thanks Mr. Asif and Mr. Satish. From Kuwait

@milindpan123 3 ай бұрын

Very helpful video....Please bring such videos for different formulas in Excel in future.

@dildars1 3 ай бұрын

Mind-blowing formula🎉

@tashitsering6586 3 ай бұрын

Really appreciate your teaching

@rahul_aloriya4026 3 ай бұрын

Excellent teaching Sir Thank You So Much Sir 🙏

@mytechnosupport269 3 ай бұрын

This formula also works in google sheets perfectly. Thank you sir !

@Immo7070 3 ай бұрын

The new Excel trick is amazing. Thank you very much for giving such amazing information. (Asif Sir ❤👌)

@vshddn 3 ай бұрын

Super video sir. Thanks so much.

@budheshwarkullu2301 3 ай бұрын

IT IS DONE SIR. I OPENED A NEW FILE AND IT WORKED. THANK YOU SIR. AWESOME VIDEO. SIR, AUR BHI PRACTICAL VIDEO DALTE RAHIYE.

@faizalshaikh3983 3 ай бұрын

Nice logic and clear details

@skk4511 3 ай бұрын

Got it explained very well. I am your customer of your pen drive course.

@zakirhussain8931 3 ай бұрын

Sir u r great teacher of excell.

@KhadyotDarshan 2 ай бұрын

labour's Teacher or Slave's Teacher

@priyasoni550 3 ай бұрын

Amezing ❤❤ thank you to updated us

@dinkarshinde3728 3 ай бұрын

Very nice information sir, Thanks 🙏

@jioindiaharkadamaapksath3699 2 ай бұрын

Bahut khoob aap logo ki efforts

@global_short 3 ай бұрын

Clear sir thanku so much 😊❤

@gopalprajapatgopalprajapat9785 3 ай бұрын

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👍

@shaileshsolanki7763 3 ай бұрын

Bahut hi acchi jankari di sir, thanks

@amanseth712 3 ай бұрын

Thank you sir...

@nileshchakrabarty9605 3 ай бұрын

Clear Sir, Very Nice

@Madman314 3 ай бұрын

Thanks satish sir , that question came in my mind & you just ask this after 10 second

@arunkumarsinghark3024 3 ай бұрын

एकदम clear 😊

@vickykadam10 3 ай бұрын

Bahut accha Asif sir great ❤

@Abdul_Qadoos_Wazir 3 ай бұрын

Interesting discussion between you two ❤

@chintamankadam3077 3 ай бұрын

Deepak sir is excellent in teaching excel

@harmeetsinghvirdi462 3 ай бұрын

Everyday some Jabardast dhamal type of contents given by U both Sir.. Really appreciate it 😇😇👍👍🙏🙏👌👌

@Learn_More_Pro 3 ай бұрын

Thank you so much!!

@minakshisingh4090 3 ай бұрын

Wow .... Acche se explain kiya sir aap dono ne 🎉

@englishbyroypranjal5282 3 ай бұрын

Hmm❤

@vineetcermalvisa7462 3 ай бұрын

Good. Hv to learn all fast and daily.

@mdsani743 3 ай бұрын

Thank you so much

@JayPrakash-hq4rw 3 ай бұрын

Awesome Hai Sir.

@dsp6111 3 ай бұрын

Very useful class sir ❤❤❤❤❤❤

@ciaraarmy9374 3 ай бұрын

Firstly I thought why its need but now it's amazing trick

@user-iv2lh7gk1l 29 күн бұрын

Thank you

@SapnaVishwakarma-hn3bm 3 ай бұрын

Well done Asif Sir

@SanviPatil2019 3 ай бұрын

Superb video

@saivarhadi5651 3 ай бұрын

Mr.Asfi sir, so charming ❤️

@sharadgaikwad4639 3 ай бұрын

Very nice teaching sir

@dhattiwalamo.parvez 3 ай бұрын

Zakkas❤🎉

@dhirajsinghthakur7886 3 ай бұрын

Helpful trick hai sir 😊

@DharmendraKumar-lf9bm 3 ай бұрын

Amazing trick sir

@jitendrabsrivastava 3 ай бұрын

Excellent.

@basavarajthorat1664 2 ай бұрын

Great!

@mehmoodurrehman9322 2 ай бұрын

Wonderful ❤

@dposhangla1393 3 ай бұрын

Appreciate you

@subashyadav8190 3 ай бұрын

Very nice

@zaharabegum1699 2 ай бұрын

Thanks sir

@balajeekpyare7527 3 ай бұрын

Super Sir

@gulshanali19 3 ай бұрын

Excellent

@BishnuPrasad85 2 ай бұрын

Very nice ❤

@dishanksahu7459 Ай бұрын

Waah mja aa gya 🎉❤

@yaarji7qqstatus252 3 ай бұрын

Clear sir

@user-wc3iz9fw5g 3 ай бұрын

Bahut badiya

@ShitalWanjari-tc1yj 3 ай бұрын

Nice🎉

@arunkumarsinghark3024 3 ай бұрын

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹 सीखते रहो, सिखाते रहो l हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

@ankitvyawhare7837 8 күн бұрын

Very nice sir

@SHAKEELAHMAD-kt9fs 3 ай бұрын

Nice. Thanks. Shakeel Ahmad Karachi, Pakistan.

@Vishalbabu903 3 ай бұрын

Nice ❤❤❤

@Stock_ways______ 3 ай бұрын

Nice❤

@SANDEEPCREATED 3 ай бұрын

Vrey Good

@ravichandra5763 3 ай бұрын

Clear

@journalistfahadiqbaljam 3 ай бұрын

Great

@coolag74 3 ай бұрын

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.

@awineshtripathitripathi7016 3 ай бұрын

Super

@ashokgaddam8996 3 ай бұрын

Nice,

@mustakshaikh3509 3 ай бұрын

great

@subhashmorvekar2707 Ай бұрын

Sir aggregate to lengthy we use short formula on there =if(B2="","",row(1:1)) and drag formula please check my formula

@saaragameryt2023 3 ай бұрын

NICE

@magicofoldsong 3 ай бұрын

Sir Blender Software Ka Full Tutorial Banaye Learn More Channel Par PLZ Reply Kab Banayege namaste 🙏

@minecraftvideo334 3 ай бұрын

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 (آمین )

@mehrankhan9219 3 ай бұрын

Very nice sir. Well explained. I am from Pakistan. And what is the name of Asif sir channel

@subashyadav8190 3 ай бұрын

Master class

@Learn_More_Pro 3 ай бұрын

Kindly fill the form given in the description

@akshayakumarmahaling1195 3 ай бұрын

🙏🙏🙏🙏

@yogeshchauhan7594 3 ай бұрын

Sir excel ka sath ka sath combination kon ka kra

@balrajmuddula 3 ай бұрын

Those who don't have aggregate function in older version of excel can use if formula as =if(B2="","",COUNTA($B$2:B2))

@SarangManzoor 2 ай бұрын

What about the sequence formula if there are hidden rows, will the serial be affected or it would remain same

@mixx.gameryx 3 ай бұрын

3 comment mera hai😅 bhut accha video 🎉🎉❤❤❤❤

@saokhilalkachhi3842 3 ай бұрын

Sir office 2021 mein bhi available nhi h aggregate formula.

@susenDeshmukh-zt7so 3 ай бұрын

Good

@my2kiliyas 3 ай бұрын

Aggrigate me agar cell delate karege to kya Sequence ki tarah react karega?

@rknareda5 3 ай бұрын

सर फ़िल्टर फंक्शन के साथ काउंट फॉर्मूला यूज करना भी सिखाइये। with लॉजिक

@gulamrasul 3 ай бұрын

First cmment 🎉

@AnujKumar-qu2ir 3 ай бұрын

Sir row hide krne ya filter use krne pr serial number sequence me rhega ya nhi

@A_to_ZWorld28 3 ай бұрын

Sir =Row()-1 Searial Number ka Formula Hai

@RakeshKumar-vc1no 2 ай бұрын

Fine

@abrarali-um4zq 3 ай бұрын

👍👍👍😊

@faizujutt4942 3 ай бұрын

Sir, I want to learn power pivot Please design the course...

@Learn_More_Pro 3 ай бұрын

Video link : kzfaq.info/get/bejne/b7eZipqbysypnac.html

@subashyadav8190 3 ай бұрын

I use always it........

@sharadgaikwad4639 3 ай бұрын

Sir, i want to learn online courses like data entry, advance exel and advance tally.

@mariantonys 3 ай бұрын

sahib type 1 in A1 in A2 type this formula =if(B2="","",A1+1) pull it to whatever length you want

@Learn_More_Pro 3 ай бұрын

Correct ji

@kishorpanara4191 3 ай бұрын

Dear hum excel ke 2019 me sequence function kaise use kare pls

@ravindramaithil9917 3 ай бұрын

सर जी excel में उदाहरण 90.45.600 कैसे लिखें दशमलव संख्या कैसे बढ़ाये और टोटल भी डबल दशमलव मे आए कृपया कोई वीडियो मे समझाये

@AmnaIkram-mt4ey 3 ай бұрын

Account different head and sum pr video bnao

@Learn_More_Pro 3 ай бұрын

Will do that

@s.k.sharma2558 3 ай бұрын

Sir Excel se tally me entry kaise kare

@brahulraj 3 ай бұрын

Sir aap webinar ka video KZfaq pe upload kyo nhi karte hy. Please sir KZfaq pe upload kar dijiye jise kavi v dekh skte hy

@satyabratapani6078 3 ай бұрын

Sir i am getting a spill error using the sequence formula with count a

@sailoovarala8432 3 ай бұрын

Hi, can we contact directly and sit for training upon our work related required information can be provided?

@Learn_More_Pro 3 ай бұрын

Sure kindly contact info@satishdhawale.com

@lovllienkaurr6993 3 ай бұрын

I think you should repeat the formula twice so we can understand better and get chance to write in our notebook

@mdmohsin6477 3 ай бұрын

Sir office 7/10 v ho jeyega If formula or Row Formula se