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

  Рет қаралды 66,372

Learn More

Learn More

Күн бұрын

Пікірлер: 122
@Learn_More_Pro
@Learn_More_Pro 2 жыл бұрын
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. 2 жыл бұрын
Q
@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/
@AbdulRahman-yp6oy
@AbdulRahman-yp6oy 4 ай бұрын
Waqai logic to outstanding lagaya ha excellent
@smpy5859
@smpy5859 2 жыл бұрын
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 🙏
@TheCreatorKaran.K
@TheCreatorKaran.K 2 жыл бұрын
sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏
@TheHemantVlog99
@TheHemantVlog99 2 жыл бұрын
You are the best teacher ☺️😉☺️😉😉 #Learnmore
@kumarkailash7297
@kumarkailash7297 2 жыл бұрын
Sir your teaching style is very nice.
@prabhakarpawar573
@prabhakarpawar573 2 жыл бұрын
Very usefull sirji
@magicofoldsong
@magicofoldsong 2 жыл бұрын
SIR blog ka Ek Series Banaye PLZ SIR
@ManjeetKumar-ye9sg
@ManjeetKumar-ye9sg 2 жыл бұрын
Sir ye to bilkul easy hain first wala
@Altaf_Alam
@Altaf_Alam 2 жыл бұрын
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
@irfanshaikh5577
@irfanshaikh5577 2 жыл бұрын
Please make a video on Cohorts creations and analysis
@bilalbhuri7000
@bilalbhuri7000 2 жыл бұрын
Covert dates to text in mmm format and then apply sumif.
@Comedy_Ke_King_Hai
@Comedy_Ke_King_Hai 2 жыл бұрын
Solve kr diya sir maine😌🙏🏻❤️
@nazarhussainmiriwala3391
@nazarhussainmiriwala3391 2 жыл бұрын
Thanks Jazakallah
@bhole770
@bhole770 2 жыл бұрын
I've solved this problem few months ago sir Thanks for such knowledgeable videos.
@moreknowledge7476
@moreknowledge7476 2 жыл бұрын
Very useful video sir! You are the best teacher and my favorite teacher 👍
@miss_anchal_07
@miss_anchal_07 2 жыл бұрын
kzbin.infodreNeL1PxDA?feature=share
@hiratravels5326
@hiratravels5326 2 жыл бұрын
SATISH SIR YOU ARE BRILLIANTTTTTTTTTTTTTTTTTTTTTTTT HATS OFF TO YOU..............................🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🎍
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@moreknowledge7476
@moreknowledge7476 2 жыл бұрын
Sry for ask question ? Sir KZbin guide course me ek id se 2 channel kaise banaen is pr video banaoo sir pls 🙏🙏🙏
@drgroway1268
@drgroway1268 2 жыл бұрын
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
@sanjeetsharma2700
@sanjeetsharma2700 2 жыл бұрын
Sir data tab functions par video banaiye
@tilottamakalo6241
@tilottamakalo6241 2 жыл бұрын
Sir mujhe basic salary sheet kese banate bataiye please
@sujandas8165
@sujandas8165 2 жыл бұрын
U r awesome sir
@RohitKumar-ot3py
@RohitKumar-ot3py Жыл бұрын
Which formulas is an array formula how to find that?
@arpitagrawal8659
@arpitagrawal8659 2 жыл бұрын
Sir data entry operator job online Kahan par milegi kese karni hogi uske upar video bnaiye
@shai3939
@shai3939 2 жыл бұрын
I WATCH EVERY VIDEO I LIKE IT LOVE YOU SIR ❤❤❤
@UKJ28
@UKJ28 2 жыл бұрын
Hello Sir, me tumcha channel subscribe kelela ahe. tumhhi konta software vaparta he sagle videos banvayla
@sujoyghosh1197
@sujoyghosh1197 2 жыл бұрын
Please make a video on SQL used in Ms excel. It's urgent
@parthrajput4202
@parthrajput4202 2 жыл бұрын
Sir excel se online money earn kar sakte hai kya? Agar kar sakte hai to kaise? Plz bataiye
@darshitchavda8264
@darshitchavda8264 2 жыл бұрын
GREATE SIRJE...
@tarunpal6293
@tarunpal6293 2 жыл бұрын
To good sir I love you sir 😘
@shahzadahmad2406
@shahzadahmad2406 2 жыл бұрын
Sir please made a vadio on spss complete cource
@nitin7911
@nitin7911 2 жыл бұрын
Sir ji Aapka institute kha hai
@addictedsikku7062
@addictedsikku7062 2 жыл бұрын
Sir Tableau k upar v video upload kijye na
@ShubhamSharma-rb1dj
@ShubhamSharma-rb1dj 2 жыл бұрын
Add helper column and use sum if ..
@mostafaahmed09994
@mostafaahmed09994 2 жыл бұрын
Sir You Are Super Great 😚👍
@surajthakuri913
@surajthakuri913 2 жыл бұрын
Ms access ka video banao na sir ji
@MDshami_77
@MDshami_77 2 жыл бұрын
Typing koi free software batayiye
@SRcreation202
@SRcreation202 2 жыл бұрын
(Now) formula me kuchh neya chahiye sir
@raviyadav9
@raviyadav9 2 жыл бұрын
Gjb 🔥
@yakubdange5274
@yakubdange5274 2 жыл бұрын
Sir Muze MIS Executive ke liye konsa Course karna Hoga....
@computertechnologyandjobin3501
@computertechnologyandjobin3501 2 жыл бұрын
Thanks sir ji
@ashishsharma1281
@ashishsharma1281 2 жыл бұрын
Sir sap fmcg depot c&f billing ka full course ka video banaiye
@chandangupta1048
@chandangupta1048 2 жыл бұрын
Accha sir aapne excel kitne dino me Sikh liya tha
@prakashcellcity
@prakashcellcity 2 жыл бұрын
Satish bhai pls app vlookup ko kaise 2 files mae Karna had iska ek video banaeye jitna jaldi ho sake
@excelonlineadvisor
@excelonlineadvisor 2 жыл бұрын
kzbin.info/www/bejne/fqHZeqSqjdCZr8U
@amarikhe3931
@amarikhe3931 2 жыл бұрын
I want to know the configuration of laptops for video editing. Please upload a video for the same. 🙏🏻🙏🏻
@ganeshtiwari2550
@ganeshtiwari2550 2 жыл бұрын
how to learn ms office can u say sir any advice .....
@englishlearning1478
@englishlearning1478 2 жыл бұрын
hi
@excelonlineadvisor
@excelonlineadvisor 2 жыл бұрын
Better to learn from Internet & KZbin (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
@SHEERAZ-ALI
@SHEERAZ-ALI 2 жыл бұрын
Sir simple hy use sumproduct
@prasadtakarwankar7463
@prasadtakarwankar7463 2 жыл бұрын
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...
@dlboy4831
@dlboy4831 2 жыл бұрын
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
@anuragshakya1223
@anuragshakya1223 2 жыл бұрын
3 saal ago ye question solve kr diya tha
@rakeshkumardey3219
@rakeshkumardey3219 2 жыл бұрын
sir files telegram se nahi milte hai. kaise dhundo kaha dhundoo apka files
@msshort231
@msshort231 2 жыл бұрын
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
@Fitness_warrior_05
@Fitness_warrior_05 2 жыл бұрын
Nice sir
@SRcreation202
@SRcreation202 2 жыл бұрын
Supper Sir
@SHEERAZ-ALI
@SHEERAZ-ALI 2 жыл бұрын
This is my logic very simple =SUMPRODUCT(--(TEXT($A$2:$A$10,"MMMM")=E3),$B$2:$B$10)
@rahulrathod2237
@rahulrathod2237 2 жыл бұрын
Course join Kara hai sir
@bijaychhetri518
@bijaychhetri518 2 жыл бұрын
What are the softwares that we need for normal use in our Laptop?
@Rohitkumar-wk2vo
@Rohitkumar-wk2vo 2 жыл бұрын
Excellent video as expected from you 👌👌🙏🙏
@bajrangsinghchandsingh3403
@bajrangsinghchandsingh3403 2 жыл бұрын
Window boot manager ko theek kaise karen
@ebadbaloch8304
@ebadbaloch8304 2 жыл бұрын
SIR YOUR GRAET TEACHER
@vishalbhati912
@vishalbhati912 2 жыл бұрын
Insert Helper column =text(A2,"mmmm") then sumif
@onlymz962
@onlymz962 2 жыл бұрын
sir ms office ko instail karne ka koye sahi tarika btao
@indian2896
@indian2896 2 жыл бұрын
Thank you so much sir 🖥️⌨️🖱️
@indian2896
@indian2896 2 жыл бұрын
❤️❤️❤️❤️
@viralsupport8719
@viralsupport8719 2 жыл бұрын
Good 👍
@sudhirmehdipur
@sudhirmehdipur 2 жыл бұрын
Excel mein algebra ka jod + , ghatav - , Guna x , bhaga / ,kaise karen Please bataye
@excelonlineadvisor
@excelonlineadvisor 2 жыл бұрын
Matlab ?
@ashishshiriskar123
@ashishshiriskar123 2 жыл бұрын
Superb sir as usual you're are Excel Guru 😂
@GreatCreatorBoy
@GreatCreatorBoy 2 жыл бұрын
repairing disk errors. this might take over an hour to complete Sir Iska Solution Bataye Please Sir Ek Video 😭😭😭🙏🙏🙏
@pinkiharshitphatak2934
@pinkiharshitphatak2934 2 жыл бұрын
Supv video sir
@MDshami_77
@MDshami_77 2 жыл бұрын
Sir typing master free kaise download kare
@mudassiranaf
@mudassiranaf 2 жыл бұрын
Unable to Download the Sample file .. Share it in Google Drive pls
@miss_anchal_07
@miss_anchal_07 2 жыл бұрын
kzbin.infodreNeL1PxDA?feature=share
@gurujeetparihar
@gurujeetparihar 2 жыл бұрын
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
@LPtechnical
@LPtechnical 2 жыл бұрын
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 :)
@milansamadder4655
@milansamadder4655 2 жыл бұрын
Sir I want to learn Excel and how to buy your course..
@excelonlineadvisor
@excelonlineadvisor 2 жыл бұрын
Better to learn from Internet & KZbin (Just a suggestion). There are multiple online Excel channel you can use as a reference. For any help, you can message me too
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
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 жыл бұрын
kzbin.infodreNeL1PxDA?feature=share
@satbirkumar1986
@satbirkumar1986 2 жыл бұрын
Will you provide this formula with example because i am getting error in month cell section
@raj95122
@raj95122 2 жыл бұрын
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
@rahul.offical800
@rahul.offical800 2 жыл бұрын
Sr mujhe shikha h but computer nhi h 😥
@atulhinge7162
@atulhinge7162 2 жыл бұрын
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
@rohitj.ladani
@rohitj.ladani 2 жыл бұрын
Awesome
@FauL_UppU
@FauL_UppU 2 жыл бұрын
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
@bongsinu2547
@bongsinu2547 2 жыл бұрын
Sir ... I could not found tally book ... Please help me .... 🥺🥺🥺....
@akcom0987
@akcom0987 2 жыл бұрын
ये क्या चीज़ का फार्मूला है सर
@onlymz962
@onlymz962 2 жыл бұрын
سر مجھے افس انسٹال کرنے کا کوئی صحیح طریقہ بتاؤ پلیز This is my big problem
@magbulmomin4432
@magbulmomin4432 2 жыл бұрын
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
@RakeshKumar-nm4ku
@RakeshKumar-nm4ku 2 жыл бұрын
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" - KZbin p content upload krne k liye koi paise ki jaruat nhi h, aap video free m upload kr skte h
@saeedshaikh5276
@saeedshaikh5276 2 жыл бұрын
👍👍👍👍
@tanmoysaha5804
@tanmoysaha5804 2 жыл бұрын
Sir why"MMMM"
@SouthHDPremiere
@SouthHDPremiere 2 жыл бұрын
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
@swapnaliparkhe2826
@swapnaliparkhe2826 2 жыл бұрын
Zara dheere dheere sikhao....itne speed se kyu sikhaate ho
@mitjoshi8411
@mitjoshi8411 2 жыл бұрын
सर, आपसे 1 request है कि, 1 वीडियो loan amortization का भी बनाए जो आज के दौर में सबसे ज्यादा जरूरी है। आभार 🙏🙏
@sanjeetsharma2700
@sanjeetsharma2700 2 жыл бұрын
Please sir
@ashutoshsingh598
@ashutoshsingh598 2 жыл бұрын
No sir
@munishsawant3933
@munishsawant3933 2 жыл бұрын
=SUMPRODUCT((TEXT(A2:A10, "MMMM")=E3)*B2:B10) I have done this way, got same result Without doing CTRL+SHIFT+ENTER
@satbirkumar1986
@satbirkumar1986 2 жыл бұрын
Will you provide this formula with example because i am getting 0 as a result
@munishsawant3933
@munishsawant3933 2 жыл бұрын
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.
@gurujeetparihar
@gurujeetparihar 2 жыл бұрын
=SUM(FILTER($B$2:$B$10,TEXT($A$2:$A$10,"MMMM")=E3) Use this formula It works properly. Reply Sir please
@muhammadhassantahir103
@muhammadhassantahir103 2 жыл бұрын
Thanks sir
@ebadbaloch8304
@ebadbaloch8304 2 жыл бұрын
NICE VIDEO
How to Use Dynamic Filter VLOOKUP for Smarter Data Analysis😎
29:38
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 45 МЛН
31 Excel Tricks that everyone should know!
45:38
Learn More
Рет қаралды 90 М.
Change number to Word in Excel with this formula | Spell Number in Excel | MS Excel Tips & Trick
9:58
Projection of planes #planes #caed #lines #drawing ......
19:33