99% people don't know how to build logic in Excel Formula?

Edit, convert and combine PDF files with PDF Agile ➤ bit.ly/3PhEm7D
[Giveaway] one-month #PDFAgile Pro Plan redeem code ➤ U4bWT98pe2
Convert PDF to Word online for free ➤ bit.ly/3AAS55l
Free PDF templates for business, education and all industries: ➤ bit.ly/3RjvMXO
With PDF Agile, you can edit traditional and image PDFs, combine, split, and compress your PDF. Also, convert PDF to Word, Excel, PPT, images, and even turn your PDF into a DWG file.
99% people don't know how to build logic in Excel Formula?
To Dosto, Ye #MSExcel ka formula aapko sir kujane ke liye majboor karega kyuki iske liye maine multipal formulas ka use kiya hai. aur usiko simple tarikese is video mai samzhaya hai jisase ki aapko sir khujane ki naubat na aaye. usike saath maine practice file bhi diyi hai. To jarror is video ko pura dekhiye aur comment section mai jarror batayiye ki ye video aapko kaisa laga.
To Download practice file join our telegram group: t.me/learnmoreindia
101 Excel Shortcuts that will help to increase your Excel speed : • 101 Excel Shortcuts th...
Why we use $ Sign in Excel Formula Explained! :- • Why we use $ Sign in E...
------------------------------------------------------------------------------------------------------------------------------
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/
------------------------------------------------------------------------------------------------------------------------------
Telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
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
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZread 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

