Stats Formulas in Excel - Explained with Examples

In this video of this Free Excel Training, you will learn about the following STAT formulas:
-- AVERAGE function
-- AVERAGEIF function
-- AVERAGEIFS function
-- COUNT function
-- COUNTA function
-- COUNTBLANK function
-- COUNTIF function
-- COUNTIFS function
-- LARGE function
-- SMALL function
-- RANK function
-- MAX function
-- MIN function
✅ Download File - trumpexcel.com....
☕ If you find the videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com...
You can also access the Full Excel Training on KZbin here: • Getting Started with E...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@anshulagarwal3289]

It's 30th Dec 2021, I am glad that you uploaded excel course for free. It's not less than a treasure. Lots of thank you

[@nandinihiremath6851]

Thank you so much for explaining in details, browsed many videos but your video made me understand how a function works !

[@wayneedmondson1065]

Hi Sumit.. another great video covering Stats Functions in EXCEL. Thanks for the review and for sharing this video series for free. Thumbs up!

[@shtsh4rkie31]

the way you explained rules/how parts of formulas work [for example, what asterisks does within a formula] each time you went through a new formula, really helped drilled the info into the brain! i appreciate that. repetition is key to learning new things :]

[@shekhfaraj4478]

Thank you for giving us an amazing searies of excel with such detailing that other cant. I realy like your series of excel.

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@iliesboukhatem7803]

Thank you for this great video, it's very useful

[@Velu03121989]

Nice video "SUMMIT BANSAL" JI 👏👌👍

[@29miguel1996]

thanks for sharing this videos

[@asem7ali]

Are the functions Max and Large the same?

[@snehak2406]

diff is with large you can find kth( 1st or 2nd or 3rd) largest

[@shwetagoyal9279]

I tried =countif(range, "?*") for range filled with numbers, but it is showing 0. is it like "?*" takes only text and not numbers?

[@fayazmuhammad5983]

sir what is the difference between max and large function.

[@m-sgaming1441]

16:17 The date is in Cell A7 but you've choosen A2:A6..in that range only 2 Numbers come. How it becomes 3??

[@nishns]

While using the function he has selected A2:A7, its just formula mistake while typing in the left-most column. That's why its showing "3"

[@yashkulshrestha4931]

These video lectures of yours are getting boring day by day, no lying

[@hash_caul976]

🤣🤣right

[@anshulagarwal3289]

They are knowledge emitting tho:)

[@jimbim1623]

You want to see Sunny Leone dance in an Excel tutorial?

[@satyacharan1876]

​@@jimbim1623😂😂😂

[@buttheadrulesagain]

"this cell is not empty, however this has nothing in it" sounds like a philosophical statement :v