MS Excel - Statistical Functions

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

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@Ykbarodiya]

Hi, Do we have excel sheets data available for practising in this course?

[@sandipkulkarni4104]

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]

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🙏

[@g.vivekanandagangaraju485]

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🙏

[@shallybhardwaj4733]

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]

101 % correct

[@satishpai7340]

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

[@saubhagyaswain9944]

Very Very USeful. Thank you, Sir and Tutorials Point (India) Pvt. Ltd.

[@AhJodie]

OMG, thank you for the easy clarification, gave me confidence!!!!!

[@snehasinghrajput108]

your videos are making "excel learning" so easy. Thanks sir.

[@Saimusiccreater04]

Nice comment dear👏

[@Saimusiccreater04]

Hello sneha ,i can speake with you ,why beacuse of i ask one dowt in this problem,thank you

[@rohabmuhammad7723]

Great lecture! you have taught us very well in a very easy method.

[@laxmandevadiga543]

You are really very good teacher.I learned lot off from you.god bless you.

[@sen-ow7ub]

I feel I have learned many new things from this video and you should keep posting new short videos everyday.

[@swetapadmasahoo8216]

Really helpful n like savior for me..thanks is not enough for you sir.keep helping us🙏

[@souravdash340]

Superb explanation If you want full knowledge of excel complete this playlist.

[@hanumantk7281]

Its really nice tutorials helpful in daily works -- Thank you very much

[@anilpanikar7774]

simple explanation - Hallmark of an Excellent Teacher

[@Ykbarodiya]

The way you teach is very simple and easy to learn. Thanks❤

[@Saimusiccreater04]

Thank you sir for giveing the best examples for statastical functions.

[@atulshukal4072]

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब प्रैक्टिस के साथ जय हो

[@beenanair2786]

good clarity in explanation. very nice.

[@asaidmohr7535]

Thank you very much, greeting from Egypt

[@jyotiprakashsingh3759]

thank you sir for this very worthful lesson .

[@lmshukla849]

i impressed for your explanation style.......keep it up. you are do well some special a day.

[@onwunzoGideon-dz5ex]

His teaching skills is out of this world 🤍

[@rakshadevi6282]

This is the right thing to teach​ people

[@AmitSharma-mx6qi]

Presentation is really good. thanks

[@ritznij7242]

all the presentations are really good and very easy to understand. good work. thanks for the videos.

[@nagaprakash7851]

Super sir Very helpful

[@zerogamer8343]

Kya aak number teaching skill hai

[@rockstarnayra6641]

Great work sir .... ...God bless u

[@jabirp.k1582]

IT WORKS, THANKS A LOT

[@abulkhayer5612]

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...

[@ujayapal8241]

Presentation method very good for easy understand

[@sikharaj970]

❤️ U deserve this!👍

[@manikantaperumalla8014]

sir u r really talented

[@DilwaleChawlaJi]

Seedhi baat no bakwas. Great tutorial.

[@akhitrai2717]

It does works. I am trying for long time

[@thevloglife105]

It was really nice tutorial.

[@nikulvadher701]

Great efforts 👏👏

[@princegaurea70]

All vedios are teaching sometging new Thank u Can you please arrange to provide vba vedios

[@clemechilella1830]

how the use of statistics function will help me with improve in my job and how to save time in arrange the fig well

[@user-yx3uu4ub8k]

You're great.

[@mdgulrez9187]

Tutorial point the way of learning

[@pragyansahu1024]

U r great sir

[@muhammadashraf6604]

Great sir Keep it up 💪

[@perumalprasath6012]

Most usefull for analysis

[@kalyanram7000]

Excellent work

[@shubhenduvikramsingh1377]

Sir aap great ho

[@Cafe_Sona...]

Thank you sir!!

[@docmitwa]

Hi, This gives result for John AND Monday; how to go about John OR Monday ?? Thanks in advance..

[@ezekielbenjaminsunday3174]

highly educative

[@muhammadumarkhalid3749]

Excellent 👍

[@kpkanna1529]

Sir ur clz is very useful but one doubt how to know the equation how can that apply in each question

[@karunakarreddy8129]

Great presentation

[@kevinsinghmakkad]

what is the name of touch interface you use in background

[@rakeshjoshi1425]

how to use countifs for 70. Please clarify

[@nakulpuri2294]

what should i do if i have to add for both mon and tue from one column

[@ziaullahzia3132]

Great lecture

[@saurabhkumarverma3714]

Thank you so much sir

[@komalkumawat3865]

thank you sir 😊😊

[@surabhimathurnigam5827]

what would be the formula when I want sum of those numbers which are less than 30 and also written against Mon & John?

[@brd8764]

It is stated for using because it is known as useful. It is also for personal relevance. It representation graphics.

[@manojgujar6286]

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.

[@shivansh7407]

Also try with "monday" in 2:03 just to be more comfortable with queries. (Not Case Sensitive)

[@selvanm2872]

THANK YOU

[@pankajgaurr]

What device are you using as the projected screen?

[@annalobacheva1900]

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....

[@amanbhargava2702]

Thank you😊😊😊😊😊😊

[@padmar5956]

Very nice

[@faeemahmad7790]

Good teacher

[@29ibrahimsayed95]

Thank you sir

[@rakesh9840]

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.

[@chinz26]

Do both the criteria’s need to be equal I mean in same row can’t it be in different row

[@prachi2830]

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

[@fayazahmed6537]

Hi Sir... Urgently looking to know why double code for numbers, hence it is used only for text.. Asap

[@mayurchauhan2065]

Nice explain

[@nagarajunetkal908]

Easily understand

[@cmakanhaiyajha8035]

thanks sir

[@nishashelar4261]

Please teach us how to use whatif analysis

[@som9135]

Are u using projector???

[@shikha4159]

when your financial function video comes

[@ruturapednekar7689]

Sir pls make video how to make receipt payment entries and day book

[@kellyoku]

Excellent work, but there is something wrong with my calculation

[@solankiashok5216]

This video very helpful But video in teacher action is not seen to screen

[@Saimusiccreater04]

Hello sir ,please explain the perform text functions for the given data using excel, sir please send the comment on link

[@vianerymgaya8834]

Are u using smartboard?

[@ashishbinjola3256]

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]

remove quotes for E5, directly mention E5 instead =countif(C4:C15, E5)

[@sudheerv5105]

And cant be used in Sumif formula for the same Qsn

[@ethiotelecomcreditassociat9350]

it is baste learning

[@ambikasarath1661]

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....

[@rakshaacharya9264]

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]

=if(A1="contractor", 1.2*dayrate)

[@rakshaacharya9264]

@@ksalikhan Thank you :)

[@sycogaming6656]

nice

[@vimalakumareson5668]

sir i need a ppt of your lecture

[@DeepikaSharma-fj1zr]

How to use countif for words

[@azmeerarajendar]

Sort it after the fomula

[@rishabhsaluja4921]

Who is this cutie?

[@khushpreetkaur1854]

Sir nice teaching but you don’t zoom your screen it’s difficult to understand.

[@growth_insightss]

[@Sanjeevkumar-pk1ks]

Sir struggling to find sum ifs answer please help sir

[@kousalyabalasubramanian6409]

Sir 2 table couldnot answer in formula

[@sunya926]

can I pay by debit card?? my paypal account is not working right now