Пікірлер: 121

  • @Learn_More_Pro
    @Learn_More_Pro2 жыл бұрын

    Edit, convert and combine PDF files with PDF Agile ➤ bit.ly/3PhEm7D [Giveaway] one-month #PDFAgile Pro Plan redeem code ➤ U4bWT98pe2 Convert PDF to Word online for free ➤ bit.ly/3AAS55l Free PDF templates for business, education and all industries: ➤ bit.ly/3RjvMXO With PDF Agile, you can edit traditional and image PDFs, combine, split, and compress your PDF. Also, convert PDF to Word, Excel, PPT, images, and even turn your PDF into a DWG file.

  • @LPtechnical

    @LPtechnical

    2 жыл бұрын

    Sir ji 1click me sallery sabhi employees ke account me paisa kaise transfer karen

  • @visible_all_time.

    @visible_all_time.

    Жыл бұрын

    Q

  • @prabhakarpawar573
    @prabhakarpawar5732 жыл бұрын

    Very usefull sirji

  • @smpy5859
    @smpy58592 жыл бұрын

    Sir I have done your courses Power Query & Excel MIS through mybigguide. I loved the way you teach, you make the environment very light by a little bit jokes, that is the reason we learn with excitement. I am not able to review on your website, therefore I am reviewing your course here and I want give 5 stars to your course. Thank You 🙏

  • @TheHemantVlog99
    @TheHemantVlog992 жыл бұрын

    You are the best teacher ☺️😉☺️😉😉 #Learnmore

  • @TheCreatorKaran.K
    @TheCreatorKaran.K2 жыл бұрын

    sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏

  • @nazarhussainmiriwala3391
    @nazarhussainmiriwala33912 жыл бұрын

    Thanks Jazakallah

  • @bhole770
    @bhole7702 жыл бұрын

    I've solved this problem few months ago sir Thanks for such knowledgeable videos.

  • @Rohitkumar-wk2vo
    @Rohitkumar-wk2vo2 жыл бұрын

    Excellent video as expected from you 👌👌🙏🙏

  • @sujandas8165
    @sujandas81652 жыл бұрын

    U r awesome sir

  • @kumarkailash7297
    @kumarkailash72972 жыл бұрын

    Sir your teaching style is very nice.

  • @computertechnologyandjobin3501
    @computertechnologyandjobin35012 жыл бұрын

    Thanks sir ji

  • @mostafaahmed09994
    @mostafaahmed099942 жыл бұрын

    Sir You Are Super Great 😚👍

  • @muhammadhassantahir103
    @muhammadhassantahir1032 жыл бұрын

    Thanks sir

  • @darshitchavda8264
    @darshitchavda82642 жыл бұрын

    GREATE SIRJE...

  • @moreknowledge7476
    @moreknowledge74762 жыл бұрын

    Very useful video sir! You are the best teacher and my favorite teacher 👍

  • @miss_anchal_07

    @miss_anchal_07

    2 жыл бұрын

    kzread.infodreNeL1PxDA?feature=share

  • @KATTARHINDU0208
    @KATTARHINDU02082 жыл бұрын

    Solve kr diya sir maine😌🙏🏻❤️

  • @shai3939
    @shai39392 жыл бұрын

    I WATCH EVERY VIDEO I LIKE IT LOVE YOU SIR ❤❤❤

  • @ManjeetKumar-ye9sg
    @ManjeetKumar-ye9sg Жыл бұрын

    Sir ye to bilkul easy hain first wala

  • @tarunpal6293
    @tarunpal62932 жыл бұрын

    To good sir I love you sir 😘

  • @moreknowledge7476
    @moreknowledge74762 жыл бұрын

    Sry for ask question ? Sir KZread guide course me ek id se 2 channel kaise banaen is pr video banaoo sir pls 🙏🙏🙏

  • @viralsupport8719
    @viralsupport87192 жыл бұрын

    Good 👍

  • @raviyadav9
    @raviyadav92 жыл бұрын

    Gjb 🔥

  • @magicofoldsong
    @magicofoldsong2 жыл бұрын

    SIR blog ka Ek Series Banaye PLZ SIR

  • @Fitness_warrior_05
    @Fitness_warrior_052 жыл бұрын

    Nice sir

  • @sanjeetsharma2700
    @sanjeetsharma27002 жыл бұрын

    Sir data tab functions par video banaiye

  • @santoshbehera8666
    @santoshbehera86662 жыл бұрын

    Supper Sir

  • @ebadbaloch8304
    @ebadbaloch83042 жыл бұрын

    NICE VIDEO

  • @rohitj.ladani
    @rohitj.ladani2 жыл бұрын

    Awesome

  • @arunkumarsinghark3024
    @arunkumarsinghark30242 жыл бұрын

    🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

  • @irfanshaikh5577
    @irfanshaikh5577 Жыл бұрын

    Please make a video on Cohorts creations and analysis

  • @prasadtakarwankar7463
    @prasadtakarwankar74632 жыл бұрын

    Excellent Teaching style.. I always wanted to be with your teaching.. Need to request you that if possible please stop this advertising between video. It's create lot of distraction while watching...

  • @amarikhe3931
    @amarikhe3931 Жыл бұрын

    I want to know the configuration of laptops for video editing. Please upload a video for the same. 🙏🏻🙏🏻

  • @pinkiharshitphatak2934
    @pinkiharshitphatak29342 жыл бұрын

    Supv video sir

  • @ebadbaloch8304
    @ebadbaloch83042 жыл бұрын

    SIR YOUR GRAET TEACHER

  • @Altaf_Alam
    @Altaf_Alam2 жыл бұрын

    Sir solve Kar liye hum sumproduct formula se 😃.............=SUMPRODUCT(--(TEXT(a2:a10,"MMMM")=E3)*B2:B10) THANKS🙏❤️.....ab video dekhte hai😊

  • @munishsawant3933

    @munishsawant3933

    2 жыл бұрын

    Sumproduct give the answer also without adding -- this sign before text formula

  • @Altaf_Alam

    @Altaf_Alam

    2 жыл бұрын

    @@munishsawant3933 hmm

  • @SHEERAZ-ALI
    @SHEERAZ-ALI2 жыл бұрын

    This is my logic very simple =SUMPRODUCT(--(TEXT($A$2:$A$10,"MMMM")=E3),$B$2:$B$10)

  • @bilalbhuri7000
    @bilalbhuri7000 Жыл бұрын

    Covert dates to text in mmm format and then apply sumif.

  • @shahzadahmad2406
    @shahzadahmad2406 Жыл бұрын

    Sir please made a vadio on spss complete cource

  • @bijaychhetri518
    @bijaychhetri5182 жыл бұрын

    What are the softwares that we need for normal use in our Laptop?

  • @hiratravels5326
    @hiratravels53262 жыл бұрын

    SATISH SIR YOU ARE BRILLIANTTTTTTTTTTTTTTTTTTTTTTTT HATS OFF TO YOU..............................🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🎍

  • @tilottamakalo6241
    @tilottamakalo62412 жыл бұрын

    Sir mujhe basic salary sheet kese banate bataiye please

  • @surajthakuri913
    @surajthakuri9132 жыл бұрын

    Ms access ka video banao na sir ji

  • @indian2896
    @indian28962 жыл бұрын

    Thank you so much sir 🖥️⌨️🖱️

  • @indian2896

    @indian2896

    2 жыл бұрын

    ❤️❤️❤️❤️

  • @rahulrathod2237
    @rahulrathod22372 жыл бұрын

    Course join Kara hai sir

  • @addictedsikku7062
    @addictedsikku70622 жыл бұрын

    Sir Tableau k upar v video upload kijye na

  • @sujoyghosh1197
    @sujoyghosh1197 Жыл бұрын

    Please make a video on SQL used in Ms excel. It's urgent

  • @SHEERAZ-ALI
    @SHEERAZ-ALI2 жыл бұрын

    Sir simple hy use sumproduct

  • @yakubdange5274
    @yakubdange5274 Жыл бұрын

    Sir Muze MIS Executive ke liye konsa Course karna Hoga....

  • @nitin7911
    @nitin79112 жыл бұрын

    Sir ji Aapka institute kha hai

  • @ShubhamSharma-rb1dj
    @ShubhamSharma-rb1dj2 жыл бұрын

    Add helper column and use sum if ..

  • @mudassiranaf
    @mudassiranaf2 жыл бұрын

    Unable to Download the Sample file .. Share it in Google Drive pls

  • @miss_anchal_07

    @miss_anchal_07

    2 жыл бұрын

    kzread.infodreNeL1PxDA?feature=share

  • @santoshbehera8666
    @santoshbehera86662 жыл бұрын

    (Now) formula me kuchh neya chahiye sir

  • @ashishsharma1281
    @ashishsharma12812 жыл бұрын

    Sir sap fmcg depot c&f billing ka full course ka video banaiye

  • @anuragshakya1223
    @anuragshakya12232 жыл бұрын

    3 saal ago ye question solve kr diya tha

  • @prakashcellcity
    @prakashcellcity2 жыл бұрын

    Satish bhai pls app vlookup ko kaise 2 files mae Karna had iska ek video banaeye jitna jaldi ho sake

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    kzread.info/dash/bejne/eqSqq9OtiM7MqcY.html

  • @UKJ28
    @UKJ28 Жыл бұрын

    Hello Sir, me tumcha channel subscribe kelela ahe. tumhhi konta software vaparta he sagle videos banvayla

  • @MDshami_77
    @MDshami_772 жыл бұрын

    Typing koi free software batayiye

  • @ashishshiriskar123
    @ashishshiriskar1232 жыл бұрын

    Superb sir as usual you're are Excel Guru 😂

  • @RohitKumar-ot3py
    @RohitKumar-ot3py10 ай бұрын

    Which formulas is an array formula how to find that?

  • @saeedshaikh5276
    @saeedshaikh5276 Жыл бұрын

    👍👍👍👍

  • @arpitagrawal8659
    @arpitagrawal86592 жыл бұрын

    Sir data entry operator job online Kahan par milegi kese karni hogi uske upar video bnaiye

  • @onlymz962
    @onlymz9622 жыл бұрын

    sir ms office ko instail karne ka koye sahi tarika btao

  • @dlboy4831
    @dlboy4831 Жыл бұрын

    Hello sir mai abhishek Frome Delhi se please aapse ek halp chahiye me ek transport commission agent hu to mujhe pura data manegement karne me problem hoti Mera sara data hand made paper works hai mujhe party name and old truck record surch karne me problem hoti hai please aap koi Excel me formate btayenge please 🙏🙏🙏🙏 sir please

  • @parthrajput4202
    @parthrajput42022 жыл бұрын

    Sir excel se online money earn kar sakte hai kya? Agar kar sakte hai to kaise? Plz bataiye

  • @msshort231
    @msshort2312 жыл бұрын

    Sir meri image computer par chrome par open ho rahi hai aur main chahata hu windows view par open ho parmanent kaise kare aur khuch chrome par attached hai unhe kaise hataye sir pls reply

  • @vishalbhati912
    @vishalbhati9122 жыл бұрын

    Insert Helper column =text(A2,"mmmm") then sumif

  • @canirmalchoudhary8173
    @canirmalchoudhary81732 жыл бұрын

    I think you could use this formula too without IF =SUMPRODUCT(value range,(TEXT(month range= month cell)*1))

  • @miss_anchal_07

    @miss_anchal_07

    2 жыл бұрын

    kzread.infodreNeL1PxDA?feature=share

  • @satbirkumar1986

    @satbirkumar1986

    Жыл бұрын

    Will you provide this formula with example because i am getting error in month cell section

  • @sudhirmehdipur
    @sudhirmehdipur2 жыл бұрын

    Excel mein algebra ka jod + , ghatav - , Guna x , bhaga / ,kaise karen Please bataye

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Matlab ?

  • @chandangupta1048
    @chandangupta1048 Жыл бұрын

    Accha sir aapne excel kitne dino me Sikh liya tha

  • @GreatCreatorBoy
    @GreatCreatorBoy2 жыл бұрын

    repairing disk errors. this might take over an hour to complete Sir Iska Solution Bataye Please Sir Ek Video 😭😭😭🙏🙏🙏

  • @milansamadder4655
    @milansamadder46552 жыл бұрын

    Sir I want to learn Excel and how to buy your course..

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Better to learn from Internet & KZread (Just a suggestion). There are multiple online Excel channel you can use as a reference. For any help, you can message me too

  • @sanjeetsharma2700
    @sanjeetsharma27002 жыл бұрын

    Please sir

  • @ganeshtiwari2550
    @ganeshtiwari25502 жыл бұрын

    how to learn ms office can u say sir any advice .....

  • @englishlearning1478

    @englishlearning1478

    2 жыл бұрын

    hi

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Better to learn from Internet & KZread (Just a suggestion). There are multiple online channel you can use as a reference. For any help related to Excel, you can message me too

  • @FauL_UppU
    @FauL_UppU2 жыл бұрын

    How to do after selecting any name drop list his/her details like number, age, marks should appear 🤔🤔

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Use Subtotal to sum number, age & marks. After using it, if you use filter, you will get the values

  • @raj95122
    @raj951222 жыл бұрын

    Sir Great,, इसी से related मेरा एक questions hai Ek employee ne 01/07/22 to 30/07/22 ke bich continue work ka 10000 Rs ka bill Diya hai For example uska account number 123456 hai अब यदि वो फिर से वही account (123456) नंबर में 01/07/22 to 30/07/22 के बीच date या 01/07/22 और 30/07/22 की कोई date का उस account me payment के लिए फिर से बिल दे तो उसे excel इस प्रकार की duplicate को किसे restrict kare जब data ज्यादा हो

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Saare parameters ko table format m bnake "Duplicate" function use kr skte h

  • @MDshami_77
    @MDshami_772 жыл бұрын

    Sir typing master free kaise download kare

  • @drgroway1268
    @drgroway12682 жыл бұрын

    solved:) firstly I use the formula (=month(date wala cell ) then drag aur apko milega ki sab date month number me convert ho gay hai then simply use sumif formula with it

  • @LPtechnical
    @LPtechnical2 жыл бұрын

    Sir ji 1click me sallery sabhi employees ke account me paisa kaise transfer karen

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Isme Bank se baat krni padegi, Excel sirf salary chart bna skta h, bank account m credit ni kr skta :)

  • @atulhinge7162
    @atulhinge71622 жыл бұрын

    Mera ek que h koi ans do plz ...jb excel me koi text paste krte h to wo ek format mein nhi ata to uske liye kya kre?? File+setting+advance settings+copypaste isme option nhi h 2010 ka excel hai

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    Depends kha se paste kr rhe o, paste krne k baad excel sheet m sara format select kr k same format m usko change kr skte o Koi doubt o to you can contact me. I'd happ to help

  • @gurujeetparihar
    @gurujeetparihar2 жыл бұрын

    SUM(FILTER(B1:B9,MONTH(A1:A9)=1)) Ye formula use kar skte hain B column me values A column me dates JANUARY k liye 1 FEBRUARY k liye 2 so on Use krke

  • @magbulmomin4432
    @magbulmomin44322 жыл бұрын

    muze apka course karana hai magr course videowise amount pay kar sakta hun mai retire man hun pension bahut kum hai to installment ke sath lena chahata hu magar certificate mailna jururi hai I am 70 yrs old

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    You can learn excel online for free. Bht sare channels h, aap wha se koi b channel k reference k through sikh skte h

  • @bongsinu2547
    @bongsinu25472 жыл бұрын

    Sir ... I could not found tally book ... Please help me .... 🥺🥺🥺....

  • @akcom0987
    @akcom09872 жыл бұрын

    ये क्या चीज़ का फार्मूला है सर

  • @rahul.offical800
    @rahul.offical8002 жыл бұрын

    Sr mujhe shikha h but computer nhi h 😥

  • @Learn_More_Pro
    @Learn_More_Pro Жыл бұрын

    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/

  • @mitjoshi8411
    @mitjoshi84112 жыл бұрын

    सर, आपसे 1 request है कि, 1 वीडियो loan amortization का भी बनाए जो आज के दौर में सबसे ज्यादा जरूरी है। आभार 🙏🙏

  • @tanmoysaha5804
    @tanmoysaha58042 жыл бұрын

    Sir why"MMMM"

  • @WorldHDPremiere87341
    @WorldHDPremiere873412 жыл бұрын

    I'm pretty sure I'm not gay, but tNice tutorials man with Nice tutorials damn handso voice is sure ly about to change that lmao

  • @RakeshKumar-nm4ku
    @RakeshKumar-nm4ku2 жыл бұрын

    Sir mujhe bhi youtuber banne ka shok hai par mere pass utne paise nahi hai main aapka course kharid saku please sir meri help kijiye sir mujhe reply zaroor kijiye please sir

  • @excelonlineadvisor

    @excelonlineadvisor

    2 жыл бұрын

    "youtuber banne ka shok hai" - KZread p content upload krne k liye koi paise ki jaruat nhi h, aap video free m upload kr skte h

  • @onlymz962
    @onlymz9622 жыл бұрын

    سر مجھے افس انسٹال کرنے کا کوئی صحیح طریقہ بتاؤ پلیز This is my big problem

  • @ashutoshsingh598
    @ashutoshsingh5982 жыл бұрын

    No sir

  • @swapnaliparkhe2826
    @swapnaliparkhe28262 жыл бұрын

    Zara dheere dheere sikhao....itne speed se kyu sikhaate ho

  • @gurujeetparihar
    @gurujeetparihar2 жыл бұрын

    =SUM(FILTER($B$2:$B$10,TEXT($A$2:$A$10,"MMMM")=E3) Use this formula It works properly. Reply Sir please

  • @munishsawant3933
    @munishsawant39332 жыл бұрын

    =SUMPRODUCT((TEXT(A2:A10, "MMMM")=E3)*B2:B10) I have done this way, got same result Without doing CTRL+SHIFT+ENTER

  • @satbirkumar1986

    @satbirkumar1986

    Жыл бұрын

    Will you provide this formula with example because i am getting 0 as a result

  • @munishsawant3933

    @munishsawant3933

    Жыл бұрын

    Sumproduct ((Text(cell range where dates are located like A2:A10, "mmmm")=cell ref of month name like E3) * cell range of sales amount like B2:B10) In this formula * this sign work as , (coma) so you must use * this as per I showed in formula.

  • @rakeshkumardey3219
    @rakeshkumardey3219 Жыл бұрын

    sir files telegram se nahi milte hai. kaise dhundo kaha dhundoo apka files

  • @bajrangsinghchandsingh3403
    @bajrangsinghchandsingh34032 жыл бұрын

    Window boot manager ko theek kaise karen

Келесі