Excel's Average and AverageIf function with wildcards by Chris Menard

Average is a popular function in Excel. AverageIf allows you to set criteria for the average. Averageif has three arguments, and two are required. Averageif takes care of issues that the Average function can't handle.
For example, if you want to average outstanding invoices and some invoices have negative days and zeros since they are not due. Using the Average function will give you the wrong answer since it includes negative days and zeros. Averageif will take care of the negatives and zeros. Averageif will give you the right answer.
Chris Menard's website:
chrismenardtra...
This video is part of my training for Executive MBA students from the Terry College of Business at the University of Georgia. Here is the webpage for the 2018 EMBA training in Excel. chrismenardtra...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ TH-cam keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@ubaidillahmuhammad20]

useful knowledge. please put its excel file in the description ...