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
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
2 жыл бұрын
Sir ji 1click me sallery sabhi employees ke account me paisa kaise transfer karen
@visible_all_time.
Жыл бұрын
Q
Very usefull sirji
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 🙏
You are the best teacher ☺️😉☺️😉😉 #Learnmore
sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏
Thanks Jazakallah
I've solved this problem few months ago sir Thanks for such knowledgeable videos.
Excellent video as expected from you 👌👌🙏🙏
U r awesome sir
Sir your teaching style is very nice.
Thanks sir ji
Sir You Are Super Great 😚👍
Thanks sir
GREATE SIRJE...
Very useful video sir! You are the best teacher and my favorite teacher 👍
@miss_anchal_07
2 жыл бұрын
kzread.infodreNeL1PxDA?feature=share
Solve kr diya sir maine😌🙏🏻❤️
I WATCH EVERY VIDEO I LIKE IT LOVE YOU SIR ❤❤❤
Sir ye to bilkul easy hain first wala
To good sir I love you sir 😘
Sry for ask question ? Sir KZread guide course me ek id se 2 channel kaise banaen is pr video banaoo sir pls 🙏🙏🙏
Good 👍
Gjb 🔥
SIR blog ka Ek Series Banaye PLZ SIR
Nice sir
Sir data tab functions par video banaiye
Supper Sir
NICE VIDEO
Awesome
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Please make a video on Cohorts creations and analysis
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...
I want to know the configuration of laptops for video editing. Please upload a video for the same. 🙏🏻🙏🏻
Supv video sir
SIR YOUR GRAET TEACHER
Sir solve Kar liye hum sumproduct formula se 😃.............=SUMPRODUCT(--(TEXT(a2:a10,"MMMM")=E3)*B2:B10) THANKS🙏❤️.....ab video dekhte hai😊
@munishsawant3933
2 жыл бұрын
Sumproduct give the answer also without adding -- this sign before text formula
@Altaf_Alam
2 жыл бұрын
@@munishsawant3933 hmm
This is my logic very simple =SUMPRODUCT(--(TEXT($A$2:$A$10,"MMMM")=E3),$B$2:$B$10)
Covert dates to text in mmm format and then apply sumif.
Sir please made a vadio on spss complete cource
What are the softwares that we need for normal use in our Laptop?
SATISH SIR YOU ARE BRILLIANTTTTTTTTTTTTTTTTTTTTTTTT HATS OFF TO YOU..............................🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🏆🎍
Sir mujhe basic salary sheet kese banate bataiye please
Ms access ka video banao na sir ji
Thank you so much sir 🖥️⌨️🖱️
@indian2896
2 жыл бұрын
❤️❤️❤️❤️
Course join Kara hai sir
Sir Tableau k upar v video upload kijye na
Please make a video on SQL used in Ms excel. It's urgent
Sir simple hy use sumproduct
Sir Muze MIS Executive ke liye konsa Course karna Hoga....
Sir ji Aapka institute kha hai
Add helper column and use sum if ..
Unable to Download the Sample file .. Share it in Google Drive pls
@miss_anchal_07
2 жыл бұрын
kzread.infodreNeL1PxDA?feature=share
(Now) formula me kuchh neya chahiye sir
Sir sap fmcg depot c&f billing ka full course ka video banaiye
3 saal ago ye question solve kr diya tha
Satish bhai pls app vlookup ko kaise 2 files mae Karna had iska ek video banaeye jitna jaldi ho sake
@excelonlineadvisor
2 жыл бұрын
kzread.info/dash/bejne/eqSqq9OtiM7MqcY.html
Hello Sir, me tumcha channel subscribe kelela ahe. tumhhi konta software vaparta he sagle videos banvayla
Typing koi free software batayiye
Superb sir as usual you're are Excel Guru 😂
Which formulas is an array formula how to find that?
👍👍👍👍
Sir data entry operator job online Kahan par milegi kese karni hogi uske upar video bnaiye
sir ms office ko instail karne ka koye sahi tarika btao
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
Sir excel se online money earn kar sakte hai kya? Agar kar sakte hai to kaise? Plz bataiye
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
Insert Helper column =text(A2,"mmmm") then sumif
I think you could use this formula too without IF =SUMPRODUCT(value range,(TEXT(month range= month cell)*1))
@miss_anchal_07
2 жыл бұрын
kzread.infodreNeL1PxDA?feature=share
@satbirkumar1986
Жыл бұрын
Will you provide this formula with example because i am getting error in month cell section
Excel mein algebra ka jod + , ghatav - , Guna x , bhaga / ,kaise karen Please bataye
@excelonlineadvisor
2 жыл бұрын
Matlab ?
Accha sir aapne excel kitne dino me Sikh liya tha
repairing disk errors. this might take over an hour to complete Sir Iska Solution Bataye Please Sir Ek Video 😭😭😭🙏🙏🙏
Sir I want to learn Excel and how to buy your course..
@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
Please sir
how to learn ms office can u say sir any advice .....
@englishlearning1478
2 жыл бұрын
hi
@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
How to do after selecting any name drop list his/her details like number, age, marks should appear 🤔🤔
@excelonlineadvisor
2 жыл бұрын
Use Subtotal to sum number, age & marks. After using it, if you use filter, you will get the values
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
2 жыл бұрын
Saare parameters ko table format m bnake "Duplicate" function use kr skte h
Sir typing master free kaise download kare
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
Sir ji 1click me sallery sabhi employees ke account me paisa kaise transfer karen
@excelonlineadvisor
2 жыл бұрын
Isme Bank se baat krni padegi, Excel sirf salary chart bna skta h, bank account m credit ni kr skta :)
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
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
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
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
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
Sir ... I could not found tally book ... Please help me .... 🥺🥺🥺....
ये क्या चीज़ का फार्मूला है सर
Sr mujhe shikha h but computer nhi h 😥
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/
सर, आपसे 1 request है कि, 1 वीडियो loan amortization का भी बनाए जो आज के दौर में सबसे ज्यादा जरूरी है। आभार 🙏🙏
Sir why"MMMM"
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
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
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
سر مجھے افس انسٹال کرنے کا کوئی صحیح طریقہ بتاؤ پلیز This is my big problem
No sir
Zara dheere dheere sikhao....itne speed se kyu sikhaate ho
=SUM(FILTER($B$2:$B$10,TEXT($A$2:$A$10,"MMMM")=E3) Use this formula It works properly. Reply Sir please
=SUMPRODUCT((TEXT(A2:A10, "MMMM")=E3)*B2:B10) I have done this way, got same result Without doing CTRL+SHIFT+ENTER
@satbirkumar1986
Жыл бұрын
Will you provide this formula with example because i am getting 0 as a result
@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.
sir files telegram se nahi milte hai. kaise dhundo kaha dhundoo apka files
Window boot manager ko theek kaise karen