Learn new excel tricks from Microsoft Excel expert💻✨

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 KZbin 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

[@mitulp.mandalia6123]

Excellent teaching. Thank you Sir. 🙏

[@rahul_aloriya4026]

Excellent teaching Sir Thank You So Much Sir 🙏

[@mehrankhan9219]

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

[@yogeshchauhan7594]

Sir excel ka sath ka sath combination kon ka kra

[@ManishaKumari-x6q3f]

Thank you

[@yogendrasaw7089]

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

[@ShitalWanjari-tc1yj]

Nice🎉

[@ABHISHEKKUMAR-wt1pw]

Sir mai aapka course buy karna ka think kar rah hu kya yeh update aapke course mai available hai

[@Learn_More_Pro]

Hanji ye naye formulas bhi update kiye hai humne

[@rajasthanwalaa]

Bhai kr liya kya course purchase

[@ABHISHEKKUMAR-wt1pw]

@@rajasthanwalaa Nahi kyu?

[@akshayakumarmahaling1195]

🙏🙏🙏🙏

[@gaikwadsharad027]

Very nice teaching sir

[@zaharabegum1699]

Thanks sir

[@priyasoni550]

Amezing ❤❤ thank you to updated us

[@BinarykingDSP]

Very useful class sir ❤❤❤❤❤❤

[@subashyadav8190]

Master class

[@Learn_More_Pro]

Kindly fill the form given in the description

[@AmnaIkram-mt4ey]

Account different head and sum pr video bnao

[@Learn_More_Pro]

Will do that

[@journalistfahadiqbaljam]

Great

[@sunilmavli464]

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]

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

[@TheDisgacedOne]

Nice

[@ganeshkishorsonwani_1432]

Lekin ye to table me convert karne de # SPILL! Error aa raha hai

[@sandiphalder2420]

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...

[@rlalparmar]

Sir AAP jaisa fast nahi hai

[@sanjiv_EfE]

hm kisi row ko chhokar likhte hain to serial number us row me nhi aata hai or pichhli row hi add hota hai. aisi stithi me kya karen?

[@SunilSoni-hi7jp]

Make video for date of birth in words and words to number

[@bharatrasve3566]

I'm advance in Excel still jobless

[@ShibaprasadNayak-uh8fe]

Oh my God 😢

[@SKumarOfficial_]

e trick bahut purana ho chuka hai. Shayad aap log ab Jaan pa rahe hain.😂

[@gulamrasul]

First cmment 🎉

[@magicofoldsong]

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

[@mdmohsin6477]

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

[@dhattiwalamo.parvez]

Zakkas❤🎉

[@HifzaShakeel]

Mera to 2019 vala version h phir bhi nhi ho rha h

[@A_to_ZWorld28]

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

[@arunkumarsinghark3024]

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

[@ravindramaithil9917]

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

[@ZP_GAMING_1M]

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

[@Learn_More_Pro]

Ji jarur aap [e-mail] pe aapki query raise kijiyega ji

[@rajasthanwalaa]

Course kesa hi bhai 99 wala

[@ZP_GAMING_1M]

​@@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

[@mixx.gameryx]

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

[@bycswala]

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 KZbin 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 KZbin 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

[@Saksham9119]

Sir power query ki videos app se kyu hta di😢

[@manojahirwar3407]

सर हम excel में हम किसी नम्बर के कुछ डिजिट रिपीट करने होवतो कैसे करेंगे क्योंकि entry करते समय starting kuch नंबर same रहते है

[@sam6524]

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

[@subhashmorvekar2707]

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

[@pratapkeshavpawar9689]

🕉️🇮🇳☪️✝️☦️Res Excel Experts Master🙏 Mine PC is Windows -7 please 🙏 guide. पी के पंवार 🙏

[@pankajkamble8216]

Sir. I have got error in using =if(B2="","",aggregate(3,5,$B$2:B2)) formula like #Name?. Please help on the same.

[@সমস্তধরনেরভিডিও-দ১ট]

