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/
Apki padhane ki taknik se Sir mai apka fan ban gaya hnu Thanks free teacher asehi new technique share karo ki jo kisese malum nahi hai .thank you so much.
Waah sir!!! Bahut khub. Maza aagaya!!! Aise hi videos baniye, aur hame educate kijiye. Thanks sir!!! Wish, these are taught in schools and colleges !!!
Dear Satish I am watching your videos since 20 days or may be more... It is very useful, Could you please give me some more videos on conditional formatting in elaborative form. You are superb in excel even I go for some videos of trainer outside India but I think your classes are more pragmatic than them. All the best and Thank you so much.
Steps for highlighting the cells by using advance conditional formatting 1 make a table 2 make a list by using data validation 3 apply FIND formula 4 apply ISNUMBER formula 5 next step is to be combined both FIND & ISNUMBER formula 6 go to conditional formatting ....click on new formula ....select cells which needs to be determined...paste formula ... Done
Bro. बहुत अच्छी तरह आप सिखाते है।। अब ये वीडियो बहुत अच्छे बनाते हो आप।। आपने क्या फॉर्मूला के syntax की कोई वीडियो बनाई है जिससे फॉर्मूले में उपयोग होने वाले syntex को आसानी से समझा जा सके।।
Hi Satish Sir, mujhe apse ek help chahiye ki hamare paas 2 table hai aur dono mein kuch numeric value hai mujhe to table me se duplicate number nikalna hai lekin dono tables me Jo value hai wo bhi apni apni table me duplicate hai to conditional formatting ka use krna hai mujhe lekin alag alag table me Jo duplicate values hai unki conditional formatting na Ho. Ek table ki dusri table se krni hai duplicate match. Kese hoga
SHATISHBHAI NICE LECTURE AGAIN ,ONE QUESTION HERE WHAT IF YOU HAVE TEN CUSTOMERS IN COLOUM B AND YOU WISH TO HIGHLIGHT "PAID"AND "UNPAID" HOW WOULD YOU IMPLEMENT THAT AT CLICK . WOULD IT BE SAME FORMULA AS HERE YOU HAVE BATSMAN ADDED NEXT TO THE PLAYER SIMILAR WITH THE BOWLER SO DO YOU MAKE "PAID"AND "UNPAID" IN THE DIFFERENT COLOUM . I WILL BE INTERESTING TO SEE THE RESULT .THANK YOU .
YES WE CAN DO IT WITH PAID AND UNPAID IF IT IS NEXT TO CUSTOMERS COLUMN MEANS PAID AND UNPAID TEXT IS IN ANOTHER COLUMN SO GO FOR C =$C2=$D$1 C-COLUMN CONSIDER A PAID AND UNPAID AND D1 HAS PAID, UNPAID DROP DOWN LIST SELECT CHOICE BUT REMEMBER WHILE APPLYING THIS SELECT COMPLETE DATA CUSTOMER NAME AND ALL IT IS JUST LIKE MY PREVIOUS LECTURE OF CONDITIONAL FORMATTING ...I HAVE SENT YOU FILE ON MSN ID ...IF YOU ARE NOT GETTING LET ME KNOW.
Hi Satish, I have started to watch your video from 2-3 days. these are very helpfull to get basic knowledge. But I am stuck to highlight a entire cells in which formula has applied. for e.g. need to highlight a row in a sheet where vlookup formula has used. I am using excel 2013. Please help
Dear Brother, the video is great with its contains & subject. Thank you very much for making it. But, I am having a question. Normally we are not specify 2 things in the same cell. for example if I am working on a sheet and want to highlight cells (as you had shown) on male female basis or regular or defaulter customers, how can we get results as we are having a separate column for such information. Please reply. Thank You.
Sir can you make video on what is power BI ,power view,power quarry, power pivot Which person should need this to learn which not Or this tool work with VBA Thanks in advance
I use this condition formatting but it doesn't highlight enter row. It highlight the selective part. I need some things highlight my enter row with some logic. Can help?
mere paas 1 live sheet stock ki hai usme jab dusri collum buy or sell signal aaye tab muje vo stock buy or sell dusri sheet pe dekhye iske liye konsa formula ya fuction hota hai excel me plz reply dena thank you
Sir I have one question yo you... Q:- How to make Automatic value format in excel and when We change any value in any cell of range in another sheet cell value or range will automatically change as per our requirements?????
Sir, kya excel me essa formula h ki hum kuch items jo ki A, B ,c alag alag group k ho, ki list banye or summary me A group k items alag,B group k items alag esse sbhi group k alag aa jaye.??
Amazing sir। Thankuu . Aap advance formulas sikhate hain। Naya kuch... Bs। 1 question hai। Apne sb karne k baad wo TRUE FALSE ka data hide kese kara। Plzz explain
FILTER MACRO USE KARENGE ASHU JI MERA EK FILTER MACRO KA VIDEO HAI MAI LINK BHEJ RAHA HUN DEKH LENA - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wru_mURMF7Y.html