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/
Good morning sir I am rabbani raja from India now I am working in Maldives as inventory controller cums admin. I am facing a excel problem in my day to day working time. As I have an employee atandance sheet where 1st row is mergefd and have written as department name and than down side have written all the employees details from the similar department again down side have merge cell and written another department name and downside have written employee details But the problem I am facing in this scenario is tha when ever and new employee join in the company that time i insert a row in his respected department and I fill all the details That time I have to type serial no manually Sir I don,t know I was able to understand my topic to you or not But I hope if you understand my topic so I am hoping a fast and positive reply from your end.
@@rabbaniraja7794 I got your problem you are entering data in wrong way if you entered all the data in merge cells then you will not able to any kind of automation ro quick work even you will not be able to apply any kind of formula properly on merge cells content so I suggest you to type data in separate cells, if you are having long content then use warp text option to type all the content one cell vertically. you can share your query on my app skill course there is chat system on app my team will help you rabbani ji
Good video match and index is very useful then vlookup, however I think you should make videos on VBA macro as well its really nice thing to automated your repetitive task , Thats why I put emphasis on VBA and made some simple video on that.
मैं एक सैलरी कैलकुलेटर बना रहा हूँ. लगभग 12 कर्मचारियों के लिए। एक ही शीट पर अलग अलग महीने की सैलरी कैसे कैलकुलेट की जाये और हर महीने की सैलरी जब चाहे देख सकें। और इंक्रीमेंट की तारीख आने पर अपने आप ड्राप डाउन से या बेसिक पे के टेबल से अपने आप कैसे बदले ? कृपया सहायता कीजिये।
Your videos are one of the best tutorial videos I have seen on TH-cam. Your videos are longer but you don't leave any doubt about even the smallest of the details which others tend to leave out while explaining. Even My Mom can learn excel with your videos and she doesn't know computer at all. Good work. Keep it up. :)
Sir, Excel file me kuch bhi search karte h to jis row me value find hoti h us row ka color automatically change ho jaye or wo color permanently rahe, means new row highlights hone par bhi purana wala color rahe. Mene formula =ROW()=CELl("row") use me liya jisme active row ka color change bhi ho raha h but next row jese hi active hogi last wali row ka color nahi rahata h, jabki mere ko color ki requirement h.
WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile
Download link: bit.ly/473tZ0N
Need certificate sir
Dear Sir , Make a full course video on Power BI .
Mere haya ek Excel sheet he upusame kuch to problem he
Plz guide
It's friday, going for interview on Monday! Really useful video! Great Content!!
Bhai only excel ata h tumko
Sir you are simply best around TH-cam world. You exactly know what audience or students want. Simply Great
God Bless you
Maine Excel ka E bhi kabhi nahi dekha thaa
Aapki bigginer vali video dekh k kaafi samaj mey aaya hey
So thanks again
sir: main videos hi ab apki dekhti hn mostly,,excel etc learnig ko .q k apka smjhane ka treeqa
bht acha hai.
Thank you very very much for providing free Excel concept 👍👍👍👍👍🙏🙏🙏
Dear sir ap bohut easy tariqa se samjha rahe ha.. Waqai apko 16 year ka bohut knowledge he ik beginner ko samjate howe..Love from Pakistan...
What a great teaching style..totally loved the video.
You are very genuine person sir🫶 thank you so much.. this video helped me a lot .🙏
जबरदस्त ,
लय भारी ❤😊
Amazing Video........🇮🇳
Shandaar ❤️❤️❤️❤️❤️👍👍👍
Very profitable video
Thanks sir
Sir aap bahut ache se explain krte hai isliye Mai bs apke vedio se hi study krti hu or job ke liye bhi interview deti hu 😊
Bahut badiya sir ❤
X c lent speaking presentation graphics gr8 keep it up
amjad from pakistan
Tq sir 🙏 main apke vedo main bahut kuchh sikha hai .. Tq again 🙏🙏🙏
🎉 very useful 👍 information ❤
Bht bht informative ❤
very nice teaching way .
🎉🎉🎉great👍 work sir thanks a lot😊
Thank you sir so helpfull your veido 🎉
Sir you are teaching very good
Thanks a lot
❤🙏🙏🙏👌
Very nice teaching method.
Thankyou so much sir 😢
very nice explanation
Ur teaching style is very good i m. Big fan of ur teaching
Sir your video is so help fully so thank you
Thank u sir❤😊
Too good and useful formula 👌👍🤗😘
Thank you sir for this useful video 🙏
Dhanyabad sir...
Super video 🎉
Hari Om sir, dhanyavaad aapka ❤
Thank you sir I love your videos and teaching style, love from Pakistan 🇵🇰👌
Sir Teaching style, and explation is excellent
Sir best video for excel
Great 👍👍
I have no word sir really thanks ❤❤ m
Use full video thanks you sir
Thank you Satish sir....🙏
You are gr8 Sir
I like you sir
Nice guru jee
Thank you sir
Guru ji nice video
you are superb sir
Thank you for sharing your knowledge
It is very helpful
Very useful
Nice video sir
Hello sir,
I'm not able to download Practice file. I found your application but not able to find practice file in your application
Aap bahut achha padhate ho
you are awesome sirji
Very useful sir...thanks
Very nice and very man
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/
Apple Store p aapka App nhi, How to download practice files????
Good morning sir I am rabbani raja from India now I am working in Maldives as inventory controller cums admin.
I am facing a excel problem in my day to day working time.
As I have an employee atandance sheet where 1st row is mergefd and have written as department name and than down side have written all the employees details from the similar department again down side have merge cell and written another department name and downside have written employee details
But the problem I am facing in this scenario is tha when ever and new employee join in the company that time i insert a row in his respected department and I fill all the details
That time I have to type serial no manually
Sir I don,t know I was able to understand my topic to you or not
But I hope if you understand my topic so I am hoping a fast and positive reply from your end.
@@rabbaniraja7794 I got your problem you are entering data in wrong way if you entered all the data in merge cells then you will not able to any kind of automation ro quick work even you will not be able to apply any kind of formula properly on merge cells content so I suggest you to type data in separate cells, if you are having long content then use warp text option to type all the content one cell vertically. you can share your query on my app skill course there is chat system on app my team will help you rabbani ji
@@battlegod69gaming89 apple store pe app hain ji par dusra hain can you contact to my team contact details will be available on skillcourse.in website
Sir MS Excel download krna hai but product key maang rha kya kru?
Aap ka dhanywad
Good explain
Nice good ❤❤
Nice sir🎉❤
Good video match and index is very useful then vlookup, however I think you should make videos on VBA macro as well its really nice thing to automated your repetitive task , Thats why I put emphasis on VBA and made some simple video on that.
Nice sir ji
nice Video sir
Please make a video on AWS
Sir, you tech each and every concept, very nice way, but I want to learn SQL also.
As Awesome as always!
Make video full course data science
मैं एक सैलरी कैलकुलेटर बना रहा हूँ. लगभग 12 कर्मचारियों के लिए।
एक ही शीट पर अलग अलग महीने की सैलरी कैसे कैलकुलेट की जाये और हर महीने की सैलरी जब चाहे देख सकें।
और इंक्रीमेंट की तारीख आने पर अपने आप ड्राप डाउन से या बेसिक पे के टेबल से अपने आप कैसे बदले ?
कृपया सहायता कीजिये।
Real job quary jaise series chaliye sir Excel ka
Amazing video
sir please make a video on insert tab and other tabs also
Your videos are one of the best tutorial videos I have seen on TH-cam. Your videos are longer but you don't leave any doubt about even the smallest of the details which others tend to leave out while explaining. Even My Mom can learn excel with your videos and she doesn't know computer at all. Good work. Keep it up. :)
Humlog Offline classes me aapki hi videos se seekhte hain.
Thank you sir ❤❤
Nice
Sir, Advance Excel par ek complete playlist bna do please
th-cam.com/video/1OL1_lpnLdU/w-d-xo.html
You can tell this sir too he will also help you
Sir g Plz Ms Project course b karwa den par b videos bna den❤
1:49:08 pr jo focus kiya hai vo kaise krte hai sir?
1:55:32 pr jo pen aaya hai vo kaise aata hai
please guide
Sir 100 formula ka video upload kro
Is there any video for SLA formula in hrs excludes weekend
NICE
Thanks for your efforts 😊
First viewer
Sir, AutoCAD 2019 pr be koi Naya video upload kr dy. Plzzz
Very nice sir
Thanks sir
Sir, skill course app me jo practice file ha.. Usko kaise pc screen me le jau?
Sir please frame Questions for respective practise sheets it will be helpful..
Sir can you make Tds entry video
Sir data analysis ka kab video ayega
जाहिर सी बात है वीडियो बनी तो मेहनत तो लगी ही है
Sir pratic ke liy file description me dal liya karo aase samj nahi aata jab tak pratic na kar le ❤
Sir MSCIT Kay Baray May video Bano
Practice test series start Karo sir ji
Sir ki cont no. He apke paas thoda course related baat krni thi
Help me guys😔😔
Sir youtube tutorial mai 2nd files mai Paid amt ka coloun nhi hai
Sir i am pakistani and then joined a excel course
Sir,
Excel file me kuch bhi search karte h to jis row me value find hoti h us row ka color automatically change ho jaye or wo color permanently rahe, means new row highlights hone par bhi purana wala color rahe.
Mene formula =ROW()=CELl("row") use me liya jisme active row ka color change bhi ho raha h but next row jese hi active hogi last wali row ka color nahi rahata h, jabki mere ko color ki requirement h.
Sir aap seedhe solutions bataya karo aap masti bahut karte h