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/
Sir, Maine apki ek video dekhi hai. Jiska title hai "99_Excel user are not using this trick of Excel Advance Filter" Jisme apne Bade Miyan Aur Chote Miyan ki misal bhi di hai. Video bahot achchha laga, Yakeen maniya mujhe kuch seekhne mila. Iske liye apka bahot shukr guzar hoo. Sir ek problem hai is advance filter (Bade Miyan) me, Maine saare Stores ki quantity ka total kiya 3462 aya. Aur jab advance filter se sirf Dadar search karta hoo to bhi 3462 hi ata hai. Sir ek request hai aise kuch VBA codes bataye ke jis se advance filter me jo Store name type kare usi ka hi total bataye.
Thanks Satish Sir 🙏🙏 hamko Free me Padhane ke liye🙏🙏 Vase kon etana time west karke hamko padhyega .apke es kam ko meri tarpse salute🙋🙋👍?🙏🙏👏👏?❤❤❤❤❤❤👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Sir...excel ki madat se stock market ka option chain data kaise analyse kar sakte hai....jaise ki kounsa strike price me highest open interest hai....etc etc....is par video banaiye....macro aur v look up ki madat se....i am new to this channel....and learning alot from ur channel....thank u so much sir.
Sir mujhe colour wise data filter krna hoto kese kru other sheet se mujhe report banani h ...stock ki.. mujhe chhaiye me jo colour ki condition du vo sare colour ke data vha aajaye plzz sir n ye google sheet pr kese hoga
sir, kya esa ho sakta hai ki excel workbook ki ek sheet me me form(admission form) wise data enter karu to usi workbook ki dusri sheet me wo data apne aap enter ho jaye wo bhi list form me or wo bhi paheli sheet ma last me submit ka button de ke uspe click karu uske baad hi dusri sheet me data list wise enter ho kya esa ho sakta hai please ans. sir
Good evening sir`:- mai md abbas ali sir mai apka video dekhta or help full video hota hai apka subscriber v hu, to sir mera kehna hai ki ek video page maker par v banaye sir apka bahu bahut sukriya
Sir ji, Excel me kai logo ke data hai sirial se ek colum me unko word me lana hai usi formet me lekin table na aye aur space bna rahe her para ke bad kaise hoga
Hello brother you are doing very nice work may God bless you Sir please can you make video on percentage like if my restaurant took order from zomato around 209 rupees but I have to give them 25% how wil apply this formula in excel
Thanks Sir 1 question❓ Agar kisi workbook me kai sheet hai usme se pahli vali main sheet h Mai chahta hu ki mai jab bhi is workbook ko open karu to pahli vali (main sheet) open honi chahiye please help sir
I have a students data list but I want to sort according to rank wise on another page and also want to get top 3 ranks with advance filter by using macro.i tried but can't to both at the same time on the same sheet. Help regarding this plz..
In "Data Tab" of excel only the "Get External Data" group is left to learn God knows when you upload a video on this topic. Please do this as soon as possible.
Sir, what is the shortcut, if we want to clear filters without disturbing the others filters. For ex: if I am searching the data in h column and I want filter remain but the filter with I had applied in h column should be new one like un filter and filter again
#Satish sir its my humble request to u that please shoot 1 video about this 2015,2016,2017,2018 target,achievement,percentage,average,growth,degrowth please explain about it in deeply sir#
Hi sir I have one query. Suppose I have data of college student where in one column there are names of the student and in another column names of the colleges. I want to select only 1 student from each college. If you want i will give you data.
Sir which software you edit the videos, please you tell me And make a full guide video, please sir I request you, thank you for watching my comment, thanks again
Namaskar Sir, Agar main Excel sheet 1 me school result type kar raha hu , jaise roll no.1, Name , pass, roll no. 2, name, fail and so on, lekin automatically sheet 2 me sare pass students aur sheet 3 me sare fail students ke roll no and name type ho jaye, isliye koi formula ho to karke video me batayenge to badi meherbani hogi sir. Thank you.
Wps me ms excel ke sare formule work kyon nahi karte hai sir for eg. Spellnumber formula code ko spreadsheet me past karne ke liye alt+f11 press karne par kuchh bhi nahi open ho raha hai sir. Please sir spreadsheet par ek full video banaye .
Dear Sir, I am really fan of your knowledge and teachings. I am stuck in one of my program. I have a sale data in one sheet e.g. In a row I have Sale of Item1, Item2, Item3 and so on and in a column name of customers. Please note that customer name can appear many times. Now in a another sheet I want to show name of all customers (Only Once) and the total of sale of Item1, Item2, Item3 and so on. Please help me.
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/
Bahut acha Pahate ho
Nice teaching👌👌👌👌👌👌👌👌👌👌👌👌
Very nice way of teaching 😊😊
Satish sir aapke samjhane ka tarika bahut accha hai
Learning and typing practice is a best part fir all of users.
I already following you in Facebook also. You are a great teacher and I love your teaching style. Thank You Respected Sir 🙏.
Sir you are a genius of computer technical of pc masters.
Bahut hi achha samjate he app thank you sir ji
Sir,
Maine apki ek video dekhi hai.
Jiska title hai "99_Excel user are not using this trick of Excel Advance Filter"
Jisme apne Bade Miyan Aur Chote Miyan ki misal bhi di hai.
Video bahot achchha laga,
Yakeen maniya mujhe kuch seekhne mila.
Iske liye apka bahot shukr guzar hoo.
Sir ek problem hai is advance filter (Bade Miyan) me,
Maine saare Stores ki quantity ka total kiya 3462 aya.
Aur jab advance filter se sirf Dadar search karta hoo to bhi 3462 hi ata hai.
Sir ek request hai aise kuch VBA codes bataye ke jis se advance filter me jo Store name type kare usi ka hi total bataye.
First of all a lot of best wishes to the new born baby.As always this video is also the best.
Thanks Satish
Sir 🙏🙏
hamko Free me Padhane ke liye🙏🙏
Vase kon etana time west karke hamko padhyega .apke es kam ko meri tarpse salute🙋🙋👍?🙏🙏👏👏?❤❤❤❤❤❤👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Nice trick Sir 👌👍
Kataiii Jahar H Sir Yee Chotee Miya Or Badeeee Miya
Waoooooooo sir. Very useful video.
Nice Video Sir Keep It Up Well Done 👍👍👍
Sir u are really Awsome
Wow, maza agya.thanks..agar Heading name fix na hokar,dynamic ho tab kya change hoga code me, please bataiye..
Amazing explaintion
Sach a great teacher nd
Very Nice Sir Ji
Excellent sir
Nice way to explain !!!
Google sheets के लिए भी वीडियो बनाएं.
Happy holi sir
Thanks sir Best teacher 👍
इस कोड का उपयोग google sheets पर भी करके बताएं.🙏
Nice & helpful....thanks..
Useful video sir
Good explanation
Great sir
Sir you are great🙏
Amazing way you teach.
Sir...excel ki madat se stock market ka option chain data kaise analyse kar sakte hai....jaise ki kounsa strike price me highest open interest hai....etc etc....is par video banaiye....macro aur v look up ki madat se....i am new to this channel....and learning alot from ur channel....thank u so much sir.
सर जी आप से मेरा निवेदन है कि आप एक video FULL ADVANCE EXCEL पर बनाए तो 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙋🙋🙋
Excellent
Super Sirrr
Superb
Sir Excel 2007 version me xlookup ka Koi kod hoga to bataiye please
kya sir ji ajib type se bol rhe h maza aa gya sun k.
Love u Gurujii!
Excellent . Very helpful. Can i maintain an excel though which I can send auto Birthday mails using Birthday dates.
Amazing Thanks a lot
lovely content
Hello
amazing content
Tally par complete video banaye
Thanks🙏🙇 for this video!
Hello Satyam,
Abhi channel par Tally ERP9 start Kiya hai aap Basic to Advance Tally Sikh sakte hai.
Thanks in advance 😊
Nice video
lovely stuff
Nice sir
Lovely.
Very useful
GSTR 2A reco by vlookup ke bare me video banaiye
छोटा सा नना सा डाईलोग बॉक्स 👍🤣
Thank u so much
गजब
Sir mujhe colour wise data filter krna hoto kese kru other sheet se mujhe report banani h ...stock ki.. mujhe chhaiye me jo colour ki condition du vo sare colour ke data vha aajaye plzz sir n ye google sheet pr kese hoga
Thanks sir
Basic se lekar advanced level tk Ms word video plz sir
Video is under recording
Sir Kya baat h sir gf impress ho gyi sir
sir, kya esa ho sakta hai ki excel workbook ki ek sheet me me form(admission form) wise data enter karu to usi workbook ki dusri sheet me wo data apne aap enter ho jaye wo bhi list form me or wo bhi paheli sheet ma last me submit ka button de ke uspe click karu uske baad hi dusri sheet me data list wise enter ho kya esa ho sakta hai please ans. sir
Good evening sir`:- mai md abbas ali sir mai apka video dekhta or help full video hota hai apka subscriber v hu, to sir mera kehna hai ki ek video page maker par v banaye sir apka bahu bahut sukriya
Very easy and amazing, but I couldn't do it😅
Sir koi item h Lakin uske hr sal alg alg rate h to esa konsa formula use kre jis se ki year change krte he us itime k samne itme ki year rate aa jye
Thanks , I want to know this
Sir bank Cc account ka interest kase nikale aap is par bhi video bnaye please
Zabardust sir. If u don't mind u should accept Islam
Sir ji,
Excel me kai logo ke data hai sirial se ek colum me unko word me lana hai usi formet me lekin table na aye aur space bna rahe her para ke bad kaise hoga
Is video me kounsi branch me highest stock hai...woh nikal sakta hai kiya??....formula use kar ke
Sir Plz Ms word pe video bnao🙏🙏
aur ha sir tally 9 ka update version 6.6 aa gaya hai to kya aapki taraf se uspe video milega ?
Code banane ke baad micro enable file me save karna hoga?
Sir typing ke upre ek video banao
Hello brother you are doing very nice work may God bless you
Sir please can you make video on percentage like if my restaurant took order from zomato around 209 rupees but I have to give them 25% how wil apply this formula in excel
Sir can you make a video on Ms access
Sir. Pacemaker per video banao plz
Thanks Sir
1 question❓
Agar kisi workbook me kai sheet hai usme se pahli vali main sheet h
Mai chahta hu ki mai jab bhi is workbook ko open karu to pahli vali (main sheet) open honi chahiye please help sir
Osm
I have a students data list but I want to sort according to rank wise on another page and also want to get top 3 ranks with advance filter by using macro.i tried but can't to both at the same time on the same sheet.
Help regarding this plz..
Sir will dynamic filter works on multiple data in a cell
Satish Sir ye jo bade miya yani advance Filter hai isme agar criteria change karte hai to filtered data change nahi ho raha hai. kya kare.
In "Data Tab" of excel only the "Get External Data" group is left to learn God knows when you upload a video on this topic. Please do this as soon as possible.
Sir, what is the shortcut, if we want to clear filters without disturbing the others filters. For ex: if I am searching the data in h column and I want filter remain but the filter with I had applied in h column should be new one like un filter and filter again
Sar tally me double unit ka video banao
Sir if there is any row blank in the middle of the data then will this filter work?
Hello sir,
Upka all excel and tally ka all video dekta hum.
Dear sir excell sheet मे sheet 1,2,3,4,5ko यकी सिट मे pivot result karna he kesi karu
#Satish sir its my humble request to u that please shoot 1 video about this 2015,2016,2017,2018 target,achievement,percentage,average,growth,degrowth please explain about it in deeply sir#
Sir, is it can use with data validation list means when brand name change the data should be update. Pl confirm.
🌹 सीखते रहो, सिखाते रहो 🌹📖📚🏹🌹🔥 राधे राधे🔥ARK🌹🏹
सदा हंसते रहो, मुस्कुराते रहो
🌹🔥ARK 🏹
Sir ap mumbai se ?
Want to use filter n split screen together how can we do that ??
How can i make total of filter data in advanced filter?
Sir....ye Ms Excel 2007 me work nii krta kya🙏
how to past data from one sheet to another sheet which have formulas & duly protected.
Sir vba code is not copy i mean the content is not select for any action.
Hi sir
I have one query. Suppose I have data of college student where in one column there are names of the student and in another column names of the colleges. I want to select only 1 student from each college. If you want i will give you data.
Sir which software you edit the videos, please you tell me And make a full guide video, please sir I request you, thank you for watching my comment, thanks again
Sir day selection kare 1+ date aaye kaise hoga bata sakte hai
Namaskar Sir,
Agar main Excel sheet 1 me school result type kar raha hu , jaise roll no.1, Name , pass, roll no. 2, name, fail and so on, lekin automatically sheet 2 me sare pass students aur sheet 3 me sare fail students ke roll no and name type ho jaye, isliye koi formula ho to karke video me batayenge to badi meherbani hogi sir.
Thank you.
Wps me ms excel ke sare formule work kyon nahi karte hai sir for eg.
Spellnumber formula code ko spreadsheet me past karne ke liye alt+f11 press karne par kuchh bhi nahi open ho raha hai sir.
Please sir spreadsheet par ek full video banaye .
Sir, good morning
Pagemaker me A4 size paper A bhag me bant kar 4shokpatra banane ka video banaei please sir .
Dear Sir, I am really fan of your knowledge and teachings. I am stuck in one of my program. I have a sale data in one sheet e.g. In a row I have Sale of Item1, Item2, Item3 and so on and in a column name of customers. Please note that customer name can appear many times. Now in a another sheet I want to show name of all customers (Only Once) and the total of sale of Item1, Item2, Item3 and so on. Please help me.