Top 10 Useful formulas in Excel | Every excel user must know these formulas
HTML-код
- Опубликовано: 6 июл 2024
- WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile
Download link: bit.ly/473tZ0N
Top 10 Useful formulas in Excel | Every excel user must know these formulas
In this video, you will learn about top 10 most useful formulas in #msexcel. Which helps to boost your knowledge to get high paying job in excel.so watch video till the end & share with your office buddies so they can improve there Microsoft Excel skills.
- To get Practice file Download our app : bit.ly/3BWfQVa
Timestamp
00:00 -Intro
03:01 -SUMIF
17:25 -SUMIFS
26:06 -COUNTIF
29:21 -COUNTIFS
38:42 -AVERAGEIF, MINIFS, AVERAGEIFS, MAXIFS
50:23 -INDEX&MATCH
01:07:09 -V-LOOKUP
01:39:33 -H-LOOKUP
02:11:24 -PMT,PPMT,IPMT
02:23:35 -IF
#msexcel
#exceltricks
#excelformula
------------------------------------------------------------------------------------------------------------------------------
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/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
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 RUclips 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
WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile
Download link: bit.ly/473tZ0N
Need certificate sir
Thank you very very much for providing free Excel concept 👍👍👍👍👍🙏🙏🙏
Sir you are simply best around RUclips world. You exactly know what audience or students want. Simply Great
God Bless you
You are very genuine person sir🫶 thank you so much.. this video helped me a lot .🙏
What a great teaching style..totally loved the video.
🎉 very useful 👍 information ❤
Thank you for sharing your knowledge
Thank you sir for this useful video 🙏
sir: main videos hi ab apki dekhti hn mostly,,excel etc learnig ko .q k apka smjhane ka treeqa
bht acha hai.
Dhanyabad sir...
Very profitable video
Thanks sir
Sir your video is so help fully so thank you
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.
Sir you are teaching very good
Thanks a lot
❤🙏🙏🙏👌
Very informative video sir 🙏🙏
Thank you sir
Thank you Satish sir....🙏
Thank you sir so helpfull your veido 🎉
Very nice teaching method.
Thankyou so much sir 😢
Use full video thanks you sir
Amazing Video........🇮🇳
Very useful sir...thanks
As Awesome as always!
Very useful
जबरदस्त ,
लय भारी ❤😊
Thank you sir I love your videos and teaching style, love from Pakistan 🇵🇰👌
You are gr8 Sir
Thank you sir 😊
Tq sir 🙏 main apke vedo main bahut kuchh sikha hai .. Tq again 🙏🙏🙏
Thanku so much sir 😊
Too good and useful formula 👌👍🤗😘
Great 👍👍
Very nice and very man
🎉🎉🎉great👍 work sir thanks a lot😊
Sir Teaching style, and explation is excellent
very nice explanation
very nice teaching way .
Thank u sir❤😊
Sir, you tech each and every concept, very nice way, but I want to learn SQL also.
Ur teaching style is very good i m. Big fan of ur teaching
Super video 🎉
It's friday, going for interview on Monday! Really useful video! Great Content!!
Bhai only excel ata h tumko
excellent way to teach
Thank you sir ❤❤
Sir best video for excel
It is very helpful
Shandaar ❤️❤️❤️❤️❤️👍👍👍
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...
Amazing video
X c lent speaking presentation graphics gr8 keep it up
amjad from pakistan
Guru ji nice video
Dear Sir , Make a full course video on Power BI .
Mere haya ek Excel sheet he upusame kuch to problem he
Plz guide
Bahut badiya sir ❤
Maine Excel ka E bhi kabhi nahi dekha thaa
Aapki bigginer vali video dekh k kaafi samaj mey aaya hey
So thanks again
you are awesome sirji
Bht bht informative ❤
Good explain
Aap ka dhanywad
Hari Om sir, dhanyavaad aapka ❤
you are superb sir
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?
Nice video sir
Very nice 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 😊
I have no word sir really thanks ❤❤ m
I like you sir
Nice sir ji
Nice guru jee
Nice sir 👍👍
Nice good ❤❤
Sir please frame Questions for respective practise sheets it will be helpful..
NICE
Nice sir🎉❤
nice Video sir
Please make a video on AWS
Is there any video for SLA formula in hrs excludes weekend
sir please make a video on insert tab and other tabs also
Nice
Your videos are one of the best tutorial videos I have seen on RUclips. 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. :)
good
Aap bahut achha padhate ho
Make video full course data science
Hii Sir
I want one solution from you, I'm used If formula & result comes into cell but If cell is empty then it will takes automatically next cell data so which formula used for this let me know
Real job quary jaise series chaliye sir Excel ka
Sir g Plz Ms Project course b karwa den par b videos bna den❤
Hello sir,
I'm not able to download Practice file. I found your application but not able to find practice file in your application
Humlog Offline classes me aapki hi videos se seekhte hain.
Sir can you make Tds entry video
Sir do we have FULL DETAILED COURSE ON GOOGLE SHEET - I am working in an organisation where google sheets are used on daily basis
❤❤
Sir MSCIT Kay Baray May video Bano
Sir please provide exceln formul specific text which is less than 12 hours count if
And also duplicate text consider one
Sir, skill course app me jo practice file ha.. Usko kaise pc screen me le jau?
❤
Sir youtube tutorial mai 2nd files mai Paid amt ka coloun nhi hai
Thanks for your efforts 😊
sir i have one question for you? how to convert numeric value into English =SpellNumber(a1) s ni horaha h plz help m
👍👍
Sir, AutoCAD 2019 pr be koi Naya video upload kr dy. Plzzz