Otto count sl no Formula A2 call put Formula =If(B2="","",ROWS($B$2:B2)) Enter. Otto sl no

[@RAAWANA]

Sequence+ CountA purana formula h sir...or M10 Mint kaise le liye maap dono ne usko samjhane me

[@abdulfarooq9960]

Good afternoon 😂 Sir. Window 7 PAR YE FORMULA KAM NAHI KAR RAHA HAI

[@brahulraj]

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

[@sintubarman8246]

1 question ❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓❓ Agar sirial number 1 se start nhi karna hai 1001 se start karna hai

[@narinderchouhan1713]

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

[@kalpanasharma569]

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

[@helpinghand5437]

Sir, is there any formula to mark a cell yellow in Google sheet where the date is 2 month before or after current date

[@dishanksahu7459]

Waah mja aa gya 🎉❤

[@gopalprajapatgopalprajapat9785]

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👍

[@skmanagementserv]

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

[@subashyadav8190]

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

[@amerendrakumarranjan336]

Lekin excel 2007 me kaise hoga ?

[@tauha_azmat]

If three words randomly appears in s particular cells. So how can we count these words appeared

[@abrarali-um4zq]

👍👍👍😊

[@SarangManzoor]

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

[@dhanjitcreator135]

Like me ❤

[@ZP_GAMING_1M]

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

[@kishorpanara4191]

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

[@Abdul_Qadoos_Wazir]

I'm interested in becoming an expert data analyst and then move to Dubai

[@ravichandra5763]

Clear

[@awineshtripathitripathi7016]

Super

[@coolag74]

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.

[@gaikwadsharad027]

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

[@satyabratapani6078]

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

[@mariantonys]

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

[@Learn_More_Pro]

Correct ji

[@Official_Suraz]

2019 MAIN SEQUENCE FORMULA KLAISE LAYA ?

[@Abdul_Qadoos_Wazir]

How can we attend your classes from Pakistan

[@global_short]

Clear sir thanku so much 😊❤

[@subashyadav8190]

Very nice

[@SanviPatil2019]

Superb video

[@sailoovarala8432]

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

[@Learn_More_Pro]

Sure kindly contact [e-mail]

[@milindpan123]

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

[@Rainbow0172]

WPS me kr skte ho jinke pas 365 nhi hai

[@amritmalviya1786]

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.

[@Abhi-le2zi]

I think mobile number will be the unique field simply sort the data by mobile no.

[@KishlayKantiMandal]

What if there is a blank cell between name ? 7:02

[@manjunathsandur1]

Excellent Teaching...Asif Sir your Genius...The way of Teaching is Simple and Very Effective....Thank you

[@KishlayKantiMandal]

What if there is a blank cell between name ?

[@harmeetsinghvirdi462]

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

[@Learn_More_Pro]

Thank you so much!!

[@Stock_ways______]

Nice❤

[@s.k.sharma2558]

Sir Excel se tally me entry kaise kare

[@nageshanandache260]

raw ke bichme ek ek raw chood di to

[@SANDEEPCREATED]

Vrey Good

[@faizujutt4942]

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

[@Learn_More_Pro]

Video link : kzbin.info/www/bejne/b4LMiGqgmst4o9U

[@Vishalbabu903]

Nice ❤❤❤

[@yaarji7qqstatus252]

Sir m apki sari video deaktha hu

[@nileshchakrabarty9605]

Clear Sir, Very Nice

[@saokhilalkachhi3842]

Sir office 2021 mein bhi available nhi h aggregate formula.

[@amerendrakumarranjan336]

Clear

[@Amitgupta-qn8ql]

Change your teaching partner

[@abushadkhan1697]

Wps not working this trick

[@umeshray3463]

I am full satisfied

[@zakirhussain8931]

Sir u r great teacher of excell.

[@KhadyotDarshan]

labour's Teacher or Slave's Teacher

[@imranalam5639]

Besic exsell sikna hai

[@balrajmuddula]

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

[@rknareda5]

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

[@umeshkumawat3112]

Koinsa verjan h in excel me

[@gaikwadsharad027]

Sir guide me how.