Тёмный

MS Excel - Statistical Functions 

TutorialsPoint
Подписаться 3,5 млн
Просмотров 486 тыс.
50% 1

MS Excel - Statistical Functions
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited

Опубликовано:

 

12 июл 2016

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 121   
@TutorialsPoint_
@TutorialsPoint_ Год назад
To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "RU-vid12" to get ‘’FLAT 12%’’ OFF at Checkout.
@Ykbarodiya
@Ykbarodiya Год назад
Hi, Do we have excel sheets data available for practising in this course?
@sandipkulkarni4104
@sandipkulkarni4104 3 года назад
Quality content, Best instructor, No stupid Advertising, Clean and clear explanation, short and useful vdos, easy to understand... Thank u so so much Tutorials Point and Mr. #Pavan_Lalwani Sir ji✌️🙏
@sarikalohiya3224
@sarikalohiya3224 5 лет назад
Sir, I am thankful to you. Nice method of teaching, simplicity in words.keep it up. Each and every point covered by you in specific tab🙏
@shallybhardwaj4733
@shallybhardwaj4733 5 лет назад
I don’t know where you have been hiding. You have solved most of my data problems which I was struggling for long time. Thanks!
@amanahmed6057
@amanahmed6057 3 года назад
101 % correct
@satishpai7340
@satishpai7340 5 лет назад
I am regular viewer of your videos, which are really educative and extremely helpful. Sir keep it up. And also educate us on creating formulas, particularly for calculating ITax. ThanQ
@g.vivekanandagangaraju485
@g.vivekanandagangaraju485 3 года назад
All the other tutorials says how to use these functions,but you are great in explaining the purpose of using those formula.i like your turtoruals very much thank u🙏
@snehasinghrajput108
@snehasinghrajput108 2 года назад
your videos are making "excel learning" so easy. Thanks sir.
@Saimusiccreater04
@Saimusiccreater04 Год назад
Nice comment dear👏
@Saimusiccreater04
@Saimusiccreater04 Год назад
Hello sneha ,i can speake with you ,why beacuse of i ask one dowt in this problem,thank you
@AhJodie
@AhJodie 4 года назад
OMG, thank you for the easy clarification, gave me confidence!!!!!
@saubhagyaswain9944
@saubhagyaswain9944 5 лет назад
Very Very USeful. Thank you, Sir and Tutorials Point (India) Pvt. Ltd.
@sen-ow7ub
@sen-ow7ub Год назад
I feel I have learned many new things from this video and you should keep posting new short videos everyday.
@rohabmuhammad7723
@rohabmuhammad7723 4 года назад
Great lecture! you have taught us very well in a very easy method.
@swetapadmasahoo8216
@swetapadmasahoo8216 5 лет назад
Really helpful n like savior for me..thanks is not enough for you sir.keep helping us🙏
@laxmandevadiga543
@laxmandevadiga543 4 года назад
You are really very good teacher.I learned lot off from you.god bless you.
@hanumantk7281
@hanumantk7281 6 лет назад
Its really nice tutorials helpful in daily works -- Thank you very much
@souravdash340
@souravdash340 4 года назад
Superb explanation If you want full knowledge of excel complete this playlist.
@Ykbarodiya
@Ykbarodiya Год назад
The way you teach is very simple and easy to learn. Thanks❤
@beenanair2786
@beenanair2786 6 лет назад
good clarity in explanation. very nice.
@atulshukal4072
@atulshukal4072 3 года назад
बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब प्रैक्टिस के साथ जय हो
@lmshukla849
@lmshukla849 6 лет назад
i impressed for your explanation style.......keep it up. you are do well some special a day.
@Saimusiccreater04
@Saimusiccreater04 Год назад
Thank you sir for giveing the best examples for statastical functions.
@asaidmohr7535
@asaidmohr7535 4 года назад
Thank you very much, greeting from Egypt
@anilpanikar7774
@anilpanikar7774 Год назад
simple explanation - Hallmark of an Excellent Teacher
@rakshadevi6282
@rakshadevi6282 6 лет назад
This is the right thing to teach​ people
@ritznij7242
@ritznij7242 5 лет назад
all the presentations are really good and very easy to understand. good work. thanks for the videos.
@nagaprakash7851
@nagaprakash7851 4 года назад
Super sir Very helpful
@onwunzoGideon-dz5ex
@onwunzoGideon-dz5ex Год назад
His teaching skills is out of this world 🤍
@clemechilella1830
@clemechilella1830 6 лет назад
how the use of statistics function will help me with improve in my job and how to save time in arrange the fig well
@jabirp.k1582
@jabirp.k1582 4 года назад
IT WORKS, THANKS A LOT
@kevinsinghmakkad
@kevinsinghmakkad 5 лет назад
what is the name of touch interface you use in background
@jyotiprakashsingh3759
@jyotiprakashsingh3759 2 года назад
thank you sir for this very worthful lesson .
@abulkhayer5612
@abulkhayer5612 4 года назад
Thank you sir for your effort... Those are really helpful... Please make videos on vba....macro... How to copy data from Excel to notepad...Eagerly waiting for your videos...
@AmitSharma-mx6qi
@AmitSharma-mx6qi 5 лет назад
Presentation is really good. thanks
@thevloglife105
@thevloglife105 7 лет назад
It was really nice tutorial.
@rockstarnayra6641
@rockstarnayra6641 4 года назад
Great work sir .... ...God bless u
@nakulpuri2294
@nakulpuri2294 5 лет назад
what should i do if i have to add for both mon and tue from one column
@docmitwa
@docmitwa 5 лет назад
Hi, This gives result for John AND Monday; how to go about John OR Monday ?? Thanks in advance..
@surabhimathurnigam5827
@surabhimathurnigam5827 4 года назад
what would be the formula when I want sum of those numbers which are less than 30 and also written against Mon & John?
@rakeshjoshi1425
@rakeshjoshi1425 5 лет назад
how to use countifs for 70. Please clarify
@zerogamer8343
@zerogamer8343 5 лет назад
Kya aak number teaching skill hai
@akhitrai2717
@akhitrai2717 4 года назад
It does works. I am trying for long time
@sikharaj970
@sikharaj970 3 года назад
❤️ U deserve this!👍
@princegaurea70
@princegaurea70 5 лет назад
All vedios are teaching sometging new Thank u Can you please arrange to provide vba vedios
@manikantaperumalla8014
@manikantaperumalla8014 5 лет назад
sir u r really talented
@rakesh9840
@rakesh9840 4 года назад
Hi,Can you help me in finding the number of calls done set of employees through the response sheet which they submit everyday...using countifs & Today() . Kinda automated sheet to find ftd details. I have tried the method which said in video but I get answer as 0.
@kpkanna1529
@kpkanna1529 Год назад
Sir ur clz is very useful but one doubt how to know the equation how can that apply in each question
@pankajgaurr
@pankajgaurr 3 года назад
What device are you using as the projected screen?
@prachi2830
@prachi2830 2 года назад
hey sir , I am trying to use the same example and even I am applying the same method which you have used .but it is not including the topmost Monday . could you please the tell the error which is occurring
@DilwaleChawlaJi
@DilwaleChawlaJi Год назад
Seedhi baat no bakwas. Great tutorial.
@ujayapal8241
@ujayapal8241 4 года назад
Presentation method very good for easy understand
@pragyansahu1024
@pragyansahu1024 6 лет назад
U r great sir
@kalyanram7000
@kalyanram7000 5 лет назад
Excellent work
@nikulvadher701
@nikulvadher701 3 года назад
Great efforts 👏👏
@mdgulrez9187
@mdgulrez9187 4 года назад
Tutorial point the way of learning
@manojgujar6286
@manojgujar6286 4 года назад
Please post a session on Analysis of Bank account statement viz. Pivot Table and V Look up. This shall help in saving time during investigation. Thanks.
@annalobacheva1900
@annalobacheva1900 4 года назад
what I can see the first two functions sumif can be easily replaced by a simple filter and it will be faster. Meanwhile, keep looking....
@fayazahmed6537
@fayazahmed6537 3 года назад
Hi Sir... Urgently looking to know why double code for numbers, hence it is used only for text.. Asap
@perumalprasath6012
@perumalprasath6012 3 года назад
Most usefull for analysis
@ezekielbenjaminsunday3174
@ezekielbenjaminsunday3174 4 года назад
highly educative
@user-yx3uu4ub8k
@user-yx3uu4ub8k 2 года назад
You're great.
@selvanm2872
@selvanm2872 5 лет назад
THANK YOU
@muhammadashraf6604
@muhammadashraf6604 Год назад
Great sir Keep it up 💪
@muhammadumarkhalid3749
@muhammadumarkhalid3749 5 лет назад
Excellent 👍
@shubhenduvikramsingh1377
@shubhenduvikramsingh1377 4 года назад
Sir aap great ho
@Cafe_Sona...
@Cafe_Sona... Год назад
Thank you sir!!
@brd8764
@brd8764 3 года назад
It is stated for using because it is known as useful. It is also for personal relevance. It representation graphics.
@chinz26
@chinz26 4 года назад
Do both the criteria’s need to be equal I mean in same row can’t it be in different row
@karunakarreddy8129
@karunakarreddy8129 2 года назад
Great presentation
@shivansh7407
@shivansh7407 3 года назад
Also try with "monday" in 2:03 just to be more comfortable with queries. (Not Case Sensitive)
@ziaullahzia3132
@ziaullahzia3132 3 года назад
Great lecture
@padmar5956
@padmar5956 5 лет назад
Very nice
@komalkumawat3865
@komalkumawat3865 5 месяцев назад
thank you sir 😊😊
@saurabhkumarverma3714
@saurabhkumarverma3714 2 года назад
Thank you so much sir
@nagarajunetkal908
@nagarajunetkal908 5 лет назад
Easily understand
@ashishbinjola3256
@ashishbinjola3256 4 года назад
Sir if I use =countif(C4:C15,"= E5") then formula could not accept the E5 cell number. Let me know why it is not accepting this
@ksalikhan
@ksalikhan 4 года назад
remove quotes for E5, directly mention E5 instead =countif(C4:C15, E5)
@shikha4159
@shikha4159 5 лет назад
when your financial function video comes
@29ibrahimsayed95
@29ibrahimsayed95 Год назад
Thank you sir
@amanbhargava2702
@amanbhargava2702 3 года назад
Thank you😊😊😊😊😊😊
@rakshaacharya9264
@rakshaacharya9264 4 года назад
Hi, Can you assist me, how can we multiply a value based on the value selected on the other cell ? What conditions we can apply ? Eg: If I choose contractor in the first cell, then their day rate should be multiplied by 1.2 in the second cell.
@ksalikhan
@ksalikhan 4 года назад
=if(A1="contractor", 1.2*dayrate)
@rakshaacharya9264
@rakshaacharya9264 4 года назад
@@ksalikhan Thank you :)
@Saimusiccreater04
@Saimusiccreater04 Год назад
Hello sir ,please explain the perform text functions for the given data using excel, sir please send the comment on link
@vimalakumareson5668
@vimalakumareson5668 5 лет назад
sir i need a ppt of your lecture
@nishashelar4261
@nishashelar4261 3 года назад
Please teach us how to use whatif analysis
@som9135
@som9135 4 года назад
Are u using projector???
@faeemahmad7790
@faeemahmad7790 Год назад
Good teacher
@mayurchauhan2065
@mayurchauhan2065 5 лет назад
Nice explain
@ambikasarath1661
@ambikasarath1661 2 года назад
Sir it's urgent please reply me... It which institute they use this computer statistical tools in excel.... Like computer center or nursing ....like that... Sir please it's urgent... For applying exam they asking experience certificate.... So only sir... Pls pls it's request....
@cmakanhaiyajha8035
@cmakanhaiyajha8035 5 лет назад
thanks sir
@vianerymgaya8834
@vianerymgaya8834 2 года назад
Are u using smartboard?
@sudheerv5105
@sudheerv5105 2 года назад
And cant be used in Sumif formula for the same Qsn
@ruturapednekar7689
@ruturapednekar7689 3 года назад
Sir pls make video how to make receipt payment entries and day book
@kellyoku
@kellyoku 5 лет назад
Excellent work, but there is something wrong with my calculation
@solankiashok5216
@solankiashok5216 6 лет назад
This video very helpful But video in teacher action is not seen to screen
@Sanjeevkumar-pk1ks
@Sanjeevkumar-pk1ks Год назад
Sir struggling to find sum ifs answer please help sir
@DeepikaSharma-fj1zr
@DeepikaSharma-fj1zr 3 года назад
How to use countif for words
@sycogaming6656
@sycogaming6656 9 месяцев назад
nice
@rishabhsaluja4921
@rishabhsaluja4921 3 года назад
Who is this cutie?
@sunya926
@sunya926 8 месяцев назад
can I pay by debit card?? my paypal account is not working right now
@kousalyabalasubramanian6409
@kousalyabalasubramanian6409 3 года назад
Sir 2 table couldnot answer in formula
@ethiotelecomcreditassociat9350
@ethiotelecomcreditassociat9350 2 года назад
it is baste learning
@self.help.motivation
@self.help.motivation Год назад
Double criteria is not working in ms excel 2007!
@khushpreetkaur1854
@khushpreetkaur1854 2 года назад
Sir nice teaching but you don’t zoom your screen it’s difficult to understand.
@srimathipadmagiri5076
@srimathipadmagiri5076 4 года назад
I need address label in excel please put that video
Далее
MS Excel - Maths & Trigonometry
11:09
Просмотров 226 тыс.
MS Excel - Count Functions
7:19
Просмотров 503 тыс.
Построил ДЕРЕВНЮ на ДЕРЕВЬЯХ!
19:07
Brawl Stars Animation: PAINT BRAWL STARTS NOW!
00:52
Просмотров 3,4 млн
Master Data Analysis on Excel in Just 10 Minutes
11:32
MS Excel - Conditional Formatting Part 1
10:42
Просмотров 1,2 млн
MS Excel - Data Sorting
9:05
Просмотров 891 тыс.
MS Excel - Shortcuts Ctrl+A to Ctrl+Z
12:17
Просмотров 985 тыс.
50 things you didn't know Excel can DO 💡
30:03
Просмотров 270 тыс.
MS Excel - Text Functions
9:49
Просмотров 1,2 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19
MS Excel - Pivot Table Example 1 Video Tutorials
15:05